Solved

Output Report to PDF for Preview

Posted on 2008-10-20
5
932 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
  • 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

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
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

860 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