Circumventing system message

[PaulA]

I have a event procedure that imports data from Excel files into DB tables. It works fine with a error handling system that performs when duplicate data is detected.

However, I also get what appears to be the database system message about "Microsoft Access is not able to append records" when duplicate data is found.

Is there a way of not having this message appear? The error handling system works when the user clicks "No" to continuing in the problem append message. But there would be a problem if the user accidently clicks "Yes."

Is there a way to not have the append message appear or to change it's structure to only have one option for the user?

Thanks.

 

[ghudson]

You need to disable the warnings.

DoCmd.SetWarnings False
'Your code here
DoCmd.SetWarnings True

Ensure that you turn the warnings back on.

HTH

 

[PaulA]

Tried it but...

Thanks for your response.

I gave it a shot and the message didn't appear but the program acted as if the user had clicked "Yes." My error-handling was circumvented.

The program went to it's conclusion (move the successfully imported file to a new location) although the import was not successful.

Any thoughts?

Thanks.