New User? Sign Up  |  Sign In  |  Help
Barcode support and
tutorials from IDAutomation
and the community.
Click for the BBB Business Review of this Computers Hardware, Software & Services in Tampa FL
Resolved Questions Bookmark and Share
Ben

How to Create 2D Barcode in Access using Barcode Fonts

How to create 2D barcodes:

Data Matrix
Aztec
PDF417
QR Code

To generate barcodes in Access using a font requires two components:
(1) Barcode Font
(2) VBA Font Encoder

The Barcode Font and VBA Font Encoder is included in each 2D Barcode Font Package.
______________________________________________________

DATA MATRIX

Data Matrix Font and Encoder for Windows

Data Matrix Font and Encoder Package

Font name is IDAutomationDMatrix.ttf

Location of VBA Font Encoder IDAutomation_DataMatrix_Macro.bas:

It is located in a path similar to:
image
image


***If using the version created after 8-2015, the VBA is located in the Integration folder of the product.
image ***
______________________________________________________

AZTEC

Aztec Font and Encoder Package

Font name is IDAutomation2D.ttf

Location of VBA Font Encoder IDAutomation_Aztec_Macro.bas

It is located in a path similar to:
image image

______________________________________________________

PDF417

PDF417 Font and Encoder for Windows

PDF417 Font and Encoder Package

Font name is IDAutomationPDF417n3.ttf

Location of VBA Font Encoder IDAutomation_PDF417_Macro.bas

It is located in a path similar to:
image

______________________________________________________

QR CODE

QR Code Font and Encoder Package

Font name is IDAutomation2D.ttf

Location of VBA Font Encoder
IDAutomation_QRCodeVBA.bas:

It is located in a path similar to:
image

***NOTE: If working with the 2015 and up of the QR Code package, there is a new VBA file named:
IDAutomation VBA for QR-Code.bas located within the IDAutomation QR Code Font Package:

image

Operating System: Windows

Application: Access 2013

04-28-14     1968 day(s) ago    

  Report Abuse

 

Ben

Best Answer

The tutorial illustrates how to generate 2D barcodes in MS Access 2013. The database is already created and includes a report generated by data within a table.


Table:
image

Report:
image

The tutorial generates a Data Matrix barcode by encoding the data with the VBA Font Encoder and applying the Barcode Font.

The tutorial assumes that the Font and Encoder is installed.

1. Locate the VBA Font Encoder for the Barcode Font and Encoder Package. For the location of the VBA, view the barcode type that you are attempting to generate above. Remember the location of the file.

Example for Data Matrix: IDAutomation_DataMatrix_Macro.bas
image
(Use the .bas file for the barcode type that you want to create - PDF417, QR Code, Aztec, MaxiCode).

2. Open the Access.
image



3. Select the Create tab.
image



4. Select Visual Basic.
image



5. In the Visual Basic Editor, select File--Import File and navigate to VBA Font Encoder.



6. Select the file and choose Open.



7. The VBA Font Encoder is placed in the Modules folder. Ensure that only one instance of the VBA file is imported.
image


8. Select Tools - References then select the barcode type to create and choose OK.
image


9. Select File and then Close and Return to Microsoft Access.
image



10. Right-click the report and select Design View.



11. In the Design tab, left-clickt the Text Box.
image



12. Navigate to the Details section of the report and left-click. It will place the Text Box into the report.
image



13. Left-click the label and select the Delete key.



14. Right-click the Text box and select Properties.



15. Within the Property Sheet, select the All tab.



16. In the Control Source, enter the formula for Data Matrix as =EncDM([Field])
image

For Aztec, use =EncAztec()
For PDF417, use =IDAutomation_PDF417()
For QR Code, use =EncQR()


***NOTE: If working with the QR Code Font Package (2015 version and up), the new function name is:
=IDAutomation_QRFontEncoder()



17. To confirm the data is encoded. Double-click the report.
image



18. Return to Design View and select the barcode field.



19. In the top left of the application, select Home, and then in the font window enter the barcode font
image

For Aztec and QR Code, apply the IDAutomation2D
For PDF417, apply the IDAutomationPDF417n3


20. Run the report.
image



HOW TO CREATE DATA MATRIX WITH FNC1

Posted 1968 day(s) ago

()
()
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.

Email this question link to friends
You must enter an email address, if name is entered or vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must starts with "http://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always starts with " http:// ")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 Characters are allowed. Current Count: 0
  Your comment on this answer
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must start with "http://" or "https://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always start with "http://" or "https://")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 characters are allowed. Current Count: 0

You may answer and comment on any thread according to the Terms and Conditions.

 © Copyright 2019 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook