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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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 ***
 
Back
Top