473,427 Members | 1,809 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,427 software developers and data experts.

Data Access Page Orientation

3
Hi Guys,

This should be quite simple but my brains are being seriously racked.

I have created a data access page as the report I want to generate is 4 pages (too long for a regular report). Access page looks good and works well with my query. The problem is, it will only print off in landscape regardless of how many times I change it to portrait. I have edited it both in Access and Frontpage by editing the actual html document. I have shrinked the width of the text to make it well within portrait page size.

Using Access 2002 on XP which is on a regular network.

Any help would be much appreciated. It an't be that difficult can it?

Cheers
Sep 3 '07 #1
1 1300
ADezii
8,834 Expert 8TB
Hi Guys,

This should be quite simple but my brains are being seriously racked.

I have created a data access page as the report I want to generate is 4 pages (too long for a regular report). Access page looks good and works well with my query. The problem is, it will only print off in landscape regardless of how many times I change it to portrait. I have edited it both in Access and Frontpage by editing the actual html document. I have shrinked the width of the text to make it well within portrait page size.

Using Access 2002 on XP which is on a regular network.

Any help would be much appreciated. It an't be that difficult can it?

Cheers
Try executing the following line of code before Printing the Page:
Expand|Select|Wrap|Line Numbers
  1. Application.Printer.Orientation = acPRORPortrait
Sep 9 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Santah | last post by:
hi I'm new to C++ and I'm currently working on Visual C++ 6.0 I'm trying to open a text file, and read some data from it part of the text file looks like this: --------
3
by: sridevi | last post by:
Hello How to export data from ms-access database to excel worksheet using ASP. mainly i need to export data to multiple worksheets. it is very urgent to us. i have a sample code which works...
5
by: middletree | last post by:
I did a search in this forum, as well as at www.asp.faq.com, and MSDN, and would like to know how to use ASP to build a report and create an .xls file as a result. I've seen lots of tutorials...
9
by: the_grove_man | last post by:
I guess my question can go in two directions. I create applications that run multiple queries against a database. Generally speaking in the past I have used a Data Control (calling it dat1)...
9
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...
2
by: onkeypress | last post by:
Hi huys, Need to solve this problem. I need to print an Access Report (3 pages). For the first two pages (pages 1 and 2) they are in portrait orientation. For the last (page 3) page, it is in...
0
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...
0
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...
2
by: MSCTC | last post by:
Hi Guys, This should be quite simple but my brains are being seriously racked. I have created a data access page as the report I want to generate is 4 pages (too long for a regular report). Access...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
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,...
0
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...
0
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,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
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...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

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.