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

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
(3) Encoder DLL (file reference)

The Barcode Font and VBA Font Encoder are included in each 2D Barcode Font Package.
===================================================================================

DATA MATRIX
GS1 Data Matrix Font & Encoder Package
image

===================================================================================

AZTEC
Aztec Font & Encoder Package
image

===================================================================================

PDF417
PDF417 Font & Encoder Package
image

===================================================================================

QR CODE
QR Code Font & Encoder Package

Location of VBA Font Encoder
IDAutomation_QRCodeVBA.bas:
image ****Demo VBA file for QR Code is named: IDAutomation_QR_FontEncoder_VBA_DEMO.bas****

Operating System: Windows

Application: Access
Attachments:

04-28-14     9.8 year(s) ago    

  Report Abuse

 

Ben

Best Answer

The tutorial illustrates how to generate 2D barcodes in MS Access. 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.

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



NOTE: The demo version of the .bas file requires a DLL to encode the data.
image
Licensed Version use: =IDAutomation_DMatrix_FontEncoder()
Demo Version, use: =EncDM()

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:
=IDAutomation_QRCode_FontEncoder_DEMO()
=IDAutomation_QRCode_FontEncoder()


NOTE: If unsure of which formula name to use, return to the VBA and view the function name:


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
All 2D symbologies use the IDAutomation2D font.


20. Run the report.
image



HOW TO CREATE DATA MATRIX WITH FNC1

Posted 9.8 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.

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