View Full Version : Automate queries in macros


N Kruidbos
12-15-1999, 03: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-19-1999, 12:15 AM
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.