How 2 run Action Query without being prompted!

[McWhorter]

I have a database that needs to run a few action queries. On my PC, I have "Unchecked" box in the Tools/Options/Edit menu for Action queries (Access97). That way it doesnt ask for comfirmation that running an action query is OK.

The problem is that all the users PC's have the "Confirm to run Action query" box checked. It would be a PITA to have all users uncheck that box.

Is there some simple code I can use to diable the prompt box.

 

[zambezibill]

Insert the following in code before running the query:

Docmd.SetWarnings false

After running the query, restore the warnings:

Docmd.SetWarnings True


Cheers, Bill

 

[McWhorter]

Excellent, I knew there had to be a simple way.

It worked perfectly on the first try.

Thanks.