How to pass scanned data to database prompt 追蹤
I have a label that has a field that needs to be scanned by a barcode scanner. The barcode contains extra characters that I need to remove then have the value inserted into a query prompt to pull data for the label. The label is connected to an SQL database View that has the invoice number as the field that needs to be queried.
The scanned invoice number looks like this SG-1234567 and the invoice number is 1234567. I need to remove SG- from the scanned barcode and insert 1234567 into the query so It can return values to the label.
How can I do this. VB? If so what is the code that will do this and where do I put it? On the query prompt field?