How to scan bar codes into an Access 2007 database.

Posted on 2008-11-10
Last Modified: 2012-05-05
We are currently creating an audit database in Access 2007, we need to be able to scan in equipment barcodes into our database. We would like to be able to use our handheld scanner to read in  the barcode data, into one of  our Access  tables, please can you help on how to interface our scanner to our database.
Question by:Dbrooks-smith
    LVL 70

    Accepted Solution

    Most scanners work by emulating keyboard input, so its a matter of rigging up the scanner and scanning the barcode at the same point that you would nomally enter the code via the keyboard.
    LVL 20

    Assisted Solution

    Bar code scanners act just like your keyboard.
    You can focus on anything; Access field, notepad, word doc,..... anywhere.
    When you scan the barcode - the value will appear where the cursor is focused.

    That's all there is to it.

    Scott c
    LVL 6

    Expert Comment

    A little bit OT, but
    the problem will be, how to determine if the user is just typing in some data with the keyboard
    or if he is trying to scan in some barcode !!

    Author Closing Comment

    Thank you very much for your help.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    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.
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now