Turn off confirmation boxes

[Cavern]

Is there a way to turn off the confirmation boxes when I run query? You know, the ones that say 'You are about to update/delete/whatever to blah blah blah.." with the OK buttons..

I'm making a bunch of automated querys run, and its really annoying to have to click through all those damn 'OK' buttons .
I'm sure there's a simple way, but I can't figure it out...

 

[[nateobot]]

If you are using a macro to run the queries in succession you can choose macro option "SetWarnings" and set them to off.

Otherwise bring up the Options box. Go to Edit/Find tab and uncheck the box that says Action Queries.

 

[everblue]

or if you use VB code. write the following


DoCmd.SetWarnings False

 

[DBL]

remember to turn them back on again:

DoCmd.setwarnings false

DoCmd.Openquery, blah, blah

DoCmd.setwarnings true