?
Solved

General Barcode and Access

Posted on 2014-04-10
6
Medium Priority
?
766 Views
Last Modified: 2014-05-03
Hi,
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.

Thanks
0
Comment
Question by:Stephen Byrom
6 Comments
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 600 total points
ID: 39991317
If your scanner supports batch mode operations, you do not need to have a form open while the inventory personnel are performing the scans.  In fact, depending on your scanner, you might not even need to be in range of your computer.

An inventory specialist can walk the shop floor scanning inventory, and the scanner will store the scans.

Once done, you can open a text file, database, or any other place to input the data, and 'send' the data in bulk to your computer.  That send might require scanning a separate special barcode which tells the scanner to send data, placing the scanner in a cradle attached to your computer, or may automatically happen when you bring the scanner within range of the computer.  This again depends on your specific scanner and its settings.

Getting the data into your database can be done in a variety of methods as well.  For example, if you have sent your batch data to a text file or a memo field in your database, you would use VBA to parse the data into individual barcodes and apply them as needed.

There are third party utilities out there to facilitate this as well (companies dedicated to selling scanners likely will have such utilities available).
0
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 400 total points
ID: 39991326
this will depend on the type of scanner you are using.. see if this article helps
0
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 total points
ID: 39991335
Most scanners you'll use with Access just substitute for the keyboard (they're often known as "keyboard wedge" scanners). Basically you place your cursor in control on the form (a textbox, combo, etc) and then scan the barcode. The scanner will just pop that information into the control. From there, it's up to you, since as far as Access is concerned it's no different than a user typing on a keyboard or using a mouse.

If you're going to use the scanner for multiple purposes, then you'll have to have dedicated resources for that - i.e. ScannerA is tied to WorkstationB, and that is used for Shipping. ScannerB is tied to WorkstationX, and that's use for Receiving, and so on. In thatt scenario, WorkstationB would be running your Access app, and would have the form open that you need to fill for Shipping, and WorkstationX would have the form open for Receiving.

This can be tricky, of course, since it's hard to determine the proper sequence of events for your processes. For example, when you're scanning in received items, do you ALWAYS want to scan one item, and then enter a new record? Or do you want to scan one item and have the user enter more data, then scan a new item? Most of the time the scanners would be used in close proximity to the workstation, since Access is an event driven program, and it needs user interaction to determine the next steps. It's possible to make the forms respond to certain interactions, of course, but be sure to consider the ramifications of unattended scanner input.

There are other types of scanners that can do quite a bit more, and most of those come with APIs that can be used to grab data from the scan and do something with it. In most cases, those can be used with Access as well, but you'd be wise to speak with the company first to make sure.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:Stephen Byrom
ID: 39991382
Thank you all for the input.
We have dedicated Wi-Fi throughout the site and my intention was to get wireless scanners so that trained personnel could scan at their respective locations and then 'send' the data back to the database. I have found some "Wedge" type software from TEC-IT, namely the TWedge, which seems to fit the bill, so I guess it's down to the scanner and probably batch-type. I also presume a separate table would be needed to capture the scanned data which would clear when the data has been "pushed" to the respective tables relevant to what was scanned.
0
 
LVL 85
ID: 39991407
I also presume a separate table would be needed to capture the scanned data which would clear when the data has been "pushed" to the respective tables relevant to what was scanned.
That's generally a good idea. It allows you to validate your data before it hits the live table, at the expense of potentially "stale" data, depending on how often you process the staging table.
0
 
LVL 1

Author Closing Comment

by:Stephen Byrom
ID: 39992693
Thanks again to all for the input
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question