Out of interest is there a way to create barcodes on reports. I would
like to create a barcode for all orders numbers

If any one knows are free or pay for software that works with access
that will create barcodes that will be fantastic


Thanks

Simon wrote:
> Out of interest is there a way to create barcodes on reports. I would
> like to create a barcode for all orders numbers
>
> If any one knows are free or pay for software that works with access
> that will create barcodes that will be fantastic
>
>
> Thanks

Just obtain a barcode font. I use Free3Of9 which I found on the web and is
free. It uses code 39 bar code format and all you have to do is place an
asterisk before and after the data and then use that font.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

"Simon" <(E-Mail Removed)> wrote:

>Out of interest is there a way to create barcodes on reports. I would
>like to create a barcode for all orders numbers

Choose the proper barcode and locate an appropriate font. Place the
font file on all the systems which will be printing bar codes. On the
report(s) change the font on a field to use the bar code font. Some
bar codes like having *s before and after while others like check
digits.

For more info and links see the Using bar codes within an application
page at my website at http://www.granite.ab.ca/access/barcode.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Actually, in 3of9 the *'s are optional, Rick. Recommended (STRONGLY),
but optional.

Personally, I tend to suggest Code128 these days, rather then 3of9.
The resulting bar code, I've found, is a bit more robust (withstands
problems from reading the bar code, less likely to cause problems), as
well as resulting in a smaller bar code. The code to "compact"
Code128 is now also freely available (along with the font) from
several places on the web. (I've used the code from
<http://grandzebu.net/informatique/codbar-en/code128.htm> with a great
deal of success.)

Tony, you may want to add <http://grandzebu.net/> to your list of
resources.....



On Fri, 29 Dec 2006 12:29:18 GMT, "Rick Brandt"
<(E-Mail Removed)> wrote:

>Simon wrote:
>> Out of interest is there a way to create barcodes on reports. I would
>> like to create a barcode for all orders numbers
>>
>> If any one knows are free or pay for software that works with access
>> that will create barcodes that will be fantastic
>>
>>
>> Thanks
>
>Just obtain a barcode font. I use Free3Of9 which I found on the web and is
>free. It uses code 39 bar code format and all you have to do is place an
>asterisk before and after the data and then use that font.


--
Drive C: Error. (A)bort (R)etry (S)mack The Darned Thing

Chuck Grimsby <(E-Mail Removed)> wrote:

>Tony, you may want to add <http://grandzebu.net/> to your list of
>resources.....

Yeeyuck. What lousy backgrounds to his website. There's a reason
why paper is black on white. Anyhow page updated.

Thanks, Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

You may be able to use a bar code font successfully however bar code
fonts are generally much more difficult to use than you would think
and they also produce very poor quality bar codes that can be
difficult or impossible to read depending on the printer that you use.
You cannot simply install a bar code font and then select the text
that you want encoded in a bar code and change its font to the bar
code font and expect to get a readable bar code.
Bar codes contain start and stop codes, check digits that must be
calculated and they often require that you run the bar code message
through a special encoder algorithm before using it with a bar code
font.

The easiest and best way to print bar codes from within an Access
database report is to use a good quality bar code ActiveX control that
produces a high resolution vector image of the bar codes. The best one
on the market is from TAL Technologies. For more information or to
download a demo version of the TAL Bar Code ActiveX control, visit:
http://www.taltech.com/products/activex_barcodes.html

The demo version of the TAL Bar Code ActiveX control comes with a
sample Access database that demonstrates how to use it in Access.
Basically, you select the TAL Bar Code ActiveX control from your
report designer toolbox and drop it onto your report. You then set its
properties to generate the type of bar code that you want and also set
the Data Source property to point to the data field that contains the
input data for the bar code. The ActiveX control does the rest. When
you print your report, your bar codes print perfectly no matter what
printer you use. It is also a developer tool so you can install it on
as many workstations as you like without having to purchase additional
licenses for each workstation as you would have to do with a font.


On 29 Dec 2006 02:45:07 -0800, "Simon" <(E-Mail Removed)> wrote:

>Out of interest is there a way to create barcodes on reports. I would
>like to create a barcode for all orders numbers
>
>If any one knows are free or pay for software that works with access
>that will create barcodes that will be fantastic
>
>
>Thanks