Where can I find a master list of all the Access 2000 macro actions and
associated arguements?
For some reason not obvious to me; I can not locate a master list in the
access help files???

I am looking to make a macro or vba that will run only when the first person
will access the database.  And not run after more than one user is logged
into the database.
As background I am looking to make a database that whenever it is initialy

Does anyone know how (if) you can add worksheet(s) to an existing Excel
workbook using an MS Access 97 macro?

I have made a macro which consists of a couple of make table and delete
queries. When I run the macro, every time the macro hits one of these
queries, it asks me to validate whether its OK to make or delete the table
just as it would have if the query had been running on its own. ...

I am running a macro which will open a report.  This report is based on a
parameter query.  Can I use the sendkeys function to respond within the macro
to the dialog box?

In Access 2000, my database opens with an AutoExec macro.  This macro opens a
form called Main_Form and then maximizes it.  In startup properties
(Tools|Startup), Display Database Window is unselected.  In Main_Form,
Command Button #1 receives the initial focus in the tab ...

I am very new to Access and have recently built my first database (using
Acess 2003), the purpose of which is essentially to enter our client firm
records and the details of related contacts within each firm.  Firms can have
more than one contact.

Please help with using Access’ iif on SQL server. The following query works
perfect on Access but NOT on SQL server. I tried to use CASE to replace iif
to no avail, possibly because iif stmt could be equivalent to null. Thanks a
lot in advance!!

I am able to use the task manager to open up the access database using:
"\\material_management_sharing\nodeissues(copy).mdb"
But from here I am not sure how i am suppose to get the macros to start
running with out going in and running them myself. In an answer to someone

Please let me know how a macro can me made to skip the prompts associated
with a make table/delete table query

I have create a table records that ave anique id number such as 7.5-6-ND or
7.5-6-D
Now i need to refer to this number but only the characters after the last
"-" ie ND or D etc...  Can we program the databse to return this characters

I'm trying to write a macro that will allow me to find a specific record in
"Form A" by matching two fields in that record to two fields in "Form B".  
(This by using the [forms]![formname]![fieldname] expression as the
argument.)  "Field A" is an interger, and "Field B" is a ...

I have a database with a field (pull down list) of stores. I have another
field for miles. I'm trying to use the setvalue macro to make the miles field
read the store field and display the correct miles for the store the user
selects. Would the setvalue be the best option for ...

I've done macros in word and excel. I really like those because I always
record my keystrokes first them edit it later. Gives you a starting draft.
Obviously there is no way to do that with access (right?).
This is at work where I'm doing this(Access 2000). Left access open on

I would like to make a macro that sends multiple queries to an email address,
how can that be done? Output format is an excel output.