How do I turn off the error (violations) messages in an append que

[Guest]

When I run an append query, there are some records that can not be appended,
due to key violations; which is what I want it to do. But how do I prevent
the pop up message from appearing

 

[John W. Vinson]

When I run an append query, there are some records that can not be appended,
due to key violations; which is what I want it to do. But how do I prevent
the pop up message from appearing

How are you launching the query? From code, from a macro, from a command
button, from the query window?

You can turn off warnings in any of these circumstances but you do so
differently in each...

John W. Vinson [MVP]