Solved

convert report to pdf

Posted on 2015-02-01
4
99 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
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…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

776 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