Topics Search

exporting reports as pdf from vba?

exporting reports as pdf from vba?
Views: 178
I know this is a new feature in 2010; the help files don't seem to detail it at all. anyone here have any experience yet automating the pdf export from vba? I'm sure its not that hard, just haven't done it yet
Sponsored Links:

Similar posts...


Exporting Reports Question

Exporting Reports Question Icon
-Access 2007
-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?

automated PDF file from reports

automated PDF file from reports Icon
We have many reports we manually save to PDF files and then print. This can take hours just saving to PDF and printing.

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

Exporting to PDF via VBA Causing Database Corruption

Exporting to PDF via VBA Causing Database Corruption Icon
I have a database that I have built that needs to export a large set of data to PDF for each county in Florida. If I manually export of these (without VBA code) to PDF, they work fine and my database does not go corrupt.

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.

Access 2007 and PDFs Question

Access 2007 and PDFs Question Icon
Soon we will be migrating from A2003 to A2007 (but don't have A2007 from our infrastructure people yet).

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

Can I combine reports into one pdf file?

Can I combine reports into one pdf file? Icon
I am currently running an Access application that creates several reports. I want to put these reports into pdf files, and preferably would love to combine all the reports into one pdf file.

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?

Access Report exporting and merging to Word/PDF

Access Report exporting and merging to Word/PDF Icon
I try to Export and Merging Access Reports, some in table-format = with lines, and some with graphics. But I only can generate text documents.

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, .

Converting reports to pdf

Converting reports to pdf Icon
Im converting my reports to pdf so that I can basically have an electronic book of all my reports. However, after clicking the convert to pdf button, after about 200 convertions, it says that the amount is too large and stops converting and just finishes the 200 it was working on. How do I get over this?

Exports/Outputs Suddenly Very Slow

Exports/Outputs Suddenly Very Slow Icon
I have an Access 2010 database which has very suddenly become very slow when either exporting to excel or outputting reports. The two common places where this happens are below (this code hasn't been changed any time recently).

Example 1 - Printing labels to pdf:
DoCmd.OutputTo acOutputReport, gStrReportName, acFormatPDF, strPathAndFile
Example 2 - Exporting to excel:

Access Reports to different file format

Access Reports to different file format Icon
I need a VBA code that will export my access reports to different file format (.xls,.PDF, .doc). For now, I want to convert my report to PDF

Output multiple reports to one PDF

Output multiple reports to one PDF Icon
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?