Solved

General Barcode and Access

Posted on 2014-04-10
6
686 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 150 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 100 total points
ID: 39991326
this will depend on the type of scanner you are using.. see if this article helps
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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 84
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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Documents and settings folder 30 76
VBA Access 2016 syntax 6 41
Macro to import XML in Access 2013 2 34
Help with DoEvents 8 26
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
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.
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.

776 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