Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

issue with error popup window from SQL server

Status
Not open for further replies.

sparkbyte

Technical User
Sep 20, 2002
879
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top