Print Barcodes with Microsoft Access Reports

http://tec-it.com - Tutorial video - how to print barcodes in Microsoft Access reports.

Download TBarCode SDK from http://www.tec-it.com and install the bar code component with a double-click. TEC-IT's barcode generator software TBarCode SDK includes a barcode ActiveX control. After installation this bar code ActiveX control can be inserted into a Microsoft Access report with just a few mouse-clicks.

The data to be encoded as bar-code can be adjusted via the property named Control Source: Just specify the name of the table column (or query column) as data source. Multiple bar-codes (in this video a Code 128 and a QR-Code symbol) can be inserted into a single Microsoft Access report.

If required scripting of the barcode control is possible with VBA (Visual Basic for Applications). TBarCode SDK is compatible with all Microsoft Access versions (Access 2000, Access 2003, Access 2007, Access 2010). For 64 bit Office suites download the 64 bit version of TBarCode SDK.

Copyright: TEC-IT Datenverarbeitung GmbH, Steyr, Austria, http://www.tec-it.com

Music: Track Mirteaux from the Album Newborn Butterflies by StrangeZero - http://www.strangezero.gr - http://www.jamendo.com

---

Closed Caption:

In this video you learn how to print a Microsoft Access Report with Barcodes.
First download and install TBarCode SDK from www.tec-it.com.
This barcode generator ActiveX control can be inserted into a Report easily.
Make sure that Microsoft Access is not running during installation.
After installation open Microsoft Access.
This sample database contains a table named Items.
The report should be created using this table.
Two barcodes are required for each record:
a Code 128 for the column Barcode and a QR-Code for the column URL.
Now let's create a new report.
I adjust the column width to my needs.
Switch to the Design View
and prepare the detail area.
Now insert the barcode ActiveX control into the report.
Just select TBarCode in the list of available controls and confirm with OK.
Position the barcode in the detail area
and adjust the Control Source.
The table column specified in the Control Source is used for generating the barcode.
The default barcode type is Code 128 - so no further adjustments are needed.
Now insert a second barcode which is used for the QR-Code.
Select the field URL as control source
and adjust the required barcode symbology.
Set the property BarCode in the category Other to QR-Code.
I correct the layout of the report
and activate the preview.
For each table record the column Barcode is printed as a Code128.
The column URL is encoded as QR-Code.
Please get in touch with TEC-IT if you need more information regarding TBarCode.
We are glad to assist you!
I hope this video has been of interest to you - thanks for watching!