unable to append... key violation... message box

[Coolpapabell]

Is there anyway that I can suppress / disable query warning messages about not being able to append all data asking if you want to continue even if ## records were lost to key violations.



I want the query to execute and add the records it can regardless and I don't want the user responding to message boxes.

Thank you

[RickM]

Did you try the code DoCmd.SetWarnings False before the run query command?

[RuralGuy]

CurrentDB.Execute does *not* issue warning messages and any errors can be trapped with error handling code.

[Coolpapabell]

Thanks you kindly for the help!

The docmd.setwarnings did the trick.

I also appreciate the heads up regarding CurrentDB.Execute commands and know that I should look more into them.

Thanks again

[RuralGuy]

We're both glad you got it sorted. Thanks for posting back and using the Solved tool.