We use cookies to provide you with the best experience and functionality on our website. By continuing to use the site, you are agreeing to our use of cookies.   

Access 2000, XP, 2003
Barcodes in forms

EnterpriseInfoTo use this functionality you require the Enterprise Edition

Access 2000, XP, 2003

Barcodes in an Access 2000, XP, 2003 database, formular or report

Here we show you how to add a barcode into a Access database and bind it to a data field. First launch Access and create a new database or open an already existing database in what you want to add a barcode. A simple database could look like this:

Barcode, Access 2000, XP, 2003

Fill the database with some data using the table. See this example:

Barcode, Access 2000, XP, 2003

Next create a new form. This is easy and we do not explain this functionality of Access further. If you have questions about this, please have a look into the Access Online Help

Now add the ActiveBarcode control to the form. Goto to the menu and select from the the menu "Insert" the function "ActiveX Control...".

Barcode, Access 2000, XP, 2003

The following dialog will appear:

Barcode, Access 2000, XP, 2003

Select "ActiveBarcode" here and click OK. Now the barcode object will be placed in your form. This will be a standard barcode of EAN-128 type. This is the default type. Now you can modify this barcode. You can change the type, text, colors etc. For this click inside the barcode with the right mouse button. A pop up menu will open:

Barcode, Access 2000, XP, 2003

Select "ActiveBarcode-Object" and then "Properties...". The property dialog of ActiveBarcode will open. Here you can modify the barcode as you like. For example you can change the type to any barcode type supported by ActiveBarcode: QR Code, GS1/EAN-128, Data Matrix, GTIN/EAN-13, Code 39, GS1-Data Matrix, Code 128, PDF417, DUN-14, EAN-8, EAN-14, EAN-18, ISBN, ITF-14, NVE, PZN8, SCC-14, SSCC-18, Code 25, ...

In this example we use the EAN-128, so there is no need to change the type now.

Next we bind the controls text property (the barcodes content) to the data field "Productnumber" of the database. Again click the barcode with the right mouse button and select "Properties":

Barcode, Access 2000, XP, 2003

Have a look for the entry "Control Source" and change it to "Productnumber". This is the data binding:

Barcode, Access 2000, XP, 2003

Now close the design mode of the form and watch the result by simple opening the form:

Barcode, Access 2000, XP, 2003

The barcode control is bound to the data base field and shows the product number of the current data set as EAN-128 barcode.

Embedding and binding an ActiveBarcode control into reports is very similar.

One last hint: A report is designed in a lower resolution that it is using while printing. So it is required that you create the barcode control with a much bigger font size than you would normally use. Otherwise the text line under the barcode may be very very small in your print.

This manual was created by Frank Horn

Search this site with Bing:
| Home | Shop | Download | E-Mail | Datenschutz | Imprint | Version 6.1.0 |
Web DesignszCWs 2.0.12.597
Web design & developement:
www.frank-horn.com

Copyright
Frank HornActiveBarcode Generator App
Web design
Documentation
Copyright Frank Horn
&
Lars SchenkActiveBarcode Object
Web- & server component
Command line
Copyright Lars Schenk

All trademarks and product names mentioned are the property of their respective owners.