Results 1 to 3 of 3
  1. #1
    dale_j1992 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2016
    Posts
    8

    Unhappy Rfid form help


    Good evening i have an issue i just cant seem to resolve, i have a table where the primary key is a 10 digit number RFID number, and the second column is USERNAME linking the Unique RFID number with a username. i want to create a form where on open it is blank and the focus is set to the RFID number field, the user scans there card which inputs the number into the field automatically, i want the username to display automatically depending on the card scanned as per the Table, and maybe if possible a message box if the Card scanned is not on the system. i have the RFID scanner talking and working with ACCESS the only issue is this form. any help great or small is greatly appreciated. i am new too access.

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Maybe use the before update event of the RFID number control to
    1) check that the RFID is in the table and
    2) push the associated name into the USERNAME control.

    You could use a query or the DLookup() function.

  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

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

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