Update queries Update message

[Mark Richardson]

I am trying to stop access displaying the "You are about Update 1 Record" etc message when i run an update query. I know i can do this in Tools/Options screen but the problem is that the database is going to be used by multiple users, and rather than changing each persons Action query option I was wondering whether there is something i can put in to the code Globally to halt the message.

Any help would be appreciated.


Regards
Mark

 

[MStef]

Hello Mark!

In Sub where you start a query put this:

DoCmd.SetWarning False
DoCmd.OpenQuery..................................
DoCmd.SetWarning True

 

[Len Boorman]

Alternatively put
Application.SetOption "Confirm Record Changes", False
Application.SetOption "Confirm Document Deletions", False
Application.SetOption "Confirm Action Queries", False
Application.SetOption "Show Hidden Objects", False
Application.SetOption "Default Open Mode for Databases", 0

within say the On Load property of your Opening Form.

Does everybody each time they open the database for all situations

Len