Fontware Barcode Font Demos now support Microsoft Excel Add-in, Access Module and ACTIVEX DLL
Our New Microsoft Excel, Access and ACTIVE X DLL support programs have been developed to allow easy integration of Fontware Barcode Fonts.
LL support software
Visit our download pages to download our new barcode demos
Microsoft Excel Add-in
Installing the Excel Add-in within Excel.
Load Microsoft Excel, click on Tools and select Add-ins.
Select Add-ins and click on the Browse button and locate and select the excel add-in. Click OK, now the Add-in is installed and click OK again
Manually Installing the Excel Add-in
Copy the .xla (for example code39.xla for Code 39) file into your c:\program files\microsoft office\office\XLStart folder (this may be on a different drive and/or directory depending on how you installed office).
Take a look at the formula bar for the way you would call the barcode function (it's much like using the SUM or DIVIDE functions).
The formula is CODE39("your data")

Barcode Formula available to use.
Code 39 Excel Pack
FORMULA NAME DESCRIPTION
=CODE39
=CODE39CHECK
 Code 39
Code 39 with a Check Digit
EAN / UPC Excel Pack
FORMULA NAME DESCRIPTION
=UPCA
=UPCAHUMANREADABLE
=UPCAADDON2
=UPCAADDON5
=EAN8
=EAN8HUMANREADABLE
=EAN8ADDON2
=EAN8ADDON5
=EAN13
=EAN13HUMANREADABLE
=EAN13ADDON2
=EAN13ADDON5
 UPC Version A
UPC Version A with Human Readable Text
UPC Version A with 2 supplement digits
UPC Version A with 5 supplement digits
EAN 8
EAN 8 with Human Readable Text
EAN 8 with 2 supplement digits
EAN 8 with 5 supplement digits
EAN 13
EAN 13 with Human Readable Text
EAN 13 with 2 supplement digits
EAN 13 with 5 supplement digits
Interleaved 2 of 5 Excel Pack
FORMULA NAME DESCRIPTION
=INTERLEAVED2OF5CHECK
=INTERLEAVED2OF5NOCHECK
 Interleaved 2 of 5 with check digit
Interleaved 2 of 5 with out check digit
EAN 128/Code 128 Excel Pack
FORMULA NAME DESCRIPTION
=CODE128SUBSETA
=CODE128SUBSETB
=CODE128SUBSETC
=EAN128
 Code 128 sub set A supports Uppercase, numeric and special control characters
Code 128 sub set B supports Uppercase, lowercase, numeric and special control characters
Code 128 sub set C supports numeric only in paired values from 00-99 plus special control characters.
EAN 128 uses Code 128 sub set C with special FUNC 1 character.

Microsoft Access Module
The Microsoft Access Modules require the ACTIVEX DLL to be installed prior to use.
Do not load a database at this point, click cancel. First we need to register an ACTIVEX control.
  1. Click on Tools and select ActiveX Controls.
  2. Click on the register Button.
  3. Change the List Files of Type to Libraries (*.DLL). Locate the eg. Code128.DLL
  4. Highlight the DLL file and click on OPEN.
  5. The ActiveX control is now registered. Click on Close.

Load the Sample Database

  1. Click on File Open and locate the supplied access file, eg. code_128.mdb.
  2. Highlight the .MDB and click on OPEN.
  3. With in this sample database are examples on how to use barcode functions in Access.

Installing the Modules into an existing Database.

  1. With your database open, select File/Get External Data/Import.
  2. Locate the supplied Access module, eg: code128.mdb, and click Import.
  3. An Import Objects window will appear.
  4. Select Modules.
  5. Locate the CODE128 module and click OK.
  6. The module will appear on the Modules tab of your database.
  7. You will need to register the ACTIVEX DLL to use the Barcode Modules.
  8. Click on the Module tab and highlight the CODE128 Module.
  9. Click on Design, under the Tools Menu select References option. An ActiveX reference is listed below, on the list scroll down until you find your Barcode, tick this option and click OK.
Code 39 Access Pack
ACCESS NAME DESCRIPTION
CODE_39_CHECK
CODE_39_NOCHECK		 Code 39 with Check Digit
Code 39 with out a Check Digit
ACTIVEX Reference  Description
Fontware - Code 39
EAN 128/Code 128 Access Pack
ACCESS NAME DESCRIPTION
CODE128SETA
CODE128SETB
CODE128SETC
EAN_128		 Code 128 sub set A supports Uppercase, numeric and special control characters
Code 128 sub set B supports Uppercase, lowercase, numeric and special control characters
Code 128 sub set C supports numeric only in paired values from 00-99 plus special control characters.
EAN 128 uses Code 128 sub set C with special FUNC 1 character.
ACTIVEX Reference  Description
Fontware - Code/EAN 128
EAN /UPC Access Pack
ACCESS NAME DESCRIPTION
UPC_A
UPC_A_HUMANREADABLE
UPC_A_ADDON2
UPC_A_ADDON5
UPC_E
UPC_E_Addon2
UPC_E_Addon5
EAN_8
EAN_8_HUMANREADABLE
EAN_8_ADDON2
EAN_8_ADDON5
EAN_13
EAN_13_HUMANREADABLE
EAN_13_Addon2
EAN_13_Addon5		 UPC Version A
UPC Version A with Human Readable Text
UPC Version A with 2 supplement digits
UPC Version A with 5 supplement digits
UPC E
UPC E with 2 supplement digits
UPC E with 5 supplement digits
EAN 8
EAN 8 with Human Readable Text
EAN 8 with 2 supplement digits
EAN 8 with 5 supplement digits
EAN 13
EAN 13 with Human Readable Text
EAN 13 with 2 supplement digits
EAN 13 with 5 supplement digits
ACTIVEX Reference  Description
Fontware - EAN / UPC
Interleaved 2 of 5 Access Pack
ACCESS NAME DESCRIPTION
I2OF5CHECK
I2OF5NOCHECK		 Interleaved 2 of 5 with check digit
Interleaved 2 of 5 with out check digit
ACTIVEX Reference Description
Fontware - Interleaved 2 of 5
ACTIVEX DLL Function Library
This ActiveX DLL enables you to generate bar codes from within Microsoft Visual Basic or any other ActiveX-compliant application.

Before you use this control, you'll need to register it first. There are 2 ways to do this.

Let VB handle the registration.
1. Go to the "Tools/References" menu option
2. From there, click on the Browse button and locate the DLL
3. Click OK
The registry will load the DLL, and you can then find it on the list box

Register the DLL manually

1. Change to the directory that contains the DLL
2. Type " regsvr32 [DLLNAME]"
It should return a dialog stating that the control was successfully registered
Code 39 ActiveX Pack

Back to the top of the page
Active X Function DESCRIPTION
CODE39CHECK
CODE39NOCHECK		 Code 39 with Check Digit
Code 39 with out a Check Digit
ACTIVEX Reference Description
Fontware - Code 39
EAN 128/Code 128 Active X Pack
Active X Function DESCRIPTION
CODE128SUBSETA
CODE128SUBSETB
CODE128SUBSETC
EAN128		 Code 128 sub set A supports Uppercase, numeric and special control characters
Code 128 sub set B supports Uppercase, lowercase, numeric and special control characters
Code 128 sub set C supports numeric only in paired values from 00-99 plus special control characters.
EAN 128 uses Code 128 sub set C with special FUNC 1 character.
ACTIVEX Reference Description
Fontware - Code 128 - EAN 128
EAN /UPC ActiveX Pack
Active X Function DESCRIPTION
UPCA
UPCAHUMANREADABLE
UPCAADDON2
UPCAADDON5
UPCE
UPCEADDON2
UPCEADDON5
EAN8
EAN8HUMANREADABLE
EAN8ADDON2
EAN8ADDON5
EAN13
EAN13HUMANREADABLE
EAN13ADDON2
EAN13ADDON5		 UPC Version A
UPC Version A with Human Readable Text
UPC Version A with 2 supplement digits
UPC Version A with 5 supplement digits
UPC E
UPC E with 2 supplement digits
UPC E with 5 supplement digits
EAN 8
EAN 8 with Human Readable Text
EAN 8 with 2 supplement digits
EAN 8 with 5 supplement digits
EAN 13
EAN 13 with Human Readable Text
EAN 13 with 2 supplement digits
EAN 13 with 5 supplement digits
ACTIVEX Reference Description
Fontware - EAN / UPC
Interleaved 2 of 5 ActiveX Pack
Active X Function DESCRIPTION
INTERLEAVED2OF5CHECK
INTERLEAVED2OF5NOCHECK		 Interleaved 2 of 5 with check digit
Interleaved 2 of 5 with out check digit
ACTIVEX Reference Description
Fontware - Interleaved 2 of 5
Home | Contact | About Us | Price List | News | Support | Shopping
All Trademarks Are The Property Of Their Respective Owners - updated 25 April 2001
Want to resell Fontware products?  Click here to register your interest