Print every other page to a different bin

[Stuart Green]

I have a large report of a couple of hundred pages. What I want is the first page to print on headed paper, next page on plain, next page on headed etc. etc. As an old DataEase hand I could do this by embedding a print command in the actual document layout that the printer would recognise as a print string rather than something that needed printing and would change paper tray for the next page. Is this possible in Access please?

 

[smercer]

A possible way is to alternate the pages so that you have a stack of normal with a headed page between each normal page.

does this help?

I need to have my printer working to have a look, so I can not help you there.

 

[Stuart Green]

A possible way is to alternate the pages so that you have a stack of normal with a headed page between each normal page.

does this help?

I need to have my printer working to have a look, so I can not help you there.

Nice idea but unfortunately the report is 1800 pages long

 

[Rich]

The Neatcd sample db from MS has an example function for two tray printing, with a little adaption and the Mod function it should work

 

[Stuart Green]

The Neatcd sample db from MS has an example function for two tray printing, with a little adaption and the Mod function it should work

Hi Rich, where would I get this from please, I only seem to have the northwind one

 

[Rich]

It's in the MS Knowledge base, I don't have a link, but Pat Hartman posted a link to them which she pointed to again here recently, if you search here you might find the links.

Might those links be a Sticky here? Hint! Hint!