Turn off update warning

P

pokdbz

How do you turn off the updates warning when a field is going to be updated
and it asks you if you would like to update it (yes, no)
 
F

fredg

How do you turn off the updates warning when a field is going to be updated
and it asks you if you would like to update it (yes, no)
Click to expand...

If you are using VBA to run the query:
DoCmd.SetWarnings False
DoCmd.OpenQuery "QueryName"
DoCmd.SetWarnings True

If you wish to turn Warnings off always (not recommended):

Tools + Options + Edit/Find
Uncheck the Confirm Action Queries check box.
 
Top