Update/Delete Alert

[James.uk]

Is there any way to remove these alerts that say something like "You are about to update 1 record"? I have no need for them because I implemented my own alert.

 

[Oldsoftboss]

Under Tools -> Options, there is a tab labeled Edit/Find. On the right there are 3 check boxes under the heading of Confirm. These control the msg's you are talking about.

HTH

Dave

 

[James.uk]

Thank you

 

[Mile-O]

The advised step would to be to turn them on and off with code rather than in the Options otherwise you might get miss out on a message that's important.

The way to turn off and on, for example, is:

DoCmd.SetWarnings False
DoCmd.OpenQuery "MyUpdateQuery"
DoCmd.SetWarnings True