Solved

Display/print bar code in Access report

Posted on 2002-06-05
6
277 Views
Last Modified: 2008-03-06
How do I display/print a bar code in an Access report?  I went to support.microsoft.com and looked at an article that I thought would help (Q271488) but it didn't complete solve the problem.  It said I should use the barcode font, but I don't know what a barcode font is or where to get one.  Please help me with the steps to display barcodes in forms/reports; what barcode fonts are; where to obtain barcode fonts.

Thanks!

gkadell
0
Comment
Question by:gkadell
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 14

Expert Comment

by:mgrattan
ID: 7057951
I've found that the easiest way to implement bar codes is to use a barcode ActiveX control.  I purchased a very good one from IDAutomation (http://www.idautomation.com) for $199.  There are others as well; just do search in Google and you'll find several.  These controls usually include a barcode font or they will create the barcode as an image that is displayed in a report.

Mike
0
 
LVL 52

Expert Comment

by:Ryan Chong
ID: 7058709
or here is an alternative. Buy a barcode printer, which you can connect it to your machine's port. Then use MSComm Control to send the output to the Barcode Printer to printer the barcode label.
0
 

Author Comment

by:gkadell
ID: 7064739
mgrattan,

Does the IDAutomation font work on Novell 3.12?  Can I have prefixes that are only in the bar code and not in the human readable text (for example, the bar code would read "SI00021987" and the human-readable text would read "0021987".

Thanks,

gkadell
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
LVL 14

Accepted Solution

by:
mgrattan earned 100 total points
ID: 7065823
It's an ActiveX component that installs on your computer; I'm using it in Access 2000 running on a Windows 2000 server but other users are using it in an Access database that is run from a Novell 5 network.  I don't think there would be a problem running it on a Novell 3 network.

You should check the FAQ or tech support area on idautomation.com to answer the other part of your question; I don't have the answer off the top of my head and won't be able to check until I have time at work during the week.

Mike.
0
 

Author Comment

by:gkadell
ID: 7066747
Thank you, Mike - I thought barcoding would turn out to be difficult, but it seems pretty easy.  I contacted ID Automation and they are very helpful.

Gladys
0
 
LVL 14

Expert Comment

by:mgrattan
ID: 7067244
Great!  Glad to be of assistance.

Mike.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

740 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