|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 17th, 2009, 06:55 PM
posted to microsoft.public.access.forms
|
|||
|
|||
eliminate Duplicate entries
I have a DB for tracking workorders, I want to notify the operator when they have entered a duplicate work order number.
Conditions Table name: WorkOrder Field Name: WO The WO field is the primary key for teh table and I've selected duplicates no for the field. I used the table to create the form, and want to generate a error message when a duplicate owrk order is entered in the form field. Presently, the at entry, the form closes and if the work order number is a duplicate, the new entry is trashed with no indicateion to the operator. EggHeadCafe - Software Developer Portal of Choice ..NET GDI+ - Draw Tree / Hierarchy http://www.eggheadcafe.com/tutorials...w-tree--h.aspx 
|
| Thread Tools | |
| Display Modes | |
|
|
Threaded Mode