Access Automatic messages

[billheath]

Every time I do an Action query from code, I get 2 messages from Access. The 1ststates "you won't be able to undo the changes....Yes/ No" The user has to click on "Yes" each time. Then Access sends a message " You are about to update 72 rows." Here again the user has to click on "yes". My people find this annoying. They always answer "Yes" to each questions. I remember seeing a way to turn these messages off but I can't remember how.

Any help would be appreciated.
Bill

 

[MajP]

http://office.microsoft.com/en-ca/a...firmation-messages-on-or-off-HA102648329.aspx

 

[Knicks]

docmd.setwarnings false

docmd.openquery("somequeryname")
....
....
....

docmd.setwarnings true 'remember to turn them back on