Output Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any code to output a pdf report from Access to a server file? I
finally figured out how to change the printer using CutePdf to print report.
The problem is that it prompts each time as to where to save the file. I
need it to print and save to a designated folder on the server, so that I
can select several reports and save them to one location and then select all
and email them. As I have it set up now, I'm using check boxes and macros to
output to this folder. It outputs as snapshot and rtf formats. The problem
is that receipents don't have Snapshot and either don't want to or can't (not
permissable) download Snapshot viewer and some reports have images that are
not being picked up in rtf. If there were some way to print it and then save
automatically to this folder, it would be most helpful and more user friendly.
Thanks in advance for any help available.
PHisaw
 
PHisaw:

The freeware Cute PDF driver is not a programmable to set its output file or
folder, you'll always get the prompt with that driver. They offer (for a
fee) a driver that you can program those attributes on.

If you are looking for options, our PDF and Mail Library for Access supports
a lot of PDF drivers allowing you to both create the PDF and then attach as
many as desired to an e-mail to send them out. Many of the drivers
supported are very cheap. Code can be as simple as:

Dim PDFObj As New PDFClassWith PDFObj
.ReportName = "My Report"
.OutputFile = "c:\copy\test.pdf"
.PrintImage
End With

Set PDFObj = Nothing You can check it out in the Developer Tools secion of
our web.-- Steve ArbaughACG
Softhttp://ourworld.compuserve.com/homepages/attac-cg
 
Thank you for the info - I'll check your website. I may just have to make do
with it as is.
 
Back
Top