Results 1 to 2 of 2
  1. #1
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643

    Not in list event and spelling errors

    I'm just thinking out loud on this.
    There was a recent post on one of the forums ( i dont remember which one and cant find it again) where the proposed solution was using the not in list event. The proposed solution contained a warning that allowing users to add to lookup tables may result in duplication due to mis-spellings and such. I agree thats a valid concern and was curious how I could limit the chances of that happening. In some of my apps where not enterring duplicate people is a must, I use a procedure which uses the levenshtein distance and soundex to check for possible duplicates. I thought I'd try applying it to my NIL procedure.

    I dont use the NIL event very often so I'm not sure how this would work across different types of data. In the attached example I used a list of cities. If you mis-spell the name of a city the message box shows the possible duplicates before adding it and allows you to cancel the addition.

    Any thoughts?
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    People names are the bane of all data integrity. You cannot stop people from entering bad data.
    I have use enter name,
    show a list of existing name/city/st/etc...
    if name is not on file, create new
    or use existing.

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

Similar Threads

  1. Replies: 1
    Last Post: 07-27-2018, 10:34 PM
  2. Replies: 3
    Last Post: 09-15-2017, 05:06 PM
  3. Replies: 4
    Last Post: 06-21-2014, 05:43 AM
  4. Replies: 3
    Last Post: 03-28-2014, 04:46 PM
  5. List Box Click Event
    By bginhb in forum Forms
    Replies: 3
    Last Post: 04-09-2012, 02:06 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