Earn Points & Redeem with attractive offers!
You can earn points, by asking, answering, voting questions and redeem with
attractive offers
. To view various available redemption schemes, please visit
"My Profile".
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
Ask
Ask a question. Make sure you select the correct category for the question.
Answer
Like to help others? Then browse through the open questions to answer their questions.
Find
Find answer by browsing the resolved questions.
     
Search for Questions:
My Profile

Ben

Resolved Questions Bookmark and Share

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_DataMatrix_Macro.bas:
image



Operating System: Windows

Application: MS Access

08-23-16     366 day(s) ago     Views: 793

    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.

Location of VBA Font Encoder IDAutomation_DataMatrix_Macro.bas:
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.
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 =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



20. Run the report.
image



HOW TO CREATE DATA MATRIX WITH FNC1



Posted 366 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://")
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:// ")
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 2017 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