[AccessD] Is it possible...

Hi Bruce and William

It may be possible, but remember that you may encounter two problems: first, changing printer objects may fail in restricted (corporate) environments, and even if you succeed you may end up with two or more print jobs which - again in corporate environments - may get mixed with other print jobs.

However, the physical printer is perfectly capable of switching side orientation between pages - in PCL it is one single command - and that command is issued routinely by most applications before printing a page. That's why I assume it would be realistic to locate this command in a saved print file, change it, and then print the file - which would result in one print job. I've never had the need, though, for such fancy printing, so it is no more than an idea.

/gustav

>>> wdhindman at dejpolsystems.com 09-04-2007 05:07 >>>
Bruce

...never say never ...my code library is loaded with things written by 
people here that I would have sworn were impossible in Access ...most of 
which I manage to use successfully without ever groking what they are going 
on about :)

...though I've not tried to switch orientation in the middle of a report 
myself, I know you can pause a report at a specific page, change the printer 
tray, print a page from that tray, and then pause and change back using the 
printdev mode properties as in mskb 200546 ...so long as the printer driver 
supports those properties ...and since page orientation is also a property 
of printdev mode, it would seem worth the time to try changing it at the 
same time you change printer trays using virtually the same code.

...if not, then you might have to look at creating separate reports and 
numbering the pages of each correctly.

...or if you want to walk on the wild side, use Lebans rotate text code to 
brute force design a portrait formatted subreport to look like a landscape 
format.

...if you do get it to work, let us in on the secret, eh.

William Hindman

----- Original Message ----- 
From: "Bruce Bruen" <bbruen at unwired.com.au>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Sunday, April 08, 2007 5:36 AM
Subject: Re: [AccessD] Is it possible...


> On Sunday 08 April 2007 03:20, Gustav Brock wrote:
>> Hi Bruce
>>
>> You could output the report twice to postscript files, then use Ghostscript
>> to select and mix the pages of your choice into one new postscript or PDF
>> file or directly to a Postscript printer.
>>
>> /gustav
>
> YUK! (No Offense Intended) I take it that its not (hacklessly) possible then.
>
> -- 
> regards
>
> Bruce