BuckBMD,
What you have ran into is something that I have ran into before and dealt with: there are several sets of properties in Access, and you have to make sure that you are saving and retrieving to/from the correct set.
The following will both set properties on a database...
From a performance standpoint, if you are dealing with a large number of records processed by a select query that runs frequently, you may want to rework your db to use a make table query where you control how often you update the output table. In that case, loading the output table would...
I think the command you are looking for is:
DoCmd.RunCommand acCmdSelectRecord
Just make sure that you are "on" the record you want to select... Since you are setting a checkbox, I assume that you are already doing this, but if not, you may need to do a me.recordsetclone.findfirst...
dkuzminski,
Microsoft Query is an "Add-In" piece of software that comes with MS Office... you should already have it on your machine, unless it was not installed with MS Office for some reason. What it does is provide very basic support for queries of external databases by MS Office...
I am trying to do mail merges using some Word 2002 docs with Access 97 queries. I want to use queries, if possible, to eliminate the need for maintaining temporary tables in Access just for the mail merge.
I cannot change the versions of the software, this is what I have been given to work...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.