Solved

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

Posted on 2015-01-29
4
144 Views
Last Modified: 2015-03-26
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
Comment
Question by:Mohammad Alsolaiman
4 Comments
 
LVL 6

Assisted Solution

by:tncode
tncode earned 50 total points
ID: 40577430
I have used this product with success to print bar codes from Access Reports to thermal printers.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 250 total points
ID: 40577461
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
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 200 total points
ID: 40577566
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
 

Author Closing Comment

by:Mohammad Alsolaiman
ID: 40691175
thank to all very much, sorry for late in rating question. it took me a lot of time trying other solutions.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now