Solved

convert report to pdf

Posted on 2015-02-01
4
102 Views
Last Modified: 2015-02-01
Hi EE
I have the following line of code
DoCmd.OutputTo acOutputReport, "rptFaultReport", acformatpdf, Tlocation, False

Tlocation = \\klo-fs\common\Hoist\Reports\  & “FaultReport”

Problem is I get the message report saved but when I look in the folder report it looks empty but If I open the properties dialogue box it tells me there is one file. I have no idea what goes on. Any help appreciated

chestera
0
Comment
Question by:chestera
  • 3
4 Comments
 
LVL 24

Accepted Solution

by:
chaau earned 500 total points
ID: 40583260
Use the extension. You have saved it as FaultReport, without .pdf at the end. Your Windows Explorer is configured to not show it. Change the line to this:
Tlocation = \\klo-fs\common\Hoist\Reports\  & “FaultReport.pdf”

Open in new window

0
 

Author Comment

by:chestera
ID: 40583328
chaau
added .pdf still not showing up in the \\klo-fs\ etc so tried into a different location on the PC and it worked so looks like I have a server problem

Alan
0
 

Author Comment

by:chestera
ID: 40583363
chaau

Thank you for your help I had two problems missing .pdf and a corruption in the Report folder.
All working fine now

Alan
0
 

Author Closing Comment

by:chestera
ID: 40583365
:)
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

821 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