Results 1 to 3 of 3
  1. #1
    ariansman is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2013
    Posts
    57

    How to prevent duplicate data

    I am putting the student names in a form. I want it to alert me that a name is duplicated. But thats not this simple. For example a name is “Jennifer Locus” but I type “jenifer” with one “n”. Can access guess that this might be the same person and suggest me to correct the spelling or enter it as a new person?




    Thank you

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    See this link for more info on database and design

    If you do know design, then see this for "similar"

  3. #3
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    No, I fight this battle from users all the time. You cant guess what they mean.

    You could pull a fuzzy list of names
    select * from tNames [lastN] like txtLast & "*"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Prevent user adding duplicate data in form
    By littlejnz in forum Forms
    Replies: 1
    Last Post: 06-30-2014, 08:28 AM
  2. How to prevent duplicate records
    By talktime in forum Programming
    Replies: 7
    Last Post: 05-15-2013, 11:02 PM
  3. Dcount prevent duplicate
    By ayamali in forum Programming
    Replies: 20
    Last Post: 04-16-2013, 09:31 PM
  4. Prevent duplicate dates
    By bishop0071 in forum Access
    Replies: 1
    Last Post: 01-09-2013, 09:04 PM
  5. Prevent Duplicate Entry
    By kilosierra71 in forum Forms
    Replies: 4
    Last Post: 07-28-2011, 03:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums