Turn off confirm "record changes" and "action queries" for A

[chutcheson]

Is there a way to Turn off confirm "record changes" and "action queries" for ALL users in Microsoft Access 97/XP. Everytime a new user logs in, you have to turn these options off under every user profile, and this is really aggrevating. Any ideas?

Thanks
-Casey

 

[RoyVidar]

Hm - I have a tendency of using:

[tt]docmd.setwarnings false
' code triggering those **** messages
docmd.setwarnings true[/tt]

whenever I use such, but you could try something like this:

[tt]application.setoption "confirm action queries",0
application.setoption "confirm record changes",0[/tt]

- in the databases (on load of the first form?) which should set the Tools | Options - Edit/Find tab's confirm action queries and confirm record changes to false versions a97 thru a2k3.

Roy-Vidar

 

[chutcheson]

Thanks for the response, I should have stated that I would like to do the change without coding access. I was looking for more like a registry entry or something to prevent it from happening. Thanks again though!

-Casey