Results 1 to 3 of 3
  1. #1
    Join Date
    May 2012

    Unanswered: 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 that's 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
    I asked god to please give me everything to enjoy the life, God said: i gave you the life to enjoy everything.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    consider using one of the name coding structures such as Soundex or probbaly better, the more recent double metaphone approach
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    @healdem has given you the only approaches for this, but you need to keep in mind that there are very, very, very few unique names! You'd be far better doing this against something like a student ID number.

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts