Results 1 to 4 of 4

How to export a report into a pdf but have each on a seperate page

  1. #1
    mdnikki is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2012
    Posts
    55

    How to export a report into a pdf but have each on a seperate page

    Good morning,



    I have a report in Access that I would like to export. Both as a pdf and as a word document. However it is 138 pages of reports and I want to know how I can export them into individual pages and not one pdf of 138 pages.

    I know I can create queries for each page then a macro to send them to their destination but I am hoping there is some kind of macro or something I can run that will separate them without having to make all the queries.

    What will separate them is a code. We are a religious organization so I want each parish code to have its own report.

    I am not a macro/VB expert so if you could explain in detail that would be great.

    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    6,840
    Is each page a separate Group, (page 1 = "England",page 2 = "India") ?
    or is it all just random data?

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    13,012
    You could have a list of Parish codes, and a report.
    Set up a loop the generates a pdf for each Parish

    General outline of process:
    Code:
    For i = 1 to parishCount
     generate pdf for Parish(i)
    next i

  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
    18,736
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 9
    Last Post: 07-07-2017, 06:39 AM
  2. Export All Tables To Seperate XLSX Files
    By jo15765 in forum Modules
    Replies: 4
    Last Post: 09-06-2016, 08:28 AM
  3. Export each page of the report to a seperate PDF file
    By naeemahmad in forum Programming
    Replies: 14
    Last Post: 12-04-2013, 08:18 AM
  4. Export Report with Page Headers to Excel
    By EddieN1 in forum Reports
    Replies: 1
    Last Post: 09-01-2012, 11:37 AM
  5. Export First Page of Report for Each Unique Header
    By ertweety in forum Programming
    Replies: 3
    Last Post: 06-05-2012, 05:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums