keeping users from choosing the wrong answer...HELP

[JennW]

Is there any way to have a database run an append or make table query and not give the users the option of choosing yes or no when asked?

I would like for an unattended event to occur. When running the queries, I would like for them to automatically run without showing any information to the end-user.

Is this possible?

thanks!

JennW

 

[papparuff]

Yes,

Use DoCmd.Setwarnings false before you run the queries but make sure you DoCmd.Setwarnings true before you exit the procedure. John Ruff - The Eternal Optimist