Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    bar code scanner (Access 2000)

    I would to find out if anyone has the experience using bar code scanner to work with Access. For example, instead of typing in a library book's long ISBN, if I can scan the code using a scanner into an Access field.

    Thanks

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: bar code scanner (Access 2000)

    If the scanner can be attached as part of a keyboard wedge, it certainly can.
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: bar code scanner (Access 2000)

    Yes, I've done it and it can be rather simple. You want to get a "wedge" type scanner, which is inserted between the keyboard and the PC. The scanner will read the barcode and pass the results back to Access as if you were hitting the keys on your keyboard. The scanner can usually be programmed to include an [ENTER] after the string. Access doesn't really know (or particularly care) that you are using a scanner to input the data.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: bar code scanner (Access 2000)

    Thanks for the info. Do you have any recommended brand? How much would that be? Do I need to use a separate piece of software?

    thanks again

  5. #5
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: bar code scanner (Access 2000)

    I set up a system with a metrologic ms9500 with no problem. The only thing you need is a way to print the barcodes. There is an ocx called MAbry that is very good for automatically bar codes.

  6. #6
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: bar code scanner (Access 2000)

    I don't have alot of experience with many brands. I have a client who has had good experience with Wasp readers, but he also has some other ones that have worked fine. You shouldn't need any other software to read barcodes. YOu may need other software if you want to print them. You can find some free barcode fonts on the internet. I've had good success with a 3 of 9 font, but have never gotten a 2 of 5 font to work. There are 3rd party ActiveX controls you can purchase which give you better control over the fonts (and take away the headache of correctly formatting them).
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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