Hi - I have a form that transfers data from one table to another, one of the fields is used as the primary key, therefore unique. When the form runs the append query I get the following windows error message
Database can't append all the records in te append query -.......
...due to key violations, which is what I need, but the problem is that users click "Yes" instead of "No" that I require to prevent other events from occuring.
Is there a way to disable the windows message and substitute a more meaningful message telling users exactly what is required
Thanks in advance
Peter

Why do you want to flash an error at your users if you have key violations? Why transfer the data between tables and take the key with you? Why not leave the key in the old table and take the new one the new table is trying to give the record? If you need to refer back to the first table's PK, then keep the PK from the first table as an FK in the new table, so you can refer back to it, and take the new PK in the new table.


mmcdonal

Hi - Thank you for your reply - I do appreciate what you say - but the setup I have is - I have two tables with identical data one holds current contracts where the registration number has no duplicates because I do not want two contracts for one vehicle. The other table has contracts that are pending awaiting certain verifications. When all is okay the data is transfered into the main table. The key violations are occuring when a record with a duplicate registration number is attempted to be moved.
What I want is to warn users of this and to prompt them to check the information
I hope that makes some sense
Peter

Why have two tables?

Why not a Yes/No field or, better yet, a date field. The date field would hold the date of verification. If no date, it means it's pending. You'd have one table. You can always query on this date to separate pending from verified.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division