Fog Creek Software
Discussion Board




Integrating barcode scanning with ms Access

I'm looking to integrate barcode-scanning software with my ms access 2000 and asp. Can anyone give me any recommentions to any specific software, tutorials available on the net with regards to bar-code scanning. Any advice would be appreciated. Thanks.

Malcolm
Tuesday, July 08, 2003

http://www.google.com/search?q=ms+access+barcode

DJ
Tuesday, July 08, 2003

A lot of barcode scanners just go between the keyboard and the CPU and input keyscan codes, so you get the cursor to where the scanned data goes, zip the scan, and it "types" the numbers in for you. This is by far the simplest approach to doing this.

If you're scanning items that aren't normally near a PC, there used to be a barcode scanner built into a Palm Pilot - you could write a palm app to receive the data then just sync it into the Access app.

Have fun!

Philo

Philo
Tuesday, July 08, 2003

This is off-topic, but does anyone else get annoyed by posts such as DJs? I looked at the google results in his link: 38,000 matches. Yay. Which one of those 38,000 links do you recommend, DJ?

It's like telling someone to go to the library to find a good book, but don't bother giving a short list of a few of your favorite books.

People ask for recommendations to find out about resources that other people found useful.

NathanJ
Tuesday, July 08, 2003

Ever get annoyed when people ask about something before doing a bare minium research? 

Sorry must be the weather. I didn't mean that post to be condescending.

And sorry Malcom if I implied that you did not do any research.

Actually there were quite a few good links on the first page.

DJ
Tuesday, July 08, 2003

Every PC bar code scanner I worked with (used to work with barcode systems) just worked as if the barcode data was typed on the keyboard.  This was in the late 80s, so unless things have gone backwards, I don't think you need to do anything special.

In those days for handheld scanning, we used to use special PDTs (portable data terminals).  You had to burn the programs onto EPROMs (but the compiler and simulator was on the PC). You could choose to program them in a dialect of BASIC or Z80.  These again worked liked the keyboard on the device.  Uploading to PC was connecting to the PC's serial interface - which at that time meant we had to write serial comms code on the PC.  I hope (and expect) this part has advanced since then!

S. Tanna
Tuesday, July 08, 2003

Wasp barcoding software has been around for quite a while, and has an ActiveX/DLL Developer's Toolkit....

http://www.waspbarcode.com/barcode_software/activex.asp

Jeff MacDonald
Tuesday, July 08, 2003

Check out
http://www.intellitrack.net
http://www.rioscan.com

Yaniv
Tuesday, July 08, 2003

DJ,
The reason why I posted on the forum is because google thrusted too many results, many that are too general. And I have been doing more then a minimum research.
So I'm asking anyone here who has experience with  barcode scanning and can provide good links.

Malcolm
Tuesday, July 08, 2003

Malcolm --  As others have said just scanning data into Access is surprisingly simple.  I recently included bar-code scanner functionality in an Access app, and I was a little intimidated before I started out just because the barcodes and scanners seemed kind of mysterious.  It turned out that scanning in is ridiculously easy; getting your app to print barcodes is actually the more difficult part.

All I had to use for my app was a simple $199 Intermec handheld scanner that I got from http://www.idautomation.com .  Their site has a lot of tutorial stuff that's mostly about printing barcodes, but here's a page with some info on how to read barcodes with a keywedge scanner:  http://www.idautomation.com/scanenable/

Herbert Sitz
Tuesday, July 08, 2003

Herbert,
Thats a relief to hear. It makes  my venturing into this field a little less worrisome. Ok, this is the thing, there is a central server with ms access, and 19 locations that use a browser to retrieve and send info to the Access db on the central server. All these 19 locations would have to scan a a specific item, that will automaticallly update the access db on the central server. I just hope that its no hurdle doing this via asp, instead of directly to the access db.
I'll now take a look at the links you've posted. Thanks for that.

Malcolm
Wednesday, July 09, 2003

I agree that keyboard wedge barcode scanners are typically the easiest (and cheapest) way to go when writing a PC based app to collect barcode data.  Every keyboard wedge scanner I've ever seen has a myriad of options for programming whatever prefix, suffix, or delays you want in the output, as well as which barcode symbologies to accept/ignore.

The only possible problem I see with what you are trying to do using the web forms has to do with controlling where the cursor is at all times.  On an Access form, it is easy to make only 1 field active and monitor its contents, so when the user scans something, you always know what is going to happen.  Web browsers, on the other hand, don't always keep the "focus" where you want it.  This could make for some usability challenges.

If you ever need to print barcodes (or display them graphically on screen) you might want to check out http://www.taltech.com .  They make a very nice ActiveX control that I have used with Access many times for things such as printing shelf tags for retail stores...

Good luck!

Tim Lara
Thursday, July 10, 2003

*  Recent Topics

*  Fog Creek Home