Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Ontario, Canada
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access 2010_Append single-page report to a multi-page report then to PDF

    Hi All, We have a form that contains a long list of records. The form allows us to select either individual records or many records based on our requirements. Once the records are selected, we click a button to generate reports for these selected records. The reports are then output to PDF files with generated filenames automatically. The PDF reports may or may not single-paged. The PDF files are then posted to an Intranet website for manufacturing. Now, however, we're being asked to append a new page to each report, and we have hundreds of PDFs to update. I'd like a way to add this new "page" perhaps as a separate unbounded report when outputting to PDF. I do not want any of the header/footer info from the original report added to the appended page. I tried to create a third report which included the original multi-page report and the new single-page report as sub-reports, but the formatting is not working out well. Also, I'm not sure how to pass the selected record set to the new (third) report. One other item worth mentioning is that the new sheet we're being asked to append to all our reports is in landscape format. It's a static page that is independent of any records in the database. So, I was wondering if we could merely use VBA code to somehow append the new form as a PDF onto our existing reports when we're outputting them to PDF. I hope that makes sense. Drew

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    I don't think you can do this from Access, at least not easily. You'd have to do what you tried to do (a subreport in the report footer), but somehow suppress the other page formatting (page headers, etc.).

    I believe a better solution is to find a 3rd party utility that allows you to combine PDF files (I think I've seen one out there before). You can then create each of your PDF's in Access, then execute a command line that would combine them.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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