Turn Off Message Warnings

[BenSteckler]

I have an Autoexec Macro that runs 5 Make Table Queries. The problem is that When run the macro, I then have to Click "OK" on about 15 screens. Is there a way to turn off all the messages using a Module?

Thanks

Ben_Steckler@hotmail.com

 

[Atomic Shrimp]

You need 'SetWarnings False', but don't forget 'SetWarnings True' after the make-table queries.

HTH

Mike

 

[Talismanic]

Insert a line at the beginning of your macro and choose Set Warnings to NO then at the end of the macro set it back to Yes.

In VBA you can do it like this:

DoCmd.SetWarnings False

' Do a list of commands without warnings

DoCmd.SetWarnings True