+ Reply to Thread
Results 1 to 3 of 3

Thread: Can you PDF multiple reports in one go?

  1. #1
    Registered User
    Join Date
    11-12-2011
    Location
    Leeds, Endland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Can you PDF multiple reports in one go?

    Hi, im using access 2007 to write surveys up. When ive finished i then individually PDF the reports up, numbered from 1-9. Is there a way of PDF-ing all 9 reports in one go?
    The next survey i write up will be on a new access document. Im also fairly new to access.

    Thank you.

  2. #2
    Registered User
    Join Date
    01-16-2012
    Location
    Goodyear, AZ
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Can you PDF multiple reports in one go?

    Yes with a Macro
    OPENREPORT
    Open: (report name)
    Filtername: blank
    where condition: blank
    window mode: hidden
    Create more Open Reports for all the different reports you want to print, then
    PRINTOUT
    printrange: all
    print Quality: high (or what ever you want
    copies: # Howmany you need
    Then
    CLOSEWINDOW

  3. #3
    Registered User
    Join Date
    11-12-2011
    Location
    Leeds, Endland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Can you PDF multiple reports in one go?

    Hi,thank you for your reply, this has been extremely helpful and can pottentially save loads of time.

    Im new to MACRO but i managed to follow your instructions. I did a OPEN REPORT for each of my reports.
    I dont have a 'PRINTOUT' option, i have nothing begining with P. I have 'OUTPUT TO', which i chose instead.
    I chose OBJECT TYPE as report
    i chose OBJECT NAME as the 1st report name, it wouldnt let me leave it blank when runnung macro.
    I left OUTPUT FILE blank as the next time i do this it will be using different reports with a different file name. And because it was blank i left AUTO START on NO.
    I then had to create a OUTPUT TO for each of the reports.
    When i run the macro, it asks me to save each file individually, the first time it asks for the location, which i choose the location of the access file, then i click save for every report after.
    Is it possible to save all reports in one go instead of individually?

    thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.2.0