Results 1 to 4 of 4
  1. #1
    tuggleport is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2011
    Location
    CA
    Posts
    7

    Printing multiple reports from a for by way of VBA coded button?


    I am trying to get Invoice & Packing Sheet reports to print when only one button has been pushed. For some reason I haven't found anything on the forum to help me do this and I didn't find anything on the web.

    Any help would be greatly appreciated.
    Last edited by tuggleport; 05-23-2011 at 01:50 PM. Reason: clarification

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    You simply put multiple lines of code:

    DoCmd.OpenReport "FirstReport"...
    DoCmd.OpenReport "SecondReport"...
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    tuggleport is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2011
    Location
    CA
    Posts
    7

    Hah - Yes, I got it just before your posted

    Thanks pbaldy! I feel stupid but I guess, after a night of programming and spending the preceding 90 minutes on my coding I posted a question on today as well, my brain was set to "Pure Confusion" when I got to something easy.

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Happy to help! I'm often the victim of brain-cramps, so I feel your pain.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Printing Reports & Send to PDF
    By Dnphm in forum Reports
    Replies: 4
    Last Post: 02-13-2018, 07:25 PM
  2. Printing multiple reports at once based on condition
    By justinwright in forum Reports
    Replies: 24
    Last Post: 04-13-2011, 01:40 PM
  3. Printing reports off a list box
    By kbandong1 in forum Reports
    Replies: 3
    Last Post: 03-05-2011, 09:51 PM
  4. Printing multiple reports with one command
    By AKQTS in forum Reports
    Replies: 2
    Last Post: 09-24-2010, 09:32 AM
  5. Printing Reports....
    By Danny Christie in forum Reports
    Replies: 1
    Last Post: 12-06-2006, 05:51 PM

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