Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to turn off record changes confirmation 1

Status
Not open for further replies.

moepower

Programmer
Oct 5, 2000
93
US
What commands could I use to temporarily turn off Record Changes, Document Deletions, and Action Queries confirmation? I have a few queries that I want to run in an Event Procedure and I do not want Access to prompt for confirmation. Once the procedure is done, I DO want to turn the confirmation back on.

Thanks
 
DoCmd.SetWarnings False
DoCmd.OpenQuery "import_work_order", acNormal, acEdit
DoCmd.OpenQuery "import_work_order_printer", acNormal, acEdit
DoCmd.OpenQuery "import_crank_work_order", acNormal, acEdit
DoCmd.SetWarnings True
Mike Rohde
rohdem@marshallengines.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top