Output Report

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
 
S

SA

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
 
G

Guest

Thank you for the info - I'll check your website. I may just have to make do
with it as is.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top