Microsoft Access Barcode

admin

The IDAutomation Microsoft Access Barcode Generator is a VBA Module that can be easily inserted into an Access Report to generate both linear and 2D barcodes. Compatible with Access 2000 to 2007, this product adds dynamic barcode capability without any external dependencies. How to add a Barcode ActiveX to a MS Access: In a Microsoft® Access report in design mode, choose insert - ActiveX control. After this you may size the control as necessary. To change the properties of the control such as barcode height and symbology type, right click on the control and choose properties.

IDAutomation provides several professional-grade products for implementing barcodes in Microsoft Access, including the Office 2013 version, with flexible license agreements to satisfy a variety of needs including small company licenses and royalty-free developer licenses. Compatibility Chart

Recommended Solution:
Integration OptionsAdvantages & DisadvantagesBarcode Types
Tutorial:
Implementing the Native Generator
Product:
Native Barcode Generator for Access
Single Users
From $159
Developers
From $590
  • Embed barcode capability into a database or distributed custom application.
  • Once installed in the database, no other components or fonts need to be installed to create barcodes.
  • Full source code provided for custom modifications.
  • Video: Creating Barcodes with the Native Access Barcode Generator 2003 and 2010.

Additional Integration Options:

* For Access 2013, IDAutomation suggests the Native Barcode Generator for Access or the Barcode Fonts with VBA Macros. The following chart may be used to review additional options:

Integration OptionsAdvantages & DisadvantagesBarcode Types
Tutorial:
Setting up Control in Access
Product:
ActiveX Barcode Control
Single Users
From $199
Developers
From $790
  • Create barcode images with this drag-and-drop object.
  • Requires the applicable ActiveX Control(s) to be installed on every computer that generates barcodes.
  • May be used in Excel, InfoPath, VB and other applications.
  • Compatible with both 32 and 64 bit systems, including Microsoft® Office® 2010 and Windows® 7, 8 & 10.
Tutorial:
Control Source Formula
Product:
Code 39 or Codabar
Single Users
From $159
Developers
From $790
  • The best option when a barcode standard is not required and the data consists of numbers and/or uppercase letters.
  • Requires the applicable barcode fonts to be installed on every computer used to generate barcodes.
Tutorial:
VBA Functions
Product:
Barcode Fonts and VBA Macros
Single Users
From $159
Developers
From $790
  • Easy implementation supporting many barcode types.
  • Requires the applicable barcode font(s) to be installed on every computer used to generate barcodes.
  • Video: Creating Barcodes in Microsoft Access 2003 With VBA Macros
  • When using the Universal Barcode Font, a single font may be used to create multiple barcode types, best for Double Byte Windows and Mac OSX.
Video Tutorials & Information from the IDAutomation's Blog
Related Information
  • If assistance is needed, please contact IDAutomation.

Here we show you how to add a barcode into a Access database report 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:


2

Microsoft Access Barcode Add-in

Next create a new report.


Now add the ActiveBarcode control to the report. You must be in 'Design Mode' to do this.


Microsoft
4

Select the 'Design' tab. Click on the button 'Insert ActiveX control' from the range of 'Controls'.


A dialog will show up:


6

Select 'ActiveBarcode' here and click OK. Now the barcode object will be placed in your report. 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.


8

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, ...

Microsoft Access Barcode Scanner

Now place and resize the barcode element for your needs.


Next we bind the controls text property (the barcodes content) to the data field 'Code' of the database. Select the 'Design' tab. Click on the button 'Property sheet' from the range of 'Tools'.

Microsoft Access Barcode


10

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


Now close the design mode and switch to report view:


Microsoft Access Barcode Scanner

12

Microsoft Access Barcode Control 14.0

Watch the result:


Microsoft Access Barcode Scanner

The barcode control is bound to the data base field and shows the code of the current data set as EAN-128 barcode.
One last hint: A report is designed in a lower resolution that it is using while printing. So it may be 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.