×
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!
  • Students Click Here

*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

Jobs

Barcode Printing Issues from Access

Barcode Printing Issues from Access

Barcode Printing Issues from Access

(OP)

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.

RE: Barcode Printing Issues from Access

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
r2d2 < I Built one
www.robots2000.com

RE: Barcode Printing Issues from Access

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.

RE: Barcode Printing Issues from Access

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).

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