Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

Can I print barcode labels on Zebra LTP 2844 printer via ms access.

Hi:
I need to print barcode labels using  Zebra LTP 2844 printer via ms access application.
I have a form contains a field (numeric field) myNumber, and a button for printing the barcode.
How could I send myNumber to the printer.
Please help.

2844.png
0
Mohammad Alsolaiman
Asked:
Mohammad Alsolaiman
3 Solutions
 
tncodeCommented:
I have used this product with success to print bar codes from Access Reports to thermal printers.
0
 
Jeffrey CoachmanMIS LiasonCommented:
You need a Barcode font.
One popular free barcode font is: "39"
https://www.google.com/?gws_rd=ssl#q=free+barcode+font+39
Download and install this font.
Then create a query to print the labels.
Note that you may have to create a separate "BarCode" field that pads the PartNumber with Asterisks ("*")
Something like this:
SELECT PartNo, PartName, PartPrice, "*" & [PartNo] & "*" AS BarCode
FROM YourTable
Then create your Labels (Report), from this query, and change the font of the PartNumber control to the new font

There may be some trial and error involved here, ...as the font will have to be a certain size in order for the scanner to actually read it.
(In my case I had to set the font size to 20.)

Hope this helps

JeffCoachman
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
To add what the others have said, there are three approaches:

1. Using ZPL, you can send commands/data to the printer directly out of VBA - Lot's of work - do not recommend.

2. You can use a bar code font for a report.  This is some work on your part and as long as you stick to 3 of 9, not all that hard and workable.

3. You can use a bar code generation lib, such as those ID Automation offers (and others).

 While this costs $$$, it's the most complete solution and if your going to work with something other than 3 of 9, like using 2 of 5 and doing a SSCC18 bar code, then I would highly recommend you go this route.

Jim.
0
 
Mohammad Alsolaimanapplication programmerAuthor Commented:
thank to all very much, sorry for late in rating question. it took me a lot of time trying other solutions.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now