Solved

Output Report to PDF for Preview

Posted on 2008-10-20
5
939 Views
Last Modified: 2013-11-28
I am using the following code within a Button on a report
    'DoCmd.OutputTo acOutputReport, , "PDF Format (*.pdf)", Me.Report.Name & " " & Format(Now(), "ddmmyyyy-hhnnss")
OR
    DoCmd.OutputTo acOutputReport, , acFormatPDF

These work fine and save the file as predetermined name or specified name but the file is saved and not displayed in Adove Reader / Writer

If I do File - Save As PDF or XPS the file is previewed, I can then comment / edit with Writer and email to a recipient which is what I want to do

I know I can email the file via SendObject As etc... But I like to comment on the PDF first, underline points bold etc.....

Anyone any Ideas - Thanks - Perhaps a way to do the File - Save As PDF / XPS would suffice
0
Comment
Question by:Wizard_IT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 22

Accepted Solution

by:
Kelvin Sparks earned 500 total points
ID: 22756148
DoCmd.OutputTo acOutputReport, , acFormatPDF, ,True
should preview it when complete

Kelvin
0
 

Author Comment

by:Wizard_IT
ID: 22756169
It doesn't - I would expect it to
Access 2007 Latest SP - No Runtime - Access PDF / XPS Addins installed and working OK
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 22756197
?? I'll have to check my 2007 setup, currently running PC in 2003 mode, so can't go there at present.
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 22756282
OK

I've checked this on a 2007 machine and it did open the pdf in Acrobat Standard (not Reader).

Can you check the file associations for your pc to see what program is associated with pdf's.

In my case it is the Acrobat Standard - but that is for another reason on that machine.

I'm running Access 2007 SP1 over Win XP, Access PDF / XPS Addins installed

I did notice a slight delay in the file opening after the pdf write.

Kelvin
0
 

Author Comment

by:Wizard_IT
ID: 22756630
Great

Works fine - I was being a plonker

I tied it earlier hardcoding the filename but forgetting the extension .pdf - assumed it would append the PDF - It was simply that

Thanks and enjoy the points
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question