Printing Barcodes with Microsoft Access Forms

http://tec-it.com - This short tutorial video shows you how to use barcodes in Microsoft Access forms.

Download TBarCode SDK from http://www.tec-it.com and install the bar code component with a double-click. After installation this bar code ActiveX control can be inserted into Microsoft Access forms with just a few mouse-clicks.

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

After the form was designed its content are printed using a Microsoft Access print button. The barcode control can be scripted with VBA (Visual Basic for Applications).

TBarCode SDK is compatible with all 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 I'll show you how to print bar-codes with Microsoft Access Forms.
First download and install TBarCode SDK from www.tec-it.com.
This barcode generator ActiveX control can be inserted into Access Forms easily.
Make sure that Microsoft Access is not running during installation.
After installation I open Microsoft Access.
This sample database contains a table named Items.
The column Barcode should be used to encode the item number as a Code128 symbol.
The URL column should be encoded as a QR Code, a 2D barcode.
Now let's create a new form using the Form Wizard.
Select the required table fields
and confirm with a click on Finish.
Switch to the Design View
and insert the barcode ActiveX control into the form.
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 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.
Finally insert a Print button.
Let's check the result now!
The field Barcode is displayed as a Code128 symbol.
The field URL is encoded as QR-Code.
Everything is perfect, you are ready for printing!
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!