Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 117
  • 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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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