General Barcode and Access
Posted on 2014-04-10
I have done some research on the web regarding Barcoding and MS Access.
One thing I can't seem to get my head around, or find an answer for is this;
How does the data from the scanner get into the database?
If using a wireless scanner in a warehouse and I want to send data to the database, do I need to have a form open on the workstation that would accept the data scanned?
Similarly, if people are scanning products on the shop floor, would that not need a different form open?
I currently handle all stock movements and stock levels by action queries and vba behind input forms. But my boss is willing to pay for scanners if I can just get my head around the sequence of events needed.
As always any advice, or pointers to relevant articles is welcome.