473,625 Members | 2,770 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

page orientation and letterhead

This is easy to do in word but is it possible in access?

I want the first page to print on company letterhead and other pages
to print on regular paper. Some of the pages I want landscape, others
I want to remain portrait.

The printer properties only allow me to set at design time. Stuff like
this doesn't work:

Private Sub Report_Page()
Select Case Me.Page
Case 1
Me.Printer.Orie ntation = acPRORLandscape
Me.Printer.Pape rBin = 1
Case 2
Me.Printer.Orie ntation = acPRORPortrait
Me.Printer.Pape rBin = 2
End Select
End Sub
---------------

Any way to allow this to be set at runtime? This is a huge mailing and
hand collation is not an option.

Maybe there's a web page to show me how to use word to do this?

One of the problems is that there are lists of items that must be
printed in the report - a job for the 'subreport'. It's not just a
simple merge.
Christian

Apr 9 '07 #1
1 3324
ch************@ yahoo.com wrote:
This is easy to do in word but is it possible in access?

I want the first page to print on company letterhead and other pages
to print on regular paper. Some of the pages I want landscape, others
I want to remain portrait.

The printer properties only allow me to set at design time. Stuff like
this doesn't work:

Private Sub Report_Page()
Select Case Me.Page
Case 1
Me.Printer.Orie ntation = acPRORLandscape
Me.Printer.Pape rBin = 1
Case 2
Me.Printer.Orie ntation = acPRORPortrait
Me.Printer.Pape rBin = 2
End Select
End Sub
---------------

Any way to allow this to be set at runtime? This is a huge mailing and
hand collation is not an option.

Maybe there's a web page to show me how to use word to do this?

One of the problems is that there are lists of items that must be
printed in the report - a job for the 'subreport'. It's not just a
simple merge.
Christian
You want to send the 1st page to 1 printer and the rest of the report to
another printer. On the second printer print some pages in portrait,
others in landscape.

Access has a real nice report writer. It is not a word processor.

Perhaps Crystal Reports has such capabalities. You could send them a
query at their web site.

If it can be done in Word you might want to ask in a Word newsgroup
(there's quite a few) how you can write the VBA code to accomplish your
request.



Apr 10 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
8360
by: Yaron Cohen | last post by:
Hi, I would like to ask for your help. I am using IE5.5. I have a wide page with horizontal scroll bar. The problem is that I get only 1 page when printing it using "file->print" or "window.print".
6
19611
by: Biguana | last post by:
Hi, Just wondering if anyone can help here. We have a site where most of the site opens in a window with no toolbars or menubar: window.open('mypage.aspx','self','toolbar=0, menubar=0, etc, etc) This is because it's a data driven site where space is at a premium and we'd rather discourage use of back, stop and refresh. The problem arises because some "view data" pages are designed to be printed and have an onclick="window.print();"...
0
1881
by: Niyazi | last post by:
Hi all, This my aspx page first line of code. <%@ Page CodeBehind="index.aspx.vb" Language="vb" AutoEventWireup="false" Inherits="TB.index" %> Than inside head tag I have following script(s) --------------------------------------------------------------------------------------------------------------------- <script language="JavaScript"> //Disable Mouse Right Click Button
2
4010
by: tom | last post by:
Hi All, Using VBA, I would like to be able to examine a report in design mode and determine its page orientation (landscape or portrait). I do not want to change the orientation. I'm fine with getting to the point of having an Access.Report variable pointing to the report... just don't know how to get it to tell me its page setup information.
9
9903
by: Sean McKaharay | last post by:
Since no one can answer the following question: I have a issue. I need to create a command line application/or windows application that will take 2 parameters and will print to the default printer without any popups. the first parameter is the html file name(location) second is a switch that will tell the app to print in landscape or protrait. Basicly I when I type in (for example) PrintApp "c:\printthis.html" \L it should print the file...
2
7258
by: Yelena Kaplun | last post by:
Hi, I'm trying to customize print settings while streaming HTML content into Excel. I'm using ASP.NET 1.1 and Excel 2003. While some printer settings like Margins are working correctly, I cannot change the Page Orientation to Landscape: mso-page-orientation:landscape;. I tried to produce the Excel Page, save it as HTML, open in text editor and then copy and paste Excel generated settings. But it did not help. If anybody resolved this...
0
317
by: Fred Nelson | last post by:
Hi: I'm writing a vb.net program that will need to create print documents that print on envelopes, letterhead, and second sheets (plain paper). I need to be able to control the form from my program. On the HP 4 laser printer - its quite easy: The papersources available are "upper" "lower" and "envelope" so it seems like I'm all set there. I also need to print on an HP Laserjet 1000 and my only papersource is
0
1264
by: matvin | last post by:
When generating .NET Crystal Reports with Page Orientation as Landscape, a Blank page gets generated along with the report. But this is not the case when the page orientation is set with Portrait.Any help on this?
0
1518
by: brett | last post by:
Hi, I need to build a pdf report by using Crystal report which including several subreport. The problem is that the primary page orientation is portrait and some subreports' orientation is landscape. I cannot find a way to set subreports' orientation in Crystal report. Is there an solution for this problem? Thanks in advance!
0
8692
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8497
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7182
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5570
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4089
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4192
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2621
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1802
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1499
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.