print 2 reports back to back 1

[nickjar2]

Is there any easy way to run 2 different reports, but have them print on the same piece of paper, but on different sides. I have a duplex printer, and can do this with one report, but I am struggling with 2 reports.

Hopefully someone can help, 'cause i am beating my head against a brick wall now, and time is running out! Hope this is ok. If not, just let me know.

Nick (Everton Rool OK!)

 

[mdthornton]

If this is just 2 1 page reports try putting your second report as a subreport of the first in the report footer section and set the force new page property to "before section". If you already have something in your report footer you might have to get a little more creative but something along these lines should work. Best Regards,
Mike

 

[nickjar2]

Mike,

I may be wrong, but I think ur a star!

Cheers m8. One last question though, is it possible (via code) to manipulate your printer settings, so it will 'Print on both sides'. I am using a printer with Duplex capabilties, and i HAVE to get these 2 reports on either side of the paper, but preferably without user interaction. The settings for 'print both sides' reverts back to unchecked, without saving the new setting.

Hope this is ok. If not, just let me know.

Nick (Everton Rool OK!)

 

[mdthornton]

Nick

I'll try and get back to you later on this (I'm leaving the office now for a few hours) but you can manipulate printer settings using prtdevmode property. There's a duplex setting in there. Have a look in the Access help (search for prtdevmode). I've never had cause to use this so I don't know how involved it may be.

Mike

ps Up the Boro! Best Regards,
Mike