Results 1 to 5 of 5
  1. #1
    Koolaid is offline Novice
    Windows 8 Access 2016
    Join Date
    Mar 2016
    Location
    Northern VA
    Posts
    26

    Question Prevent Duplicates

    I hope this isn't a difficult thing to do but I'm a newb and want to prevent typing duplicates into a column. Does anyone have an easy way to do this? Thanks!



    Koolaid

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,304
    can you key the table? this will solve it.

  3. #3
    Koolaid is offline Novice
    Windows 8 Access 2016
    Join Date
    Mar 2016
    Location
    Northern VA
    Posts
    26
    I appreciate the response so quickly, but what does "key the table" mean? And how would I do it? Thanks!

    Koolaid

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,330

  5. #5
    Koolaid is offline Novice
    Windows 8 Access 2016
    Join Date
    Mar 2016
    Location
    Northern VA
    Posts
    26
    I realized afterwards that it meant the primary key but I ended up realizing I can adjust the indexing area of the non-primary key column to yes (no duplicates) and now it will not allow me to add duplicates in that specific column I was concerned about. Thanks for the help

    Koolaid

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

Similar Threads

  1. Prevent Duplicates Upon Selection from Combo Box
    By xx_phenom_xx in forum Programming
    Replies: 5
    Last Post: 04-28-2015, 09:30 AM
  2. Prevent Group By eliminating duplicates
    By bruegel in forum Queries
    Replies: 3
    Last Post: 03-27-2014, 07:55 AM
  3. Dlookup to prevent duplicates
    By arothacker in forum Access
    Replies: 16
    Last Post: 02-12-2014, 11:40 AM
  4. How to prevent duplicates in said example
    By raymondbeckham in forum Forms
    Replies: 1
    Last Post: 04-11-2012, 03:29 PM
  5. Replies: 3
    Last Post: 02-10-2012, 11:34 AM

Tags for this Thread

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