Check for duplicate data

[4808]

Hi,
I need help on how to get Access to display a message if the data being input already exist in the database. Just to avoid duplication.
Many thanks

 

[PHV]

Either use a unique index to let access doing the job or take a look at the DLookUp or DCount function.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mph1]

Have no idea what your database consists of or its purpose. A word of CAUTION.....

finding dups or trying to eliminate is a good idea, however, once it occurs, you should want to know why!

My experience has taught me that there is no substitute for the human thought process especially since nothing is perfect.


Just thought I would add my 2 cents.


An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Autonumber Description thread 702-5106

 

[coachdan]

Agree with mph1. You need to ask questions of your users and see if there is a reason for the duplication. Many times it will lead you to a problem that exists in your process.

coachdan32

http://www.highviewheat.com/index.asp

http://www.kristensfastpitchworld.com/index.asp