Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to make a Field Reject a Duplicate

Status
Not open for further replies.
tekbrian

tekbrian

Programmer
May 1, 2011
26
US
I have a table in access 2003..I need access to recognize that when you enter in a new record that it is already somewhere in that field and reject it and let you know that it is already in use as soon as you enter it.

any help would be much appreciated

Thanks
 
Sort by date Sort by votes
I know that was a easy question..I'm new at this

Thanks Randy
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

I
  • Question
How to get 2 codes to work together.
Replies
6
Views
368
hermanlaksko
hermanlaksko
caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
489
Andrzejek
Andrzejek
MattGreer
  • Locked
  • Question
Add Field Description to a Form 2
Replies
5
Views
294
Andrzejek
Andrzejek
BJZeak
  • Locked
  • Question
Struggling with finding an answer to a simple question
Replies
5
Views
494
BJZeak
BJZeak
caykamanj1966
  • Locked
  • Question
Hyperlink Text of a field
Replies
1
Views
191
caykamanj1966
caykamanj1966

Part and Inventory Search

Sponsor

Back
Top