Results 1 to 2 of 2
  1. #1
    Eric2013 is offline Novice
    Windows 8 Access 2013
    Join Date
    Mar 2013
    Posts
    14

    Barcode Report

    I'm hoping someone can help me with Barcode.

    I've followed several barcode threads, and i'm still lost. I can make barcodes using Active X Controls ActiveBarcode

    I really want the barcodes to generate in a report and I used the info posted in the link below, and put it in a sample database attached to this thread. Can someone please tell me what i've done in-correctly.



    Thanks to the person that posted this to the code repository.
    https://www.accessforums.net/code-re...rts-33878.html

    and thanks in advance for any help.
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,626
    The code to call function is not within a procedure.

    Report in design view, click on the Detail section. Then on the Event tab of Properties Sheet, click the OnPrint event and select [Event Procedure]. Click the ellipsis (...) to open the VBA editor. Type code to call the function into the event procedure.

    Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
    Dim Result As Boolean
    Result = Barcode_128(Me.Text28, Me)
    End Sub

    Beyond that, I haven't figured out the correct syntax for the function arguments. I've never tried to pass a control into a procedure.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. HELP! Barcode Fonts for ACCESS!
    By jlgray0127 in forum Programming
    Replies: 1
    Last Post: 03-13-2013, 02:14 PM
  2. Getting report values into a PDF417 barcode
    By eskybel in forum Reports
    Replies: 4
    Last Post: 08-06-2012, 10:26 AM
  3. GS1-128 Barcode in Report
    By AKQTS in forum Reports
    Replies: 1
    Last Post: 09-23-2011, 04:36 PM
  4. Barcode control problem
    By ckleung in forum Database Design
    Replies: 0
    Last Post: 07-26-2011, 10:56 PM
  5. barcode
    By techker in forum Access
    Replies: 1
    Last Post: 02-21-2009, 09:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums