Bar Code

  • Thread starter Thread starter erich
  • Start date Start date
E

erich

We create invoices with MS Access and would like to add
bar codes to expedite the mail. MS Word has this option
as 'Delivery Point Barcode' in its envelopes and labels
utility. Is this possible with MS Access?
 
-----Original Message-----
We create invoices with MS Access and would like to add
bar codes to expedite the mail. MS Word has this option
as 'Delivery Point Barcode' in its envelopes and labels
utility. Is this possible with MS Access?
.
Click to expand...

I was trying to bar code somethings, and the first you
need is a new font - a bar code font - that somone told me
about - you can look up bar code font in google. Then
change the text box to that font. There is also a KB
article - 271622.

Hope that helps. Sean
 
Actually for adding post net bar codes, the question is why not simply use
Word with a mail merge based on an envelope to output the mailing
information with a bar code. Its fast and easy and you don't have to
recreate the wheel.
 
If you are looking for a POSTNET fonts, take a look at
www.morovia.com/font/usp.asp. The whole package does not only include
POSTNET/PLANET barcodes but also OCR-B and Code128 fonts to print OCR
addresses and shipping barcodes.
 
Unfortunately Access does not provide an equivalent bar code tool for
reports. The easiest solution would be to use a bar code ActiveX
control. You could probably use a bar code font however postal bar
codes have a start pattern, a stop pattern and a check digit that has
to be calculated. If you use a bar code ActiveX control, these will
all be taken care of for you automatically. You can also "bind" an
ActiveX control to a data source so all you need to do is drop the
control onto your report, set a couple properties and start printing.
The best bar code ActiveX control on the market is available at the
following URL:
http://www.taltech.com/products/activex_barcodes.html
You can download a demo version of the product from the above URL and
the demo even comes with a sample Access database that demonstrates
how to use it in Access.
 
Erich,

Just to give you another option, take a look at BarCodeWiz ActiveX Component.
ActiveX components are definitely easier to use than barcode fonts.


For printing barcodes in Access, take a look at our page for
step-by-step instructions with screen shots on how you can set it up
in Access Reports:

http://www.barcodewiz.com/screenshots_Access2000.asp

Note that although the page shows our component (BarCodeWiz ActiveX),
the procedure is similar with any barcode component with data binding
capabilities.

You can also download a demo of the component -- it includes an Access
2000 file for you to "play with."

Another option is using barcode fonts, but that's much harder to set
up. With fonts, you will need to worry about the start and stop bars,
calculating check digits, scaling. Commercial barcode fonts usually
come with a "barcode generator" program that encodes the correct
string of characters. You would need to copy and paste it into your
database table first.


Please don't hesitate to ask if you have any questions.


Alek Szymanski

Add barcode capabilities to your programs and documents
http://www.barcodewiz.com
 
Back
Top