Suppress Action Query Messages

[Henley12]

I have a form where I am running several queries at the press of a button. My second Make-Table query gets the usual 'this table will be deleted' blah, blah, blah. I have the Confirm Action Queries unchecked in the database options, but I am still getting the message. Is there a way to manually suppress such a message?

 

[KeithG]

docmd.setwarnings False

...
...

docmd.setwarngins true


Make sure to turn them back on when you are done running your queries.

 

[Moniker]

Also, using CurrentDb.Execute will skip the messages without having to SetWarnings off and on.

 

[Henley12]

Thanks

Thanks very much for your quick replies. I knew the problem was simple to solve, but couldn't remember the answer.