Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Sep 2001
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing Multiple Reports from a form (Access 2000)

    I have a database for storing manufacturing data and notes about customer orders. When the order is complete, the users need to print several reports that are tied to a common order number. I think I can do this by creating a form with an unbound text box for entering the order number, then setting up option buttons tied to each applicable report (not all reports are applicable to all orders). I just don't know how to actually execute the print job based on only the option buttons selected. Also, some reports require more than one copy.

  2. #2
    Star Lounger
    Join Date
    Sep 2001
    Location
    SC, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Multiple Reports from a form (Access 2000)

    For two copies of a report try this:
    DoCmd.SelectObject acReport, "nameof report", True
    DoCmd.PrintOut , , , , 2
    Can you give some more info about the options?
    <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  3. #3
    Lounger
    Join Date
    Sep 2001
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Multiple Reports from a form (Access 2000)

    The option buttons would be different reports that could be selected for a given order. Right now I have 9 different reports that may need to be printed for a given order. Usually not all 9 are required, I was hoping to have the user select the reports desired by clicking the option button for that report. Then all I would like them to be have to do is click one print button that spit out all the different reports selected, whether that is 2 or 5 or 7. Does that help?

  4. #4
    Star Lounger
    Join Date
    Sep 2001
    Location
    SC, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Multiple Reports from a form (Access 2000)

    You can let the "Print" button run code or a macro that runs based on conditions. Check each option button, and if true print the applicable report. Only options checked will generate a report. <img src=/S/yadda.gif border=0 alt=yadda width=15 height=15>

  5. #5
    Lounger
    Join Date
    Sep 2001
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Multiple Reports from a form (Access 2000)

    Right, that is what I'm looking for. I don't know how to write the code, that is the help I'm looking for. I can understand the code when I see it, but I'm still learning how to write from scratch. Too much work, not enough time to self train.

Posting Permissions

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