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 generate barcodes using the Access Native Generator


The Native Barcode Generator for Microsoft Access.

Operating System: Windows

Application: Access

04-11-14     9.9 year(s) ago    

  Report Abuse

 

Ben

Best Answer

The tutorial describes how to generate Code 128 barcodes using the Native Generator for Access in Microsoft Access 2013.

The example uses the table named Villains in the Characters database:
image

The barcodes will be placed on a report created from the Villains table:
image


1. Download the Native Generator for Access Linear or 2D version.
image



2. Right-click the product zip and choose Extract All. Follow the extraction process.
image



3. The tutorial uses the Linear/2D version of the Native Access Generator. Because we need to generate a Code 128 barcode, select the IDAutomation_AccessBarcodeGenerator folder.
image



4. IDAutomation includes a sample database that displays barcodes named IDAutomation Native Barcode for Access.mdb. However, because the tutorial explains how to use the product in your own database, select the VBA modules folder.
image



5. Note the location of the IDAutomation_Native_Barcode_VBA.bas file. We will import this fine into Microsoft Access using the Visual Basic Editor.
image



6. Open Access and select the Create tab.
image



7. Select Visual Basic.
image



8. In the Visual Basic editor, select File--Import File.



9. Navigate to the IDAutomation_Native_Barcode_VBA.bas file;location noted in step 5.
image



10. To view the VBA, select View--Project Explorer.
image



11. Select File and choose Close and Return to Microsoft Access.



12. Right-click the report and select Design View.
image



13. In Design view, the report should resemble this screenshot.
image



14. In the Design tab, select the Text Box with a left-click.
image



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



16. Left-click the label and select the Delete key. Resize the Text Box to the desired size.



17. Right-click on the text box and select Properties. Change the Name of the text box to Barcode1 or desired name and verify the control source is the field that needs to be encoded in the barcode.
image



18. Save the report. Right-click the report and select Layout View.
image


Verify that the data to be encoded in the barcode appears in the text box. If it does not, consult Access Help to determine how to get the correct data in the text box. The result of the Control Source in the text box is what will be encoded in the barcode. In some instances, it may be necessary to specify the table and field in the control source, for example: =([Table1.Field1])
image



19. Return to Design Mode.



20. Right-click the Detail section of the report and choose Build Event.
image



21. Choose Code Builder and select OK.
image



22. This will open the Visual Basic editor Microsoft Access Class Objects folder.
image

Remove the code in this area and replace it with:
Option Compare Database
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
result = IDAutomation_NatG_C128(Barcode1, Me)
End Sub




23. Select File and choose Close and Return to Microsoft Access.



24. To run the report, double-click it.



25. Because the report is created in Access 2013, the barcode will not be visible during the Detail_Print display. To display the barcode run a Print Preview or Print the report directly to the printer.
image


BARCODE TYPES/FUNCTIONS LIST/PARAMETERS

Posted 9.9 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