Disable confirm action query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For most tables, I can stop the action query warning message
via this code:
Application.SetOption "Confirm Action Queries", 0

But it does not work for ODBC linked tables to an IBM Informix database.
Is there a registry hack for this?

Thanks...
 
Try using this at each point where you run a query:

DoCmd.SetWarnings False 'disable warnings
DoCmd.OpenQuery "<InsertYourQueryNameHere>"
DoCmd.SetWarnings True 'enable warnings
 
Back
Top