Help with append query 1

[PAULCALLAGHAN]

I'm not sure what help group this question belongs to.

I'm using Access 2000, and have developed a simple database with a front end main menu screen. The user simply click on buttons to run queries and reports.

I have a simple append query on a button but I would like to set it up as a macro that runs everytime the user opens the database.

How can I do this? I also want this to run in a 'silent-mode'. That is, I want all the prompts to be answered to their defaults.

This query updates a part master table that is based on the main system part master table. I only want a smaller version of this table, and the other problem is new parts added to the main system part master table. This append query updates the smaller part master table for new parts.

Any help would be greatly appreciated?

 

[Remou]

You will find a couple of replies at:
Append Query in background?
thread701-1192701

 

[fneily]

You can use a special macro named AutoExec to carry out an action or series of actions when your database first opens. When you open a database, Microsoft Access looks for a macro with this name and, if it finds one, runs it automatically.

Create a macro containing the actions you want to run when you open the database.
Save the macro with the name AutoExec.
The next time you open the database, Access runs this macro automatically.

If your macro starts with Echo set to No, SetWarnings set to No then Openquery, etc. the system prompts won't appear. Reset Echo and Setwarnings to Yes at end of macro.