exporting reports as pdf from vba?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
-Adobe Acrobat 8 Professional
Currently our users are exporting reports one-by-one and then combining them after to a single pdf for printing.
Is there a way to export multiple reports to a single pdf file from Access?
Once a report opens we touch our PDF icon on our tool bar(I believe this was downloaded). Then it saves to PDF as if it was printing( I guess this is the norm since we have PDF printer setup.
I would like to save(pdf format) and print theses reports automatically(button) on form.
The name I would like the pdf to be is(reportname-datestamp).
I'm having issues because of the PDF format
If I leave the code in VBA to export any county under 50,000KB, they all work perfect and the database does not corrupt. However, I have one relatively large PDF exports at 166,708KB.
As soon as I run the code to export this PDF file (and compact and repair my database thereafter) I get a error message upon re-opening the database stating that my VBA code is corrupt.
It then prompts me through some more error messages and it ends up erasing VBA code and any objects with VBA code attached. I'm just curious as to the reason why this file size is leading to a database corruption when it's coded into VBA.
We have been using ACG's PDF Pro Plus with A2003.
Most of our PDF stuff is simple, but one program uses their PDF Merge feature which concatenates multiple PDF reports into one PDF. Will the PDF feature in Access do this?
(I suppose sub-reports would be one solution but wonder if there is a better way
Is there anything out there that can do this, short of Acrobat itself? Has anyone encountered this idea and been successful? Are there any free programs available that can do this, and again, preferably not place their logos, etc. onto the file?
What do I have to do to export these reports to Word in the right format? And if I merged the generated document. Is it possible to save this document in the right format as a PDF-document?
ActiveDocument.SaveAs strOutputFileName, wdFormatPDF, .
Can you Output all reports to one PDF?
Example 1 - Printing labels to pdf:
DoCmd.OutputTo acOutputReport, gStrReportName, acFormatPDF, strPathAndFile
Example 2 - Exporting to excel: