Disable confirm action query

T

TedGrier

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...
 
B

Brian

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

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