dbTalk Databases Forums  

Print One Report on two Printer Trays

comp.databases.ms-access comp.databases.ms-access


Discuss Print One Report on two Printer Trays in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Vincent Oakley
 
Posts: n/a

Default Print One Report on two Printer Trays - 04-28-2010 , 09:26 PM






Apologies to all you experts for the very simple question.

My HP Laserjet has two trays. Plain paper in tray 1. Quality paper
in tray 2 (which goes to client via post)

Clicking a button on my Form runs elementary VBA code.

Docmd.OpenReport "LetterOnTray1" , acViewNormal ' Obviously prints on
Tray 1
Docmd.OpenReport "LetterOnTray2" , acViewNormal ' Obviously prints on
Tray 2

The reports are identical save that on the File Menu, Page Setup is
used to select Tray 1 for the first and Tray 2 for the second. I have
a lot of reports which are printed in this way. They are often
altered and it is becoming cumbersome to make the identical changes on
both versions of the same report.

I seek a method of eliminating use of the second report and printing
the single report first on Tray 1 then on Tray 2 with a single click
on my form. I thought something like Docmd.OpenReport "Letter",
acViewNormal, With DefaultSource = &"tray 1" would work but it does
not.

I have reviewed the MS examples for PrtDevMode which seem bit complex
for me as I only wish to change the DefaultSource. Is there a simple
solution to this problem.

Reply With Quote
  #2  
Old   
Salad
 
Posts: n/a

Default Re: Print One Report on two Printer Trays - 04-28-2010 , 10:06 PM






Vincent Oakley wrote:

Quote:
Apologies to all you experts for the very simple question.

My HP Laserjet has two trays. Plain paper in tray 1. Quality paper
in tray 2 (which goes to client via post)

Clicking a button on my Form runs elementary VBA code.

Docmd.OpenReport "LetterOnTray1" , acViewNormal ' Obviously prints on
Tray 1
Docmd.OpenReport "LetterOnTray2" , acViewNormal ' Obviously prints on
Tray 2

The reports are identical save that on the File Menu, Page Setup is
used to select Tray 1 for the first and Tray 2 for the second. I have
a lot of reports which are printed in this way. They are often
altered and it is becoming cumbersome to make the identical changes on
both versions of the same report.

I seek a method of eliminating use of the second report and printing
the single report first on Tray 1 then on Tray 2 with a single click
on my form. I thought something like Docmd.OpenReport "Letter",
acViewNormal, With DefaultSource = &"tray 1" would work but it does
not.

I have reviewed the MS examples for PrtDevMode which seem bit complex
for me as I only wish to change the DefaultSource. Is there a simple
solution to this problem.
What version of Access are you using. For A2002+, here's a link
http://support.microsoft.com/kb/284286

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.