Append query help

[dkbrostyle]

What i have done is created an append query which adds the data to another field. This append query copies primary keys to another table. I have set the other table to only accept primary keys therefore information cannot be repeated.

My problem is that a message appears say

"Microsoft Access can't append all records in the append query"

I would like to remove this message and write my own message saying that this record has already been added to the table, please press ok to cancel.