Disable confirm action query

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

Guest

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

turning off action queries 3
Supress 'Record is deleted.' warning 4
Access 2000 Runtime, Error 0
2007 accdr Confirm record changes doesn't go away 2
Confirm action query runtime option 1
filesearch on FTP site 1
linking tables via ODBC 2
********************** Action Query Assistance **************** 8

Top