Disable Error Message when using DoCmd.RunSql

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Geoff - 12 Jul 2005 21:45 GMT

How can I supress the message saying that my app can't append all records
due to Key Violations? I only want to suppress the message and allow the
query to run anyway.

Reply to this Message

Ofer - 12 Jul 2005 22:15 GMT

If you running the query through code then add the syntax
docmd.setwarnings False ' before excute the query
run query here
docmd.setwarnings True ' dont forget to set it back to true

> How can I supress the message saying that my app can't append all records
> due to Key Violations? I only want to suppress the message and allow the
> query to run anyway.

Reply to this Message

Tim Ferguson - 13 Jul 2005 18:26 GMT

"Geoff" <cbsinc@earthlink.net> wrote in news:EZVAe.4183$BK1.1137
@newsread3.news.pas.earthlink.net:

> How can I supress the message saying that my app can't append all records
> due to Key Violations? I only want to suppress the message and allow the
> query to run anyway.

Clean the incoming data first. You could join the old table to the new
table on the primary key and find matching records. You then have to decide
what you want to do with matches: overwrite the old one, drop the new one,
ask the user, etc etc.

Hope that helps

Tim F

Reply to this Message