Point of Sale Cash Drawers with Bar Code 1

[romh]

How would I add a cash drawer for point of sale into my Access application. I have a database written in Access 2000 with Windows 2000 Adv Server and Windows 2000 prof clients. I have a very heavily VBA coded Ordering form that processes all items ordered. My next task is to add a cash drawer with a bar code scanner. How do you tie in the bar code scanner with VBA code events etc...

Thanksyou

 

[pvted]

Romh,

The easiest way to handle the input of data from barcode scanners is to utilize scanners that plug into into the keyboard port of the PC. In addition, the scanners should be of the type that handles the "decoding" of the barcode data into ASCII characters (the alternative is a "dumb" scanner that requires the use of a "wedge" program on the PC to perform this decoding - not recommended).

To your Access program, the output from the barcode scanner looks exactly like the information has been entered from the keyboard. In a Point of Sale application, the user scans a barcoded price tag, and the program accepts the string of characters from the scanner, looks up the item in it's scan file, and registers the sale. You don't, necessarily, need to do anything special in your program to deal with this. Just write it to properly handle keyboard input of the item numbers (or SKUs) and then have your users use the barcode scanners instead of the keyboard to enter this information.

With regard to interfacing your program to a cash drawer: Most Point of Sale printers include a connection (typically an RJ-11 "telephone" type plug) that connects it to the cash drawer. The printer will accept a command string (found in the printer's documentation) that will in turn cause the cash drawer to open. This command string should be sent to the printer when a cash sale (or a No Sale) is rung up.

Hope this is helpful,
Ted

 

[romh]

Thankyou very much Ted. Vey Useful information. I will examine closely everything you wrote to me.
Thanks again.