I am working an an app developped in VBA/Access, and I would like to
call a macro (named AutoExec) directly from the VBA code of my
program.
I tried the following :

I have created a <filename>.db1 (where <filename> is the name given to
the database) Access database that is being used in multi-user mode.  
When the <filename>.db1 file is opened by a user, the corresponding
locking file appears in the Windows Explorer view pane as well as

I want to select a Job Number and Revision from a combo box (cboSelectBOM).
I then want to open a form (frmBoM) and display the record for that Job
Number and Revision
When I double-click on the job in the combo box, I am running the following

2 months I had first page organic results and they delivered on every
key term I wanted so here they are http://www.atomicsearchengineoptimization.com
or you can go straight to their contct page to get a great free report
and a friendly call back. http://www ...

I have just sat up a database that has 2 - 10 users at any given
time.  Everything is running smooth, however when someone's computer
goes into standby it seems to lock everyone else out of the database
and prevent changes from being made.

I've been looking at the above API, which does indeed bring up the
OpenFile dialogue and place it into an unbound text box, but i am
having so much trouble getting it to work for my purposes. My Db has
tables that link to external images/documents and so i want a user to

I have a form with a subform. Main form is attached to table of
branches of our company, and sub form is attached to an orders table.
Two tables are linked through branch id.
When a user edits an order line the entire branch record is locked,

I hope someone can offer up a suggestion with regards to this problem.
I have two user sites, running Citrix (Metaframe 4.0) on Windows
Server 2003. Both are experiencing similar problems using an Access
application.

I'm hoping that someone here can give me some assistance with a
database I'm trying to set up. My skills in Access are fairly basic,
and I'm trying to skill up, but some of the stuff is a little opaque.
I'm trying to put some data I've got on paper into Access. Recently,

I have two tables: table A (parent) and table B (child) which have a
one-to-many relationship. Fields A.1 and B.1 are both the primary key fields
of tables A and B, and each is an autonumber field. Field B.2 is the foreign
key field which links to field A.1.

I have frmMinutes with all fields diabled on load except for an option
group that I use to toggle on the correct fields depending on option
chosen.  Each choice works as designed but if I switch back and forth
between the two the fields do not go on and off as I thought they

What is the SQL to count the number of null values in a specific
column in a table?
I knw this must be simple but I've been Googling this for a long time
and have not the SQL to do this.

I have query1 where I set a date range. Query2 is a crosstab query and is based on query1. I don't want the queries to be saved in the mdb but I do want them to be run in VBA using a querystring. If I only put query2 in the querystring it refers to query1 which is not available ...

I use access 2000 on WinXP
In an MsAccess module I've a variable which contains an ascii text
which could form a valid RTF document. Now I want my module to create
a new instance of MsWord which shows the RTF document. I've managed to

I have query1 and query2. Query2 is based on query1. I would like to build those queries in a string in VBA and then execute them. In query2 there is a reference to query1. How can I change this reference to the querystring of query1 build in VBA?
Thanks,
John