Data Entry

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 09 Dec 2006 16:30 GMT

I am currently inputting codes from a product list, some codes every so
often are the same, is there a way ms access can flag up if i've
inputted the same code in? I don't want to be inputting the same codes,
this would save alot of time.

Dave

Reply to this Message

keri - 09 Dec 2006 16:43 GMT

Dave,

Set the Indexed properties of the field in the table to "Yes - No
duplicates"

Eg. go to the table in design view and and changed the Indexed property
to No duplicates as above. This will prevent you having 2 records the
same in this field.

> I am currently inputting codes from a product list, some codes every so
> often are the same, is there a way ms access can flag up if i've
> inputted the same code in? I don't want to be inputting the same codes,
> this would save alot of time.
>
> Dave

Reply to this Message