[AccessD] OT: Primary Key Violation

Here we go again (<:

Sorry Gina its a sort of in joke.No  offense intended.

But out of interest we have three Martin Reids in work. How would you create
the PK then?

Martin

----- Original Message ----- 
From: "Gina Hoopes" <hoopesg at hotmail.com>
To: <AccessD at databaseadvisors.com>
Sent: Monday, November 17, 2003 10:41 AM
Subject: [AccessD] Primary Key Violation


> I've got a seemingly stupid question, but I can't figure it out.  I've got
a
> form that collects a staff member's first and last name and uses that
> combination as a primary key (unfortunately, no one can remember their
> employee ID and we don't collect SSN or anything unique they could enter).
> If they violate the exclusivity of that first/last name combination, they
> get the convoluted error message that Access puts out which only serves to
> confuse.  Is there a way for me to replace that message with my own and,
if
> so, how do I check for the violation and where would I put the error
> message?  At the moment it comes up when they click the "done" button,
which
> seems like a good place.
>
> Thanks,
> Gina
>
> p.s. Please don't chastise me for perceived primary key protocol
violations.
>
> _________________________________________________________________
> Send a QuickGreet with MSN Messenger
> http://www.msnmessenger-download.com/tracking/cdp_games
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>