redirecting printer and page setup

[georgemar]

1. I would like to be able to control to which available
printer a report is sent, using VBA. I have a printer on
LPT1 and another one on USB. DoCmd.OpenReport does not
give me an option to redirect the printer.

2. I use the default print command from Microsoft in my
toolbar which allows users to print from a form or a
report straight to the printer. I need to be able to
change the pagesetup to landscape when printing from a
form to prevent the print to go over two pages.

Thanks for your help.

george

 

[Dirk Goldgar]

1. I would like to be able to control to which available
printer a report is sent, using VBA. I have a printer on
LPT1 and another one on USB. DoCmd.OpenReport does not
give me an option to redirect the printer.

2. I use the default print command from Microsoft in my
toolbar which allows users to print from a form or a
report straight to the printer. I need to be able to
change the pagesetup to landscape when printing from a
form to prevent the print to go over two pages.

See if the information on this page helps:

http://www.mvps.org/access/reports/rpt0009.htm