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

  • Thread starter The Dummy in Access for Dummies
  • Start date
T

The Dummy in Access for Dummies

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
 
J

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
Click to expand...

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]
 
Top