Barcode Printing Issues from Access

[dBjason]

After an exhausted search, I'm beginning to beleive my problem cannot be solved!

We're running Access 2003 on WinXP sp 3. We print reports that go to our machine shop which has work orders and directions printed on the reports. And, hopefully, 3 bar codes with Order No, Job No, and Part No. The report and back-end dB is pretty self-explanitory. The way it should work is 1) the secretary prints the report and hands it to the machinest. He then takes the report to the shop, scans the report's barcode(s) onto the local box (which updates or dB as 'recieved'), and works on it. Afterwards, he scans it again (as 'finished') with a datetime and our head honchos know from the daily work report what is where and how much got done. Everything works great. Except the barcodes.

Problem is, I can't find a suitable barcode font for Access reports. I've tried hundreds, nothing will scan. The only luck I have is through a link I found here (

http://www.barcoding.com/upc/)

and manually entering a part number to get the barcode jpg, copy to Word, resize, print and finally scan back in. That works great, but there's no way to efficiently put this into a report. And there's no way I can go to that website every time a new part comes in.

So I've checked into different software, but each one seems to be a mass-label making utility that we can't use. I just need a program (api, dll, whatever) that can take alphanumeric information and put it into a 93 or 128 barcode (or any other format that does upper/lower case and return jpg file which our scanners can read.

Printer is an HP 4250/4350 series. The jpg it kicks out from

http://www.barcoding.com/upc/

work great, but I haven't found a font that'll work (to include all posted on this site).

Any help would be greatly appreciated.

 

[DougP]

First, I wrote a lot of barcode program using Access
you don't want a UPC becasue it always has to be eiterh 6 12 or 13 numbers only. and the last digit ia acheck digit. whihc you wil lhave to get rid os sinceit is a calcualtion and not a valid number for your data entry.
you should be able to use a code 39
Code 39 requires an asterisk as the first and last character *12345*
in your Access text box you will need
="*" & yourfield & "*"





DougP
< I Built one

http://www.robots2000.com

 

[TechnicalSwordsman]

dBJason,

You could also use the Native Access Generator by IDAutomation. It allows you to create barcodes directly in the report without the use of barcode fonts. I am an Access developer and this product worked perfect for me.

Here is the product:

http://www.idautomation.com/access/native/

I believe they have a demo that you can take a look at.

 

[Paul7905]

I don't have any trouble at all printing bar codes on Access reports using a bar code font. To see if this will work for you you could try the free code39 font from idautomation.com and see if it works for you. Just install the font on your computer then, with the report in design mode, set the font on the field to the code39 font and your off and running. I guess you need three bar codes depending on whether the order included multiple jobs/parts and you needed to be able to track where in the process a particular job was at (otherwise just one barcode could do the job).