PC Review


Reply
Thread Tools Rate Thread

Bar Code Generaton in Access Reports

 
 
=?Utf-8?B?QWxpLCBTaWZ0ZQ==?=
Guest
Posts: n/a
 
      31st Aug 2006
I want to print Bar Code on Access Reports. Is it possible staying within
Access using VBA. Can some body help me. Its burning issue for me.

--
ALI
MS Access Developer
 
Reply With Quote
 
 
 
 
Arvin Meyer [MVP]
Guest
Posts: n/a
 
      31st Aug 2006
Have a look here for lots of solutions in MS-Access:

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

I've successfully used James Mercanti's code to draw barcodes in several
versions of Access, but in general, a barcode font is the easiest way to go.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Ali, Sifte" <(E-Mail Removed)> wrote in message
news:78BA0104-58FB-4410-91B4-(E-Mail Removed)...
>I want to print Bar Code on Access Reports. Is it possible staying within
> Access using VBA. Can some body help me. Its burning issue for me.
>
> --
> ALI
> MS Access Developer



 
Reply With Quote
 
Smartin
Guest
Posts: n/a
 
      31st Aug 2006
Ali wrote:
> I want to print Bar Code on Access Reports. Is it possible staying within
> Access using VBA. Can some body help me. Its burning issue for me.
>


There are free bar code fonts out there. Here's one:
http://www.barcodesinc.com/free-barcode-font/

--
Smartin
 
Reply With Quote
 
Thomas Lutz
Guest
Posts: n/a
 
      11th Sep 2006
Bar code fonts are not as easy to use as th publishers of bar code
fonts would have you think. Bar codes are not just a straight
"character to bar pattern" substitution. In other words you cannot
just select some text, change its font to a bar code font and expect
to get a readable bar code. Bar codes contain start and stop patterns,
check digits and in most cases a complex algorithm must be run on the
data being encoded to end up with a new character string that a bar
code font is then applied to. Bar code fonts also generally produce
very poor quality bar codes that can be difficult to scan.

For printing bar codes from Access, you would be best off using a bar
code ActiveX control that produces a high resolution vector style
graphic image like the one fromTAL Technologies at the
following URL:
http://www.taltech.com/products/activex_barcodes.html
Bar code ActiveX controls integrate very easily into an Access
database report and are therefore extremely easy to use. They also
perform all necesary calculations for you and the better ones produce
a high resolution and completely device independent vector image that
will print perfectly on any printer.

Adding a bar code to an Access report using an ActiveX control is also
as easy as dropping in a textbox control. I would recommend that you
download the demo of the TAL Bar Code ActiveX control from the above
URL and take a look at the sample Access database that is provide with
the demo.



On Thu, 31 Aug 2006 03:54:02 -0700, Ali, Sifte
<(E-Mail Removed)> wrote:

>I want to print Bar Code on Access Reports. Is it possible staying within
>Access using VBA. Can some body help me. Its burning issue for me.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bar Code on Access Reports =?Utf-8?B?RGF2aWQgV2lkZW5lcg==?= Microsoft Access 5 15th Feb 2006 06:08 PM
cannot access reports and form code crashes access =?Utf-8?B?U3RldmllVDY1?= Microsoft Access Reports 2 8th Mar 2005 09:51 PM
Executing Access Reports through VB 6 Code M. R. Microsoft Access Queries 2 31st Dec 2004 12:34 PM
create Access Reports using VB6 code =?Utf-8?B?Y29kZWF0ZXI=?= Microsoft Access VBA Modules 3 1st Jul 2004 12:10 AM
Create Access Reports using VB6 code =?Utf-8?B?Y29kZWF0ZXI=?= Microsoft Access Reports 1 30th Jun 2004 03:54 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:03 AM.