redirecting printer and page setup

  • Thread starter Thread starter georgemar
  • Start date Start date
G

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
 
georgemar said:
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.
Click to expand...

See if the information on this page helps:

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