×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Scanner reading into MS Acess

Scanner reading into MS Acess

Scanner reading into MS Acess

(OP)
Hi!

I have a Symbol LS 1004 Scanner and I want it to read barcodes and insert them into a MS Acess Search box, so I can have looked up what says on the barcode in the database. For some reason, the scanner reads and decode the barcodes, but nothing shows up on the computer. Do I need any type of script, string, or something.....

Please help!

Thanks anticipated.

RE: Scanner reading into MS Acess

How is the scanner connected to the computer, is it keyboard wedge or serial?

what type of barcodes you are trying to scan? ean13 code39 etc

if serial you need another program to do a conversion.

If KB wedge, does it work in notepad etc.  download the manual if you don't already have a copy and default the scanner and try scanning the test barcodes at the back.  if they work but your own don't you need to set the scanner up for other kinds of barcodes.

Jon



RE: Scanner reading into MS Acess

(OP)
Thanks Jon

My scanner has the wedge type connector into the AT keyboard. It reads'I'm trying to make it read Code 39, Code 93 or Code 128, but none of them seems to work in notepad. I do have the standard set up barcode in the quick guide that came with it, but still, doen't work. Something else, a salesman, came with a brand new Symbol LS 1900 scanner, plugged it into the wedge connector (his own)and it didn't work either, not even in Notepad. Will it be the computer??

RE: Scanner reading into MS Acess

if the keyboard still works it won't be the computer, as far as the computer is concerned anything scanned by the scanner is actually being typed in by the keyboard, it does not know the scanner is present.

It should tell you in the guide what the default settings are, check the default for what kind of keyboard it is expecting ie AT and not XT, Wyse, DEC etc.

Does the scanner beep okay after scanning?

I'll download the manual off the web later today and see what else I can recommend for you to try.

Jonathan

RE: Scanner reading into MS Acess

Also you may have hosed up the scanner trying to program it.
There should be a barcode in the manual to set it back to factory defaults or reset it back.
Symbol scanners are notorious for being difficult to program and require scanning several barcodes for it to work correctly.
you can contact Symbol at +1.800.653.5350

HHP scanners are ready to go right out of the box. Or scan just one barcode to add a carriage return.
www.hhp.com

DougP, MCP

RE: Scanner reading into MS Acess

(OP)
Hello and BIG THANKS for your support.

This is what happened... I have the scanner quick guide, scanned the default settings barcode and the scanner made 4 beeps in a "dee-do-dee-do" style. It is not like the normal "beep". Then after, and within notepad, I scanned absolutely everything I could find that had a barcode on it.
Guess what happened? Nothing! Every barcode scanned turns on the green light that says decode.

Í'm also aware that the PC doesn't know about the presence of the scanner (I found that a week ago). But still, the same keyboard I'm using to write this it's the one connected to the wedge where the scanner is (AT style). So the weirdest thing is: Why wouldn't any scanner work on this PC (pointing to the LS 1900 that the salesman brought)? Anyways... I'm thinking in cheking in another PC to see if the PC itself has something to do about it. Thanks again, will keep you informed.... and, please If you know something better, let me know!

Million Thanks!

Reg

RE: Scanner reading into MS Acess

You have to finish programming the scanner.
All you did was clear out the bad stuff. You Are now back to square 1.
You have to tell it the following: by scanning other barcodes in the manual.
What type of connect PS/2 or serial
What type of keyboard XT or AT
Add a carriage return to  the barcode.
When symbols come out of the box they know nothing. You have to program everything for it to work correctly.
The reason it beeps is because it is letting you know it read something.  But the first 3 or 4 something’s need to be programming codes or nothing is going to show up.

DougP, MCP

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close