Results 1 to 3 of 3
  1. #1
    zul is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Aug 2011
    Posts
    4

    check existing records


    Hi,

    I wish to enter a name in a table, however can't figure out how to check if it already exist to avoid duplication.

    thanks for help

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    In your table design, set the field to No Duplicates in the Index property.

    Alan

  3. #3
    zul is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Aug 2011
    Posts
    4
    Thanks will try it out.

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

Similar Threads

  1. Adding records to existing table
    By Mclaren in forum Programming
    Replies: 5
    Last Post: 05-18-2011, 12:44 PM
  2. Replies: 6
    Last Post: 04-27-2011, 06:12 AM
  3. Populate existing records from Excel
    By oleBucky in forum Import/Export Data
    Replies: 2
    Last Post: 03-08-2011, 12:23 AM
  4. Cloning data to other existing records.
    By GraemeG in forum Programming
    Replies: 0
    Last Post: 02-16-2011, 11:53 AM
  5. Replies: 1
    Last Post: 05-18-2010, 11:43 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