Results 1 to 4 of 4
  1. #1
    mdnikki is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2012
    Posts
    63

    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 offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    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 offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    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 offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    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. Replies: 9
    Last Post: 07-07-2017, 07:39 AM
  2. Export All Tables To Seperate XLSX Files
    By jo15765 in forum Modules
    Replies: 4
    Last Post: 09-06-2016, 09: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, 09:18 AM
  4. Export Report with Page Headers to Excel
    By EddieN1 in forum Reports
    Replies: 1
    Last Post: 09-01-2012, 12:37 PM
  5. Export First Page of Report for Each Unique Header
    By ertweety in forum Programming
    Replies: 3
    Last Post: 06-05-2012, 06: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
  •  
Other Forums: Microsoft Office Forums