How do I prevent the violation error from an append query,from sho

G

Guest

I want to turn off the violation error shown after I run an append query. It
displays due to key violation; which is what I wanted, but I do not want the
error pop up from displaying.
 
G

Guest

If you are using code

Docmd.SetWarnings False
Docmd.OpenQuery "QueryName"
Docmd.SetWarnings True


*** Note: it is important to set the warnings back on after the query is
executed ***
 

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

Manage append query key violations? 4
Access 2003 Append query Key violation error 1
key violation on append query 3
Append to table with 2 fields in Primary Key - last is an autonumb 1
Action Query (Append) didn't add records due to key violations. 5
Key Violation Error in Append query 1
Append Query isn't working 2
Append query key violation 8

Top