limit print report to 2 pages

[mflower]

Anyone knows how to limit the print out to 2 pages only? As in once preview, print out 2 pages only? And not only 2 pages only but printout back to back so only 1 page with two sides printed? Help!!

 

[JoeMiller]

Checkout the Printout method in the online help, it does exactly that. Joe Miller
joe.miller@flotech.net

 

[Aivars]

Hi!
Set parameters of PrintOut command.

private sub cmdPrintOut_Click
docmd.PrintOut acPages,me.PageFrom,me.PageTo,,me.Copies
end sub

me.PageFrom >>> textbox for entering start page No
me.PageTo >>> textbox for entering end page No
me.Copies >>> textbox for entering end copies amount
on your form

Aivars

 

[mflower]

Thanks Aivars & JoeMiller!
However, my problem is still not solved. I would like the printout to be double sided on 1 sheet of paper. docmd.Printout does not specify that Or is printing out double sided not possible unless done on the printer setup?

 

[JoeMiller]

Not possible unless done in the printer setup. What I usually do in a situation like this is have a copy of the printer installed with the duplex option enabled then name it so I can use it for automated tasks like this.

HTH Joe Miller
joe.miller@flotech.net