Working on building a table in Access that will contain only two fields: 1) Asset Tag Number and 2) Serial Number. The "Asset Tag Number" is always a six- (6) digit number; whereas, the "Serial Number" is always alphanumeric. Both fields will be inputted via a barcode scanner.
Two questions:
1) 1. How do I set up a data validation so the Asset Tag Number cannot be accidently scanned into the Serial Number field? (Already set validation for the Asset Tag Number)
2) 2. In the case that an error message appears, can Access be setup to clear the field after the "OK" button is clicked upon reading the message?
If you need more information to help you answer my question – please do not hesitate to ask me.
Just a note: I am a green Access user.
Thanks!
Posted by: spearse@sfsu.edu
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar