Append Query in background?

[PAULCALLAGHAN]

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?

 

[lynchg]

Are the prompts on the initial menu screen? Does the menu screen appear when the user first gets into the application? Are the defaults already set when the form containing those choices is opened?

 

[Remou]

You will need DoCmd.SetWarning, for turning off prompts, and either DoCmd.OpenQuery, or DoCmd.RunSQL for your query. You say you want the query to run every time the database opens and that you have a main menu, so I think the form open event of the main menu would be a good place to put your code.