Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2015
    Posts
    1

    Talking Unanswered: Newb Needs Help with intergrating scanner in to inventory DB

    I have scanner (Unitech MS335-1G) and my end goal is to scan a product number bar code on a box into a field on a form. Then from what is scanned into the box run a query on another table that has all the info on the product. Then populate other fields on the form. Is this possible? I'm very new to access and so far i know i need a table to run the query against for the product number and info i need to display. Any help beyond this would be greatly appreciated. Thank you in advance.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    most scanners are 'keyboard wedges', which effectively sit alongside in parallel with a keyboard or in place of a keyboard. input from the scanner is treated as keypresses. but that depends on the precise make of scanner.

    the only real trick is to make certain that the text box to receive the input has the focus. you can do that through the user pressing,say the tab key. in a keyboard less device you can supply a preprinted barcode with various codes which equate to commands on (eg open form blah, set focus to the product input box)

    depending on the devoice soem bardoce scanners encode carriage returns on scan, some don't... so read the help files for the barcode device you are using.

    Ive seen laminated sheets with command codes that the user scans to bring up the right form. A simialr technique is used in some petrol (gas) stations in the UK, where the till has a pre printed laminated sheet for things like coffee vending machines, supermarkets often have the weeks special offers as an addendum sheet
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •