exporting reports as pdf from vba?

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:

Related Topics

Exporting Reports Question
-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
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
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
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?
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
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
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
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:


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


Access Reports to different file format
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


Using one report and exporting to individual PDF files
I am not that familiar with Access; however, I have managed to set up my tables, queries and reports.

The report contains expenditures which are grouped by Approver.

What I need to do is create multiple PDF files (could be some other format) that can be emailed to each approver.

I have seen this question on multiple forums, but no answers.


Out of memory generating reports in batch
I have a memory problem generating reports in Access.

I have a functionnality which it is going to be run in daily basis by the user to generate the reports for records created on that day automatically and export them to pdf files.

This works fine but on a day can be until 250 reports to generate and the computing it is going out of memory.

I've been looking for the way to optimize this and what I found it is that when I closed the report after exporting to pdf the memory it is not freed and that's why after generating x number or records there is not memory anymore.

I don't know why report it is not freeing memory when I close it or where I can found information of how Access manage memory. Does anybody can direct me where to look for the right information to solve my problem


Export to PDF Document Format
Contrasting to Access 2007, in which you need to install add-ins to export database. Access 2010 offers option of exporting database in PDF (Portable Document Format) and XPS (XML paper Specification) formats. Now with Access 2010, you can export datasheet, Forms and Reports to a .pdf or .xps file, it enables you to spread information in an easy-to -distribute form that contains all formatting characteristics.


Export with date
I have created some daily reports ( 20 different reports) of my team in access and exporting that data to excel with Macros. While exporting, is there any way I can export with date in the file name. Presently, I am adding the date in the file name manually after exporting. Its a time consuming process for me


Exporting to PDF
I am using MS Access 2003. Is there a way to have an acces report automatically export to a pdf?


Do I Really Need to Use 54 Macros to Sent Separate report PDFs ?
am pretty new at this and don't have any VBA training but I am develoing a 2007 MS Access database for folks at work and could use a sanity check on what I am doing.

The dB will produce many reports based on different division and branch workload. At present to send a report as a PDF file I create a macro to Send Object from MS Access ribbon. I choose Report, select report name, choose PDF format and add description for the subject line of the mail window. The macro works fine and produces the PDF file of each record as I like. In doing so I'm up to over 50 macros that send out reports as PDF files.

Question: I assume their is a much easier way. What am I doing wrong ?


Displaying PDF files using VBA in access 2003
with code to open externally saved PDF files from a button on an access formn using VBA.

My pdfs are located in a folder on the c: drive

eg. c:/jobpacks/a/alfreton/yyy.pdf
/b/barnsley/xxx.pdf etc

All I want to do is open them and display them on the screen, I would then like to email them as an attachment


Automatically name a report when exporting to PDF
I have a form with a command button that opens my report in print preview mode in Access 2007. When I click the Export to PDF/XPS button, the default file name is the name of the actual report within Access. I've used VBA to change the report caption to match a field on my form called PROGRAM. However, this does not transfer over when I want to save my report to pdf.

How can I make it so that when I click export to pdf/xps, the default file name is named after a text box called PROGRAM?


Multiple Reports to Single PDF
I am working on a database for my company in Access right now and one of the Forms that I have created can generate a single PDF file based on a report. I would rather have this done another way though.

I want a user to be able to select multiple checkboxes on the form, which will determine what reports the user needs. The next thing that it will need to do is take all these reports and generate a single PDF containing each one of these selected checkboxes.


Exporting reports
Is there any way of exporting all reports such that they effectively can be made into an electronic bo