MS Access turning MSG Box off

Topic

New Reply

Running a macro that opens a number of queries but I want to turn the msg box off while they are running and turn them back on when finished. This way the queries can run continuously without interruption

Thanks

Reply | Quote

Replies

In either VBA or in a macro you can turn the warnings on and off. See SetWarnings for the details. One caution, be sure to turn them back on after all of the queries have been run.

Reply | Quote

Not sure if macros allow error handling these days, but if you’re using VBA make sure you turn warnings back on within an error handler, otherwise they’ll be left off if an error occurs in the code!

Reply | Quote