[AccessD] Primary Key Violation

John Bartow john at winhaven.net
Mon Nov 17 17:02:51 CST 2003


Glad I could help!

JB

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gina Hoopes
> Sent: Monday, November 17, 2003 4:34 PM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] Primary Key Violation
> 
> 
> This is the perfect solution, John (the last part, I mean).  I can grab 
> their user ID from their logon and that eliminates the need for them to 
> enter it.  Thanks!!
> 
> Gina
> 
> 
> From: "John Bartow" <john at winhaven.net>
> Reply-To: Access Developers discussion and problem 
> solving<accessd at databaseadvisors.com>
> To: "Access Developers discussion and problem 
> solving"<accessd at databaseadvisors.com>
> Subject: RE: [AccessD] Primary Key Violation
> Date: Mon, 17 Nov 2003 14:41:29 -0600
> 
> Gina,
> Not sure I understand everything you're doing here but here's a couple of
> ideas:
> present a listbox or combobox of existing names to choose from, If they
> can't find it then let them add a new name.
> 
> If their name exists make them use a middle intial. If that 
> exists make them
> use the full middle name, if that exists make them add their 
> lucky number to
> the end, if that doesn't work then make them add their...
> :o)
> 
> If this is on their personal PCs add a column to the table which 
> holds their
> windows login then use that to identify them if its present and 
> then present
> their full name on the screen in a form they can relate to. (lookup their
> name for them based on windows login). If the login is not 
> present then make
> them enter a new name.
> 
> HTH
> John B.
> 
> _________________________________________________________________
> Frustrated with dial-up? Get high-speed for as low as $26.95.  
> https://broadband.msn.com (Prices may vary by service area.)
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 



More information about the AccessD mailing list