Append Action Query Code not on List

[siskoray]

Hi all,

I did figure out how to get my table of errors, however, the actual message I'm trying to find isn't on the list. I'm looking to disable just the message I receive when I run an action query append through code that states "Microsoft Access Can't append all records....# not appended due to null values ...."

I would like to have the "OnError" address this specific error to state "A duplicate record was found. Either you incorrectly typed in the ID# or someone else has already requested that ID#"

Thanks for any help.

 

[Rich]

How will you have null values if the ID already exists and would it not be better to validate the entry before attempting to run the append query? Give some more details of what you are trying to do.