asked on

Placing Barcode into Access for Kanban

My boss wants to impliment a Barcoding solution for our Kanban cards. The information that I have is that he will scan a product, and that barcode needs to be placed into an area of the kanban card. He is looking at a mobil scanner, and printer solution, and the task I have is to get the barcode info into the database that produces the kanban card. Any help is appreciated. By the way I am not a coder, or a DBA, just a simple tech wanting a simple solution. :) cheers!

SidFishes

most barcode scanner output simply interprets the code and passes out alphanumerics...so all you need to do is store a text string.

a barcode like | ||| |||| || | ||||

would scan as 8392012

depending on the scanner you may or may not need to add or remove some delimiter chars

*8392012* is common

to print our barcodes, you need to set your report text field to use a barcode font which either comes with your barcode printer or you can purchase

way easier than you'd think...

ASKER CERTIFIED SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SidFishes

not that i'd question ya LSM...but here's a question ;)

if the printers use a win printer driver...why would it be interested in what app is driving the driver? (of course i think some barcode printers may still be stuck in DOSland or using proprietary drivers...so maybe that's what you mean...)

GaDZooKs2004

ASKER

Thanks guys, I will give it a go, and see what's what this afternoon.

ZooKs

Scott McDaniel (EE MVE )

You hit the nail on the head Sid ... the printer the company was using DID have propiretary drivers that, for whatever reason, had real issues with Access reports (not sure why, but we never really did get reliable, readable barcodes until we shelled out and used their command line utility to print). I'd imagine that any Windows-compliant printer would have no trouble these days. This was probably 3 years ago, and the printers were not a brand I recognized ...