New User? Sign Up  |  Sign In  |  Help
IDAutomation Logo
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

How to create Data Matrix Barcodes in Access using Barcode Fonts?


To generate barcodes in Access using a font and encoder solution requires three components (all included in the package):

(1) Font Encoder DLL
(2) VBA file
(3) Barcode Font

• The Font Encoder DLL is installed on the system. It is responsible for formatting/encoding the data.

• The VBA file is responsible for sending the data to the font encoder and retrieving the encoded data.

• The Barcode font is applied to the encoded data.

What is an encoder? An encoder is a plug-in, add-in, source code, or dll that takes in raw data and produces output data that the barcode font can understand.

The tutorial explains how to generate Data Matrix barcodes in MS Access. The database is already created and includes a report.

Data Matrix Font and Encoder for Windows

Data Matrix Font and Encoder Suite

Font name is IDAutomation2D.ttf

Location of VBA Font Encoder IDAutomation_VBA_DataMatrix_FE2021.bas:
image

Operating System: Windows

Application: MS Access

08-23-16     8.2 year(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 are 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.

Location of VBA Font Encoder IDAutomation_VBA_DataMatrix_FE2021:
image



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. NOTE - When working with the 2021 and higher purchased font and encoder package, you may skip this step.
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-click 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 =IDAutomation_DMatrix_FontEncoder([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



20. Run the report.
image



HOW TO CREATE DATA MATRIX WITH FNC1

Posted 8.2 year(s) ago

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

 Categories
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 2021 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