Automate Printing & PDF Files

[Laura]

I have a report (Rpt_NotQuoted) that I want to programming the following
tasks in a single click of a button:

1. Print Report to a local printer (not always the same one so I can't rely
on "default printer" option)
2. Save Report as a PDF file (one person uses Adobe Acrobat and other one
uses PDF995)

If anyone has some suggestions that would be wonderful.

 

[Albert D. Kallal]

I have a report (Rpt_NotQuoted) that I want to programming the following
tasks in a single click of a button:

1. Print Report to a local printer (not always the same one so I can't
rely
on "default printer" option)

You lost me with the above? If you don't set what printer the report goes
to, then it will
use the persons default printer. (is that what you want???). I mean, some
one has
to choose a printer eventually...

Anyway...

I would do the following:

dim strReportName as string
dim strPdfName as string
strReportName = "rptCustomers"
strPdfName = "c:\mypdffiles\customers.pdf"
DoCmd.OpenReport strReportName, acViewPreview
DoCmd.PrintOut acPrintAll
Call ConvertReportToPDF(strReportName, , strDocName, False, False)
DoCmd.Close acReport, strReportName

The convert Report to Pdf is a great free pdf maker from

You can find it here:

http://www.lebans.com/reporttopdf.htm

The great feature of the above is hat you don't have to install adobe, or
cutpudf, or ANY software......

 

[Laura]

Thanks for the info and sorry for being confusing on the first part.

On the PDF section, since some already have Adobe & others have PDF 995, I'm
hoping not to have to install another program/driver. Is there a way to
program the use of these two? Or maybe, a popup or selection screen asking
them to pick the pdf maker? I want to try and control as much as possible
from the programming rather than having the individual try and use the Access
pull-down menus. Thanks