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

    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

    txtOrderID1
    txtOrderID2
    txtOrderID3

    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?

    Thanks

    Aboo

  2. #2
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    994
    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
    Location
    Adelaide, South Australia
    Posts
    4,049
    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
  •