Page 2 of 2 FirstFirst 12
Results 16 to 24 of 24
  1. #16
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664

    @saeedmzm,

    You do realize that this thread is almost 2 years old?
    What you have done is called "Hi-jacking a thread".


    You will have a better chance of getting responses by starting your own thread and referencing this thread if it is relevant.

  2. #17
    MAJORA is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    May 2018
    Posts
    1
    Thank you for this practical case
    Thank you for this practical case

  3. #18
    RafeeqQasem is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2021
    Location
    Usa
    Posts
    1
    I want I want help getting a module to create qr Code in Arabic language

  4. #19
    ssanfu is offline Master of Nothing
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    @RafeeqQasem,

    What you have done is called "Hi-jacking a thread" because you asked a question in a thread you did not start.

    You will have a better chance of getting responses by starting your own thread and referencing this thread if it is relevant.

  5. #20
    chris3371 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    1
    I tried getting this to work but couldnt. I downloaded the free 3 of 9 which worked.

    In the Control Source of the text box ="*" & [Your Field] & "*"

  6. #21
    Sunshack is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    10
    Quote Originally Posted by Rawb View Post
    Code 128 Barcodes
    Usage:
    • Step 1 - Paste the function below into a VBA Module.
    • Step 2 - In your Reports, create a Text Box with the dimensions you want the barcode to fill.
    • Step 3 - Set the Text Box's Visible Property to No.
    • Step 4 - In the Report Detail's On Print Event, add Result = Barcode_128(Me!MyTextBox, Me). You may need to Define the variable Result as a Boolean first.
    • Step 5 - Print out the Report (or view it via "Print Preview") to see your barcode!
    Hi!

    I am a total beginner, and I am trying to work out how to do Step 4. Ive tried to add the on print event as described, but im not sure what exactly Me!Mytextbox and "Me" is supposed to be. Or if I need to name my module something specifically...I also have no idea how to define the variable result as a Boolean :/

    Any help is greatly appreciated! Please spoon feed like you would a 3 year old


    NEVER MIND! I FIGURED IT OUT


    By reading the description on the Code_39, stuff made a whole lot more sense to me!
    Last edited by Sunshack; 02-11-2023 at 04:51 AM. Reason: I found out where i went wrong :)

  7. #22
    hollsten is offline Novice
    Windows 11 Access 2019
    Join Date
    Jul 2024
    Posts
    1
    Anyone know how to get 128c (not 128b) barcodes?

  8. #23
    Zaust is offline Novice
    Windows 10 Office 365
    Join Date
    Sep 2024
    Posts
    1
    I couldn't get this running but found from the sample db provided that the "On Print" event needed to point to an event procedure. That subroutine should contain the "Result = Barcode_128(Me.MyTextBox,Me)" line - you can't put it directly on the report's print event.

  9. #24
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,237
    Replied to old post in error.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. VBA Code to Print MS Access Reports to PDFCreator
    By NeilIrving in forum Programming
    Replies: 3
    Last Post: 11-20-2012, 07:08 AM
  2. Adding SQL Code to VBA
    By REAbernathy in forum Programming
    Replies: 20
    Last Post: 09-06-2012, 02:29 PM
  3. Tracking values in Access reports in Code
    By dahcjohnson in forum Programming
    Replies: 3
    Last Post: 05-11-2012, 04:43 PM
  4. Printing barcodes through Access
    By JackieEVSC in forum Reports
    Replies: 1
    Last Post: 11-16-2011, 11:21 AM
  5. Adding Running Balance from Form to Reports
    By KIDGEO3 in forum Reports
    Replies: 1
    Last Post: 01-18-2006, 08:52 AM

Tags for this Thread

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