N
N Kruidbos
Guest
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
Registered User.
- Local time
- Yesterday, 23:15
- Joined
- Dec 17, 1999
- Messages
- 1,332
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.
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.
