run queries automatically without violation

[juniorreidirie]

Hello, I have a series of append quieries which I would like to run with our
returning a key violation error. I have set the primary key in the table in
order to limit the number of new records. Is there a better way to do this or
can someone tell me how to FORCE the yes accept button automatically when the
query returns a violation diologue message. thx.

 

[Douglas J. Steele]

Try putting SetWarnings False before you run the query, and SetWarnings True
once it's completed.