-
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.
-
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.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules