Third Party Report Viewers

[Rosco]

Hi All,
I produce a number of reports from various Access applications that
need to be distributed via email across the country. Different
versions of each report to different recipients.

I have been outputting the reports to snapshot viewer, and attaching
the snap files to the emails.

The problem I have is that unless the report is in Access default page
setup, the Snapshot viewer may not hold original configuration,
depending on the printer the recipient is attached to (if any).

Worse, Snapshot has no page set up utility. The whole situation is
frustrating everyone.

My question to you all is does anybody know of a better 3rd party
Access report viewer (other than Crystal)?

Any thoughts are appreciated.
Thanks
Rosco

 

[Gary Miller]

How about converting the report to a PDF file. Check out
PDF995 for a very inexpensive PDF solution. www.pdf995.com

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[Rosco]

PDF files would be fine. I have been experimenting with PDF995. It
works well manually printing a report. I need to be able to
programiclly print to assorted paths and file names. PDF995 asks for
path an file name each time you print to it. I need to be able to run
similar code to below in a loop:

DoCmd.OutputTo acOutputReport, strReportName, strOutputFormat, strPath
& "\" & strFileName

Unless I am missing something, PDF995 is not capable of doing this.

Does anybody know of an addin that will?

Thanks for the help
Rosco

 

[Gary Miller]

Check out the PDF Pro Mail Library from ACG Soft...
http://ourworld.compuserve.com/homepages/attac-cg/

I use it on a couple of projects and it is working very
well.
--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[Rosco]

Check out the PDF Pro Mail Library from ACG Soft...
http://ourworld.compuserve.com/homepages/attac-cg/

I use it on a couple of projects and it is working very
well.

Thanks Gary,
Web site looks interesting. I will pass this to my IS dept along with
the samples of PDF995. Looks like it might do the job.

Rosco

 

[Douglas J. Steele]

As competition to PDF995, you might also look at CutePDF
http://www.acrosoftware.com/products/cutepdf/Printer.asp

Completely free: no watermarks, no nag screens, no annoying popup
advertisements, no time limits etc.

Not that I want to take anything away from Steve Arbaugh and his PDF Pro
Mail Library!

 

[Rosco]

Thanks Doug. I'll give it a try.

 

[Rosco]

Thanks Doug. I'll give it a try.

Thanks to all.

The combination of PDF995, and ACG's PDFMail does exactly what I want.

One additional question. Could someone show me an example of code to
set the default printer on a PC from within Access? I would imagine it
is an API call.

Thanks again
Rosco

 

[Rosco]

Thanks Doug. I'll give it a try.

Thanks to all.

The combination of PDF995, and ACG's PDFMail does exactly what I want.

One additional question. Could someone show me an example of code to
set the default printer on a PC from within Access? I would imagine it
is an API call.

Thanks again
Rosco

 

[Douglas J. Steele]

There's code at http://www.mvps.org/access/reports/rpt0009.htm

You can also check out what Albert Kallal has at
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

 

[Rosco]

Doug,
Albert's solution is just what I needed.
Thanks again for the help
Rosco