Results 1 to 1 of 1
  1. #1
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010

    Customer Entry/Find Duplicate/Similar names

    The following is an example of a customer entry system which will find similar names (ie. the first character of the first name matches and the last name matches exactly.) If it does find a similar name, it opens a form which let's you select one of the similar names.

    Otherwise it then searches for an exact name match and will prompt if found.

    Also coded to show you the previous name you entered and also proper cases name/address fields and will set the default value of the city to the last one entered.

    I hope you find this example helpful.

    *** If you have problems opening the MSAccess file in the zip attachment, make sure to add this website to your intranet security in IE to be able to open any MSAccess files within a zip download.

    Last edited by pkstormy; 08-28-2010 at 02:28 PM.

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

Similar Threads

  1. Replies: 3
    Last Post: 06-04-2010, 12:47 PM
  2. Sorting by customer
    By eibooo in forum Queries
    Replies: 1
    Last Post: 05-25-2010, 12:00 AM
  3. create a query to find names not entered
    By tomClark in forum Queries
    Replies: 4
    Last Post: 02-24-2010, 10:58 AM
  4. Replies: 1
    Last Post: 01-22-2010, 03:21 AM
  5. Replies: 1
    Last Post: 08-19-2009, 01:14 AM

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 - Senior Forums