Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 26th, 2006, 04:37 PM
Registered User
 
Join Date: Jun 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Printing Issue

Hi,
   I have a print document of 33 pages. I want to print some of the pages in LandScape and some in portrait. While writing data to the print document i am setting ev.Landscape = True for the pages that are required to be printed in Landscape. And for the next page the ev.Landscape = False.

But here the issue the pages are printed to the settings of the lastpage. i.e if the LastPage ev.landscape = False, then all the pages are printed in portrait. If i set ev.Landscape = True for the last page all the pages are printed in Landscape.

How can i work around this issue?

 
Old June 26th, 2006, 04:42 PM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

I have seen the same thing. It looks like the Landscape setting applys to the whole document, so if you set it to the last page, every page will be set to that.

Would it be an option to print 33 individual pages? That way you can set the orientation for each as it is printed.

Just a thought,

Mike

Mike
EchoVue.com
 
Old June 26th, 2006, 04:53 PM
Registered User
 
Join Date: Jun 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Mike,
        I got your idea.And i also tried that way also.I tried to add 2 different handlers one to print in LandScape and another to print in the Portrait.But that doesn't seems to work.

Thank you.






Similar Threads
Thread Thread Starter Forum Replies Last Post
printing dhoward Crystal Reports 0 August 22nd, 2007 11:41 AM
capturing printing settings when printing reports nikolaosk Access VBA 0 February 8th, 2005 04:14 AM
Printing Issue Warbird BOOK: Professional Crystal Reports for VS.NET 0 August 27th, 2004 12:47 PM
printing issue Warbird Crystal Reports 0 August 27th, 2004 09:20 AM
Printing in C# bhanf C# 0 February 12th, 2004 01:57 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.