how to check whether the entered data is present in table or not

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

anand - 21 Jun 2006 12:16 GMT

Hi
can any one help me hoe to check whether the data entered in the text box is
already present in the ms access (mdb) table to avoid duplication.
I have a table and a form to enter data in to the table .
Duplicate values should not be entered.I am new to ms access.
Please help me

Reply to this Message

Keith Wilby - 21 Jun 2006 12:52 GMT

> Hi
> can any one help me hoe to check whether the data entered in the text box
[quoted text clipped - 3 lines]
> Duplicate values should not be entered.I am new to ms access.
> Please help me

Set the field index to not allow duplicates at table level.

Regards,
Keith.
www.keithwilby.com

Reply to this Message

Yanick - 21 Jun 2006 12:57 GMT

If you set your table primary key and your form is bound to either a query
(based on your table) or the table it-self, an automatic error message will
occurred if duplicate is created.

> Hi
> can any one help me hoe to check whether the data entered in the text box is
> already present in the ms access (mdb) table to avoid duplication.
> I have a table and a form to enter data in to the table .
> Duplicate values should not be entered.I am new to ms access.
> Please help me

Reply to this Message