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.
|
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. |