Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006

    Unanswered: how do i printing more than one record at a time?

    Hi Guys,

    I know how to filter and print a report based on a variable OrderID.

    I was wondering if it was possible to print out several at a time.

    I have this at the moment

    DoCmd.OpenReport stDocName, acNormal, , "OrderID = " & Me.OrderID

    which prints what i am viewing, i want have several text boxes on a form


    so when a user presses a command button it takes the OrderID's values from the txt boxes and prints those specific Orders. How can i make this happen?



  2. #2
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 2
    You'll need to call your DoCmd line once for each text box, using the value in each text box in turn.

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    Yes, and you could do that with a for loop if the numbers were sequential.

    Either that or you can specify them in the criteria. For example:

    DoCmd.OpenReport stDocName, acNormal, , "OrderID Between 100 And 150"

    But it depends on if the report is designed to print multiples or not.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts