Surpress Action Query Alert

[james28]

Hello All!


In Access 2010, I have a very basic setup:

A table (of course!)
An update query (looks for a set of conditions and changes some data if condition is met)
A form (has a few comboboxes and a run report button)


A report that shows a chart based on all of the above.



I have everything working as I would like, with one exception. I have added


Private Sub Form_Open()
DoCmd.OpenQuery "UpdateOldQuery"
End Sub





When the form is opened, the query shoots off and updates the database. Well, that's the idea at least.

It would work, but Access kindly alerts the user and lets them know that what they are about to do could change the data and asks if they would like to continue.


I know that I can surpress this message using Access's options; however, it is my understanding that this is only good for the local machine. Is there some way, using code presumably, to suppress the message at the database level, so that absolutely anyone that opens the database/form will never get the message and it will always run?





Thank you in advanced!

[james28]

I was able to figure it out. It was easier than I thought!

Private Sub Form_Open()
DoCmd.SetWarnings False
DoCmd.OpenQuery "UpdateOldQuery"
DoCmd.SetWarnings True
End Sub



Cheers!

[June7]

This version doesn't require the SetWarnings lines:

CurrentDb.Execute "UpdateOldQuery"

[james28]

June,

I appreciate it. Thank you!