If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Scanning
can anyone inform how a super market scanning machine will work with an excel
application or even access database. i dont if these are the programs they use when items are scanned befor customers pay. i will like to know how that is done thanks |
#2
|
|||
|
|||
Scanning
Yes, it's called bar code scanning and Access (and Excel) can receive output
from a bar code scanning device. Here's a good source of information: http://www.adams1.com/share.html -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Amin" wrote in message ... can anyone inform how a super market scanning machine will work with an excel application or even access database. i dont if these are the programs they use when items are scanned befor customers pay. i will like to know how that is done thanks |
#3
|
|||
|
|||
Scanning
"Amin" wrote in message
... can anyone inform how a super market scanning machine will work with an excel application or even access database. i dont if these are the programs they use when items are scanned befor customers pay. i will like to know how that is done thanks They definitely aren't using Excel! They are using some sort of database application, though I doubt they are using Access. The scanner is merely an input device, just like a keyboard. In fact, handheld scanners exist for PCs that can be plugged into the keyboard interface, though most newer ones are USB. The scanner scans the UPC barcode in and it is used in a lookup in the database which returns the price of the item. We use scanners and barcodes extensively with our Access (front-end) application. It's very efficient and less error prone. The scanner simply fills in a textbox on a form - the user could also type in the same info but the scanner is faster and more accurate. |
Thread Tools | |
Display Modes | |
|
|