OutputTo Then try to run the code; it should work fine. Wednesday, February 20, 4: For example something like: It is not obvious how to export a dynamically filtered report using this method. Taking all this into account, our repport to export a filtered report to PDF could look like this: This Access tutorial explains how to use DoCmd. I think that is the only way. To work around this issue, you can export as XLS format instead. Click here for instructions on how to enable JavaScript in your browser.

Author:Gugal Duhn
Language:English (Spanish)
Genre:Health and Food
Published (Last):28 February 2008
PDF File Size:20.71 Mb
ePub File Size:15.41 Mb
Price:Free* [*Free Regsitration Required]

Otherwise, if you want to DIY, you can read the contents below. Add a command button inside your report This article assumes that you already have an Access Report created. Open it in design view and add a button in the Report header as shown below. To do this: While in design view, select the button. Add code for the command button To add the code, you have to first add an On Click event to the button. With the command button selected, go again to the Property Sheet.

Click on the Event tab. This will open the VBA Editor. Now, copy the code below. Please update code. If it does, a prompt will appear asking if you would like to replace it with a new one.

If you select yes, the report will continue with the export process. If not, the file will not be converted to PDF. If you entered a folder path that does not exist, a prompt will appear to ask you to update the folder path specified in the code. Export process will not continue until this is corrected.

Once the report has been successfully exported, a prompt will appear indicating where the PDF file was saved. Unable to Open Access Database The most terrifying thing that can happen to any Access user is to wake up one day and realize that the database could no longer be opened.

It has been corrupted. DataNumen Inc. Your database can still be brought back to life. For more information visit www.


Export Access Object to Excel ,PDF, RTF , etc. using DoCmd.OutputTo



How to Export Your Access Report to a PDF File via VBA



Subscribe to RSS


Related Articles