Append Query in VBA

[LewisWA02]

I'm running an append query in VBA, but would like to disable the prompt after it begins running. Right now, when the query runs, it asks the user to select yes if it's really what they want to do. I want to have it automatically select Yes and move on. Any suggestions?

Billy

 

[pbaldy]

Use CurrentDb.Execute with the appropriate arguments, or use DoCmd.SetWarnings, making sure to turn them back on after running the query.

 

[LewisWA02]

"docmd.setwarnings" worked perfectly. Thanks for the help.

 

[pbaldy]

No problem. Hopefully you took my advice to turn them back on at the end of your process.

 

[LewisWA02]

I did. Thanks for asking.

 

[pbaldy]

No problem. You'd have been back asking why when you made design changes to a form, the program no longer asked if you wanted to save them when you closed it. SetWarnings suppresses those too.

 

[Galaxiom]

SetWarnings False also supresses warnings about update and insert failures.

Execute is the way to go.