Results 1 to 4 of 4
  1. #1
    webfactoryuk is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2011
    Posts
    25

    Output multiple reports to one PDF

    Only other problem Im having is the above.

    I can setup a macro to print the reports and I can convert each one to PDF on its own.

    Can you Output all reports to one PDF?

    Thanks in advance



    Sam
    Last edited by webfactoryuk; 04-06-2011 at 05:47 AM. Reason: Solved:

  2. #2
    webfactoryuk is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2011
    Posts
    25
    Ok so it seems MS decided to exclude this as a standard feature but I have found a work around!

    http://www.exp-systems.com/pdfredirect/downloads.htm

    PDF conversion software that catches print jobs and then merges all the docs sent once your ready.

    Brilliant!

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Excellent! Thanks for posting back with your solution. You can go ahead and use the Thread Tools and mark this thread as Solved yourself.

  4. #4
    lilysia is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2011
    Location
    USA
    Posts
    2
    The way webfactoryuk suggested is to create a single PDF file from multiple documents, yep, many PDF creation software support to import many documents then export as one PDF file.

    Alternatively, you can firstly respectively convert each report to separate PDF file, then use a PDF Merger to combine PDF files into one.

    Above are two feasible solutions for you to go. Hope it helps!

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

Similar Threads

  1. Multiple Sub Reports
    By Top Fuel Friday in forum Reports
    Replies: 8
    Last Post: 02-17-2014, 11:37 AM
  2. Query output for forms & reports
    By Dega in forum Forms
    Replies: 2
    Last Post: 08-20-2010, 12:45 PM
  3. output to multiple pdf files
    By geoffishere in forum Reports
    Replies: 1
    Last Post: 07-04-2010, 03:39 PM
  4. Multiple Reports in cmd.SendObject
    By Steven.Allman in forum Access
    Replies: 1
    Last Post: 06-21-2010, 09:59 AM
  5. Multiple Reports within Report
    By jakelufkin in forum Reports
    Replies: 0
    Last Post: 08-31-2009, 08:42 AM

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