Surpress Append Query Pop Ups

[gopherking]

Ok, I know that you can go into the Access Options and uncheck the Confirm Action Queries under the Advanced section to prevent the Pop Up dialog boxes when you run an Append Query, but I am curious to know if there is a way to prevent them without unchecking this box?

 

[jdraw]

You can use
Currentdb.execute YourActionQuery_sql,dbfailonerror

But you should do a little research first as Action queries will affect your database.

You should insert some Debug.print of your sql before actually running the Action and confirm your sql syntax etc. A slight error in a WHERE clause could impact a lot of unintended records.

You could investigate the Docmd.setwarnings also. But understand what it is you are doing -- better to do the work before you make the unintended changes....

 

[gopherking]

Thanks Jdraw ... I am only appending records to another table, which will be few and far between so there shouldn't be any major concerns, but thanks for the heads up. I was able to use the following to get what I was after:

Currentdb.execute "YourActionQuery", dbfailonerror