I have a constraint on a table that keeps file numbers from being entered improperly. (bar code scan)
The error message window in access only has an OK button which will be a problem.
1. User is scanning a box of folders with barcodes on them to be sent to another building/department.
2. Barcode is misread and error popup from Access displaying the SQL error displays, user misses the popup and scans the next folder.
3. This clears the popup because at the end of every barcode scan is a carriage return.
4. User then scans the next folder which overwrites the misread folder and continues.
Because of step 2, two folders are missed in the scanning process.
I need to know how to catch the error from SQL and display my own popup window that cannot be so easily bypassed.
Thanks
John Fuhrman
The error message window in access only has an OK button which will be a problem.
1. User is scanning a box of folders with barcodes on them to be sent to another building/department.
2. Barcode is misread and error popup from Access displaying the SQL error displays, user misses the popup and scans the next folder.
3. This clears the popup because at the end of every barcode scan is a carriage return.
4. User then scans the next folder which overwrites the misread folder and continues.
Because of step 2, two folders are missed in the scanning process.
I need to know how to catch the error from SQL and display my own popup window that cannot be so easily bypassed.
Thanks
John Fuhrman