Hello, I have a project in which I have created multiple QR codes to be scanned into a spreadsheet to identify when specific tasks are completed. This will occur Monday Through Friday 24 hrs. per day. There is a total of 210 codes and each are unique to a particular line and machine. If a code is scanned in more than once, it will generate an error message to let them know that duplicates are not acceptable. This is where my problem presides. If an error message is acknowledged and the operator clicks OK, it will automatically clear the field and they can re-scan to QR code and it will be fine, however, if they are not paying attention and scan another code without acknowledging the error message, it will clear the error and only enter the latter portion of what the QR code is programmed to do, which will not be identified properly and will not show as being completed.
Example: TIR01-1-PCI is an acceptable entry, when an error has not been cleared, it may only show a partial scan of PCI, which is the last part, but incorrect.
I have tried to utilize Data Validation, but when using a scanner, it will over-write the validation rules. I have looked in multiple areas of the web to see if data validation could be completed by using VBA code after the scan was entered and generate an error if it does not match something in a predefined list, but unable to find anything to accommodate. I have tried to place to code to clear the field before the error message is generated, but still get partial scans at times.
This does not have to be a data validation if I can have certainty that partial scans will not occur. I am open to alternate suggestions as well and I do appreciate any input provided.
Bookmarks