G Guest Aug 10, 2005 #1 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)
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 Aug 10, 2005 #2 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.
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.
