473,385 Members | 1,379 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Bar code in Access 2002

D.M
In the main form, near the field X (unique personal number for example
2901977100035) I want to add button who is going to print that number in bar
code format EAN 128 on the printer label A4.
If you know how am I going to do this, please contact me on this newsgroup.
Thanks
Nov 12 '05 #1
4 4310
simply use a barcode _font_. Im sure you can get EAN 128 format in that
font. now simply create a report and fit its width and height to the size
of your label, Goto PageSetup and make sure this report is pointing to your
label printer desired. Put a textbox on your report and change its font
property to your barcode font and whalaa! you have a barcoded label in under
10 minutes!

p.s. as for locating a barcode font you can do a search on google (I bet if
you look hard enough you could find a free one), or if you have any art
software like Corel Draw that will already have such fonts. Im sure other
places as well, maybe someone else in the group will know where to get one.

p.s.s. once you have located your barcode font you must install it into your
fonts collection from the control panel before you can use it. Also you now
have this font dependancy on any machine that will run this application, so
make sure it gets installed first.

HTH
Mike Krous
"D.M" <ma*****@hotmail.com> wrote in message
news:bo**********@ariane.blic.net...
In the main form, near the field X (unique personal number for example
2901977100035) I want to add button who is going to print that number in bar code format EAN 128 on the printer label A4.
If you know how am I going to do this, please contact me on this newsgroup. Thanks

Nov 12 '05 #2
VM
One way to do this is to use an Active X control as part of your
report. Tal technologies, (www.taltech.com) makes an ActiveX control
that you can use. They even have an example application in Access.
Only caveat is that it's pretty expensive. You can search
for other Active X Controls on the web as well.

If you are going to use a specific manufacturer's barcode printer, they often
provide ActiveX controls that work with their brand of printers for free.
Intermec (www.intermec.com) is one such company.

Vas Madhava
"D.M" <ma*****@hotmail.com> wrote in message news:<bo**********@ariane.blic.net>...
In the main form, near the field X (unique personal number for example
2901977100035) I want to add button who is going to print that number in bar
code format EAN 128 on the printer label A4.
If you know how am I going to do this, please contact me on this newsgroup.
Thanks

Nov 12 '05 #3
This is only part of the story, if you are using a barcode font you also
have to know how th ebarcode is encoded and do this for yourself. Barcodes
are rarely a straight translation from text to corresponding characters in
the barcode font, you frequently need to know the start character, the stop
character how to checksum etc.

D.M.
Look on the web there's a ton of resources on barcodes out there.

Terry
"Mike Krous" <m.krous@nospam_comcast.net> wrote in message
news:Ac********************@comcast.com...
simply use a barcode _font_. Im sure you can get EAN 128 format in that
font. now simply create a report and fit its width and height to the size
of your label, Goto PageSetup and make sure this report is pointing to your label printer desired. Put a textbox on your report and change its font
property to your barcode font and whalaa! you have a barcoded label in under 10 minutes!

p.s. as for locating a barcode font you can do a search on google (I bet if you look hard enough you could find a free one), or if you have any art
software like Corel Draw that will already have such fonts. Im sure other
places as well, maybe someone else in the group will know where to get one.
p.s.s. once you have located your barcode font you must install it into your fonts collection from the control panel before you can use it. Also you now have this font dependancy on any machine that will run this application, so make sure it gets installed first.

HTH
Mike Krous
"D.M" <ma*****@hotmail.com> wrote in message
news:bo**********@ariane.blic.net...
In the main form, near the field X (unique personal number for example
2901977100035) I want to add button who is going to print that number in

bar
code format EAN 128 on the printer label A4.
If you know how am I going to do this, please contact me on this

newsgroup.
Thanks


Nov 12 '05 #4
"D.M" <ma*****@hotmail.com> wrote in message news:<bo**********@ariane.blic.net>...
In the main form, near the field X (unique personal number for example
2901977100035) I want to add button who is going to print that number in bar
code format EAN 128 on the printer label A4.
If you know how am I going to do this, please contact me on this newsgroup.
Thanks


Find a quality barcode font. You can get one from here:
http://www.morovia.com/font/
Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

14
by: wolftor | last post by:
1) Is there a free runtime version of Access available that is more recent than the one for Access 2000? 2) If I create an application (MDE) in A2K, will it run on all later versions of Access?...
13
by: Noesis Strategy | last post by:
When I ordered my new laptop, Sony didn't offer Access 2003 in its bundles. Recently, I have begun to design Access databases using an copy of Access 2002 from my previous laptop. It works fine,...
1
by: Wayne Aprato | last post by:
I have a client who is running several Access 97 databases that I have written for them. They are about to upgrade to Access 2003. Is the default file format of Access 2003 still Access 2000 the...
3
by: Scott | last post by:
Hi, If we want to compile an Access 2002 database and distribute it to others, will the compiled software run on any PC, like Windows 98, Windows 2000, etc. Also, you don't have to have...
3
by: Colin Chudyk | last post by:
Hi, Here is my situation. Can anyone provide insight? I have developed a database in Access 2002. I am planning to distribute it as a split MDE (front) / MDB (back) to be used by the Access...
7
by: Wayne Aprato | last post by:
I have several Access 2003 mde databases. When I try to open them in Access 2002 I get the following error: "The Visual Basic for Applications project in the database is corrupt." ...
3
by: Stickleback | last post by:
Morning All I have been developing and deploying with Office 2000 for about 3 years, mainly Access based programs and although I have gotten used to it's quirks, I am starting to feel that I...
9
by: Rob | last post by:
Scenario: O/S: Win XP Professional Back-end: Access 2002 on network server I have an Access 97 application, in production on our network, that takes appoximately 5 minutes to process monthly...
2
by: Bruce Dodds | last post by:
I will be doing an app for a nonprofit. It would be useful for them to have a good entry-level book on Access so that they don't have to pay someone to design all their queries and reports. I'm not...
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.