?
Solved

General Barcode and Access

Posted on 2014-04-10
6
Medium Priority
?
741 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

766 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