What's the best way to make a button print *just* the selected
(displayed) record of a subform, when that subform is currently part
of a larger form?
Thanks!

One of a queries properities is 'recordset type' and it defaults to
'dynaset'. If I have a query which is just a select query is there any
advantage to setting that property to snapshot?
will I get an increase in performance?

    I'm having quite a bit of trouble with code to create linked tables in
Access 2K.  I create a DAO tabledef using CreateTableDef against a DAO
database object, then set its connection string appropriately.  The
trouble is when I go to append the tableDef to the collection I get

I received a message in another newsgroup saying that I shouldn't top-post
my replies. I always top-post, because I feel it's easier for the reader to
see the reply, rather than having to go to the bottom of the previous
message. But, since this is the main newsgroup I post in, I ...

I am trying to setup a query
that will count the folling for me
I have the following data example
That i have put over from a field i have filled

Adobe has WAY to many forums and I wasn't sure which was correct so
thought I'd try here first.  I'm trying to see if there is a product
that will allow us to create a large (1,100 pg) directory, similar to
creating one with MS Word.  We have Access tables and want to create a

I have the following address fields in a table:
flat_number
house_name_or_number
street

I have managed to map an FTP site as a drive on my computer ( I think - not
sure if it is really mapped - although it appear with the rest of the mapped
drive on my system, there is no letter assigned to the FTP location in the
explorer tree ) but when I try to link to a backend ...

I recently asked the DBA of the SQLServer database that I use to add a
field and set the 'allow zero length strings' to No.
after a couple more emails back and forth I got this one
"SQL Server does not support a Zero Length String. The only way to

I have a database that is used by many users. I want to monitor who uses what
form and or clicks on certain buttons.
Does anyone know of a untility that I could addon that would perform these
tasks?

I'm currently developing an MS Access Data Project (.adp) in MS Access
2002.
One of the reports within the DB uses data that is Dynamic and cannot
be stored on the SQL Server. To resolve this, I have created an

I'm still using MS Access 2K3 and DAO 3.6 objects (I know, I know, I'm a
dinosaur)...
I'm traversing through the fields of a table to retrieve their data
types, thus,

I need to do a query and limit it to returning 10 rows at a time.  I
can't rely on dynamic cursors or anything like that because I can't
keep a cursor open between each query.
I know I can use "SELECT TOP 10" in my SQL statement to get the first

I'm not that experienced in Access so am turning to the experts for some
basic help.
I have the following fields in a table :
Name            Type

I recall reading somewhere about a function or property that returns the
height of a window's title bar, but can't recall. Anyone know off the top of
their head what that is? Thanks!