stressedbrian
New member
- Local time
- Today, 20:44
- Joined
- Apr 20, 2011
- Messages
- 7
Hello there, I am needing some help with barcodes and our access database 2003.
We are a small company and process approx 15000 orders a year to individual companies.
When an order is ready a mailing lable is printed and it is updated as complete on the database. Using a customers name or order number can take a while to search for them, therefore I would like to use barcodes (and would expand them to do more work for us).
My problem is I have been trying to use code 39 barcode fonts and use the customers order number to generate the barcode but at the moment I can't get that to work as there needs to be an *asterisk each end of the customer number for the barcode reader to scan properly, it might seem daft but to enter an asterisk at each side of the number is a bit of a pain, not only for backtracking through current orders but also people forget and it won't scan.
Is there a better type of barcode to use that will avoid this? I have tried a few barcode generating plugins but don't want to commit to one (ie pay for a full version) until I know it works.
When scanning the barcodes I am usuing a lookup form and the scanner shows the number and the the form searches, ideally poping up the customers order in form layout. I have no code writing experience, again whats the most efficient way of updating todays date quickly into the correct field on the customers order.
Any help much appreciated.
We are a small company and process approx 15000 orders a year to individual companies.
When an order is ready a mailing lable is printed and it is updated as complete on the database. Using a customers name or order number can take a while to search for them, therefore I would like to use barcodes (and would expand them to do more work for us).
My problem is I have been trying to use code 39 barcode fonts and use the customers order number to generate the barcode but at the moment I can't get that to work as there needs to be an *asterisk each end of the customer number for the barcode reader to scan properly, it might seem daft but to enter an asterisk at each side of the number is a bit of a pain, not only for backtracking through current orders but also people forget and it won't scan.
Is there a better type of barcode to use that will avoid this? I have tried a few barcode generating plugins but don't want to commit to one (ie pay for a full version) until I know it works.
When scanning the barcodes I am usuing a lookup form and the scanner shows the number and the the form searches, ideally poping up the customers order in form layout. I have no code writing experience, again whats the most efficient way of updating todays date quickly into the correct field on the customers order.
Any help much appreciated.
