Dear All,

Can anybody to help me, How Can I Print Barcode if I'm Using the report from
MS Access 2000?

Thanks for your help.

Regards,

Johnny

Hi Johnny,
Using barcodes is easy and fun.  First you'll need a bar-code font and VBA/Access functions to use them.  
 
Fonts are usually licensed and so you need a license for each pc or network the will be PRINTING the codes.  Demo products are
available to test theories and practicality from several vendors.
 
Figure out what data you need to encode, then on your report place that field.  Change teh field's font to the barcode font.  Most
of the barcode fonts require using a function call to do the encoding - like this call to use the IDAutomation Code128 barcode font,
set the Data Source for the Control on the report field to;
 
=Code128([txtFraudID] & [PersonNo] & [EmployerNo],0)
 
then print or preview the report.  
 
As a backup, I print the content in another text box below the barcode just in case one of my scanners fails to read the code.  Care
in font and size selection will minimize the possibility of scanner failure.  However, without some narrative value somewhere it may
be very difficult to recover the intent of the field.  
Hope this helps
 
I use this for document tracking and it has made a major improvement in accuracy and document throughput.  The product I usually use
is from IDAutomation, start at this website http://www.BizFonts.com/vba/  .  
A general search on Google will give you a bunch of hits for 'Bar Code' including some useful background infomation.  The scanner
that you decide to use should determine what size fonts to use.  Client business and product considerations  will determine your
scanner and encoding needs since there are practical limits to the data density of each barcode font.  
There are several (dozens) of different encoding schemes, and several types of scanners.  Basically the CCD scanners have a limited
range of a few inches, the top-line lasers can scan us to 30 feet away!  Wand scanners have a very limited range (< 5mm) but can
scan long data streams if used carefully.  Laser and CCD Scanners have an aperture limited data limit (width of wedge).  
 

	-----Original Message----- 
	From: Johnny [mailto:djj99@c...] 
	Sent: Sun 8/25/2002 8:43 PM 
	To: Access 
	Cc: 
	Subject: [access] How to Print Barcode
	
	

	Dear All, 

	Can anybody to help me, How Can I Print Barcode if I'm Using the report from 
	MS Access 2000? 

	Thanks for your help. 

	Regards, 

	Johnny 



	--- 

Johnny,

Here's a site full of information which can be used for leveraging barcode
technology within Access:

http://www.adams1.com/pub/russadam/plugins.html

I like the one by James Mercanti (which is also royalty free), that can also
be upsized into 2000 or XP.

HTH,

Beth Moffitt
Developer
INI, Inc.
xxx.xxx.xxxx  x110
www.iniinc.com



	-----Original Message----- 
	From: Johnny [mailto:djj99@c...] 
	Sent: Sun 8/25/2002 8:43 PM 
	To: Access 
	Cc: 
	Subject: [access] How to Print Barcode
	
	

	Dear All, 

	Can anybody to help me, How Can I Print Barcode if I'm Using the
report from 
	MS Access 2000? 

	Thanks for your help. 

	Regards, 

	Johnny 



	---