Results 1 to 7 of 7
  1. #1
    billgyrotech1 is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    May 2019
    Posts
    179

    Don't Allow Duplicates in AFR Number Field


    Hello,

    I have a field to enter new or previous AFR Numbers in a field on my form AFRs (work order). Is there a way to prevent duplicate entries? Does this have to be at the form or table level?

    Thank you

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You can prevent duplicates by indexing the field(s) and specifying no duplicates. That is done at table level
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

  4. #4
    billgyrotech1 is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    May 2019
    Posts
    179
    Thank you I indexed and selected no duplicates at table level.

    I have an issue now not being able to search previous AFR Numbers on my form. I was using Ctrl+F but it isn't finding previous numbers.

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I don't use Ctrl F so can not comment directly on that. I do not see how indexing a field would impact Ctrl F functionality.
    I found this via google - it may shed some light on things.

  6. #6
    billgyrotech1 is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    May 2019
    Posts
    179
    I attached the file please can you take a look?

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I tested using 32-bit Access 2010. Ctrl+F dialog appears for me whether I click in the AFR textbox or anywhere else in the form
    However its not a user friendly method of searching for existing values
    Suggest using a combo with the AFR values as its row source and a Search button alongside to move to/filter for the required record
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Replies: 8
    Last Post: 08-14-2018, 07:22 AM
  2. Replies: 0
    Last Post: 06-17-2016, 08:56 AM
  3. Replies: 2
    Last Post: 08-19-2013, 09:40 AM
  4. Replies: 6
    Last Post: 01-24-2013, 10:02 PM
  5. Replies: 1
    Last Post: 11-20-2011, 12:11 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