• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 121
  • Last Modified:

convert report to pdf

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
chestera
Asked:
chestera
  • 3
1 Solution
 
chaauCommented:
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
 
chesteraAuthor Commented:
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
 
chesteraAuthor Commented:
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
 
chesteraAuthor Commented:
:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now