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