View Full Version : Automate queries in macros


N Kruidbos
12-15-1999, 02:19 AM
In a macro running a series of update queries, is there a way to disable the dialog boxes so that the macro may run unattended. I also need to do this for the other types of queries.

Travis
12-18-1999, 11:15 PM
Yes,

At the beginning add the line
SetWarnings (Value No)
Then at the end of the macro Add the line SetWarnings (Value Yes)

Note: If you don't turn the warnings back on you will get no warnings from Access for anything after the Macro has run.