[AccessD] Print to a specific printer programatically

Susan,

If you're always going to a specific printer, you can set a specific
printer in the page setup.

I did this by accident for some reports I was creating and users
couldn't figure out why their reports never went to their default
printer (they went to MY default printer).

In A2K03, anyway, in design mode for the report, go to File/Page Setup,
then the Page tab. Near the bottom, is an option for Default or Specific
printer.

HTH,

Steve 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Klos, Susan
Sent: Friday, October 28, 2005 11:08 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Print to a specific printer programatically

I would like to print reports based on a parameter query to PDF.
Manually I open the report, type in the parameter (district number) and
then go to file, print, and select the PDF print driver.  Because I am
sending reports to approximately 73 districts, in the past I set my
default printer to the PDF printer and then just had to go to file,
print.  I would like to be able to streamline this further using code.
Any ideas?  TIA.

 

Susan Klos

Senior Database Analyst

Evaluation and Reporting

Florida Department of Education

850-245-0708 

sc 205-0708

 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com