Create Second Page in Access2003 with Different Orientation (Portr

How do I create a second page in an Access2003 Report where the second page 
has a different orientation.  The first page is in landscape and the second 
needs to be in portrait so that the mailing address is viewable for Windows 
envelopes.

We tried to add a second page but it messed up the calculations and 
orientation of the from the first page.

Any suggestions would be appreciated?  

Thank you,

Mirsa
With WindowsXP
0
Utf
4/30/2007 7:52:06 PM
access.reports 4434 articles. 0 followers. Follow

0 Replies
1243 Views

Similar Articles

[PageSpeed] 27

Reply:

Similar Artilces:

Pivot table, calculating % difference of subtotal rows
This is what I need to do: I have rows of data in a pivot table that have subtotals associated with them (automatically generated via the pivot table). I need to to take the subtotals for 2009 and 2010 and calculate the % difference. Here's a screenshot of what I'm talking about: http://home.comcast.net/~wilsoch/PercentDiff.jpg Is this even possible or am I going to have to do this manually? Hi I have'nt seen the screenshot as am at work , go to Pivot Table>Formulas>Calculated Field wilsoch@comcast.net wrote: >This is what I need to do: I have rows of ...

Identical Name on multiple workbook pages
As a hardened Excel/VBA nut, I'm probably going to be really embarrased when I get the answer to this, but here goes... I have a workbook containing a worksheet that records weekly data. I have a named range ("Data") which I select then clear, via GoTo. Each week, I copy the latest week's worksheet and create a new worksheet for the new week. And each week, I select the range "Data" and clear it in the most recently created worksheet. the thing is, I always thought that Range names were unique across a workbook, and that you couldn't have the same Range N...

how do Ii remove the grey page numbers in a work sheet
how do Ii remove the grey page numbers in a work sheet Try going to the View menu and unchecking Page Break Preview On Wed, 2 Feb 2005 11:01:08 -0800, "parker1230" <parker1230@discussions.microsoft.com> wrote: >how do Ii remove the grey page numbers in a work sheet You may be in page break preview mode. Go to "View" and select "normal" Regards Bill K "parker1230" <parker1230@discussions.microsoft.com> wrote in message news:5A65FC73-CAA0-428D-8ECD-0C2A2E15B799@microsoft.com... > how do Ii remove the grey page numbers in a work she...

How to change background color of a window that has been created.
I need to change the background of a window that has been created, can you help? Hello Jerry, > I need to change the background of a window that has been created, can > you help? > Answer depends upon the type of window. Typically you can do this in OnEraseBkgnd. Certain controls respond to WM_CTLCOLOR and yet some other, like CButton, need to be owner drawn to change the color. If you have a generic CWnd, you can always specify the brush in the window class; so no special painting is needed. This is good when you know that the background will have one color all the time. -...

Creating a Report using Tables (that have no relationships)
Im looking to create an invoice report that uses data from three different tables that are created dynamically by a query. The data for these will change but I would like to simply pull the data from these tables to create a report. The tables have the following information: 1. Company Info (name, address) 2. Customer Info (address, name, etc) 3. Customer Order (products, price, other info) 4. Invoice Info (ID, GST #, etc) I realize I could have created a table with relationships but the data above is dynamic as there are 4 different companies and based upon user inp...

Adding Values From Different Tabs
Is there a way to add values from different tabs on the same spreadsheet? For example A2 from tab 1 and A2 from tab 2 -- Flipkid2 ------------------------------------------------------------------------ Flipkid2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17984 View this thread: http://www.excelforum.com/showthread.php?threadid=398184 Assuming the name on Tab 1 is Sheet1 and Tab 2 is Sheet2, use thi formula: =Sheet1!A2+Sheet2!A2 note the name of the sheet is followed by "!" to indicate it is a shee name. HTH Bruc -- swatsp0 ------------...

Use Outlook Client when domain user name different with email acco
Hello, I have a question about using Outlook Client. If the domain user login name is different with email account which belong to a same person, is it possible to install / login with the Outlook client? e.g domain user : degdom\apple email account: applewatson@deg.com One of my client is facing in this situation. I just want to have some preparation before install Outlook Client for him. Thanks for any help! Hi Huimc, It shouldn't be a problem if the AD user is the same used to start Outlook and connect to CRM. You may want to check the email adress in CRM if the ema...

creating a recurring reminder email message
I want to create a reminder message that gets emailed to a distribution list on the same date every month. How can we do that? ...

Margin Trouble with Custom Page Size
When I try to print in Publisher using a custom page size, printer or Publisher adds approx 1.5" to the top of my page margin, no matter what I do. Checked the printer settings in WordPad, all looks OK. Issue does not occur when printing on 8.5X11 page, nor does it occur in MS Word. I don't have any extra margin set in Master Page...have tried everything I can think of. Under deadline to print invitations and getting desperate...help! Thanks. How are you setting up your printer? Are you saving the custom setting? Are you setting up your printer first? What model is your pr...

connecting to data access page with filter criteria
I have an access database that I connect to from a GIS application (ArcView) using VBscript. I need to port my GIS project to the free viewer (ArcReader) which does not support VBscript but does support hyperlinking to a URL based on a value supplied by an underlying record. In my current project I can send filter critera to open a particular database, form and record. Would it be possible to do the same using data access pages or would I need to create a separate page for each record I want linked? ...

Excel page format changes
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hello, <br><br>My client creates spreadsheets for her boss. She pushes the boundaries to get things to fit on the screen. <br> Uses A4, margins at 1.5cms and scales to 90%. <br><br>When her boss receives it by email the margins go to 2.5cms, scales to 100%. They have the same versions 12.2.4 and Leopard. They are just about to be upgraded to Snow Leopard. Any idea why this could be happening? Thanks. ...

Problem creating full text index
I seem to be unable to create a full text index of either my public or private store. When I try to creat the index I get the error; The directory name is invalid. Facility: MSSearch.Admin.1 ID no: 8007010b Exchange system Manager This seems to be happening for both the public and private stores. The directory does exist. I have looked over the permissions and tried to compare to known working servers and I haven't moticed any obvious differences. Any ideas? Did you follow this article: http://support.microsoft.com/kb/822932/en-us Nue "Jonathan Huber" <JonathanHu...

Cell identity when printing comments on separate page
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel When printing comments at end of page, it identifies the cell by letters and numbers. (i.e. Cell: AA33) Afterward the comment is shown for that cell. <br><br>Question: Instead of the cell identity being shown this way, is it possible ithe cell can also be identified by its X axis header for that column with the y access header for that Row. <br><br>Thank for your assistance. <br><br>Carl Sorry Carl, but I'm not clear on what you're asking for... In 'MySpeak' ...

Money 2005 Bug: Portfolio toolbar button loads blank page titled Portfolio Manager
Problem Description: Clicking on the Portfolio toolbar button loads a blank page that's titled Portfolio Manager. That's it! I can't see any of my open positions, etc... using this toolbar button. Frequency of problem: Always Happens Operating system / version: Microsoft Windows XP Professional - 5.1.2600 Computer manufacturer and model: Dell Computer Corporation, Dimension 8200 Processor model and speed: I586IV, 1994 MHz Memory (RAM): 523.276 MB The only input I can offer is that I have the same problem on one computer, but it works fine on the other. I converted from 2004 Delu...

How do I create a spread sheet for tracking batting statistics?
Trying to keep a running log of batting stats for the season. Can anyone help? http://www.baseball-almanac.com/bstatmen.shtml "Robert" wrote: > Trying to keep a running log of batting stats for the season. Can anyone help? ...

Install 3.0 Failed
I am in the process of installing 3.0 on a server. All of the inital checks are fine. I proceed to install and it fails with an error "Action Microsoft.Crm.Setup.Server.CreateSetupUserAction failed HRESULT 0x80040237" I searched the Knowledge Base and found KB 941498. I did what it said but got the following error for msxml2.dll - LoadLibrary("msxml2.dll") failed. The specified module could not be found. How do I go about getting XML 2 (the parser I'm guessing) when it hasn't be supported in years? Is there something else I can do? I am installing 3.0...

Running macros for different cells at the same time
Hi all, Is it possible to run different macros on different cells at the sam time? If so how do I go about setting it up? Cheers Michae -- Message posted from http://www.ExcelForum.com Hi not really sure what you're trying to do. Could you give an example? -- Regards Frank Kabel Frankfurt, Germany > Hi all, > > Is it possible to run different macros on different cells at the same > time? If so how do I go about setting it up? > > Cheers > > Michael > > > --- > Message posted from http://www.ExcelForum.com/ Yes it is possible to run different m...

System Restore all off, still creating restore points on 2nd parti
Although we have System Restore turned off on all drives, restore points are still being created on the secondary partitions. The OS partiton is drive C, NTFS. The secondary partition is drive D, FAT32. The restore points are being created when applications (i.e. DirectX, WinDVD, etc.) are installed from the second partition (drive D). We must install these from a secondary partition. What are we missing? These restore points are filling up our drives. Also, I thought System Restore wouldn't work on FAT32 drives? Thanks, -- Bill Baker Bill, I use two drives b...

Create a new restore point
How does one create a new restore point in both Vista and Win7? When I go to Accessories-->System Tools-->Restore all I get is how to restore from a previous one. That's not what I want. I want to create a restore point. OldEd On 3/9/2010 5:14 PM, OldManEd wrote: > How does one create a new restore point in both Vista and Win7? When I > go to Accessories-->System Tools-->Restore all I get is how to restore > from a previous one. That's not what I want. I want to create a restore > point. > OldEd Click "Computer" in start menu th...

conditional formatting: separating rows with differing values
Hi, Need help with conditional fomatting. What I need: I got a worksheet with 950 rows and 5 columns. The first row contain the headers. Columns A, B, D and E contains unique values. But the column C contains text values which repeats sequentially for 6-7 rows and changes thereafter. Now I want to put up a line (using border) through the whole row dividing this transition row. My Idea: Compare C2 with C3, if equal do nothing. Then compare C3 with C4 and so on till 2 consequtive values differ. Now divide the 2 rows using the border formatting option in conditional formatting dialog box. So...

MC++ & C# generate different XML
Hi, I've been trying a long time now to generate some XML using MC++ and XmlSerializer. I have a piece of C# code that produces exactly what I want, but I simply can't get the MC++ code to write the same thing. Below I have included two minimal compilable samples that illustrate my problem. The C# code produces this XML: <?xml version="1.0" encoding="utf-8"?> <LandXML xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Units name="unit1" /> <Units name="un...

Microsoft Word/Page orientation
In a multi-page document, is it possible to change continuous pages from a page orientation of portrait to landscape and back to portrait again? I have tried this with page breaks inserted but it has not worked yet. I am using Word 2000. Thank you. you need to ask in microsoft.public.word or i could tell you the answer :-) use section breaks "KC" <mykcdog@yahoo.com> wrote in message news:521501c42ca1$4ba0e950$a501280a@phx.gbl... > In a multi-page document, is it possible to change > continuous pages from a page orientation of portrait to > landscape and ba...

dropdown filter on Data Access Page
Hi, I have a data access page that is based on a query in my database. Currently the page brings up all data for today, and the page is formated into teams So it looks like this Today's date Team #1 entry #1 entry #2 Team #2 entry #1 Since this page can get long sometimes, I would like to add a dropdown menu at the top of the page, that allows them to filter their results by team. So once they make a selection they would only see the team selected. Today's date Team (only 1 listed) Entry #1 Entry #2 I've been trying to search on this, but jus...

restore .ost file created in different exchange profile
Does anybody know how to restore email and other data from an .ost file created by a different user in a different domain name, please? OST files are linked to the mailbox/profile for which they were created. If you've got an orphaned one, you can't open it - you will need to google OST2PST (an old utility that may still be floating around) and try to run it against the file (make a backup copy first). Or see www.exchangerecovery.com - I know it works, but it's $$$. hughie wrote: > Does anybody know how to restore email and other data from > an .ost file created by a di...

Text Function with Different Formatting for Number
I'm trying to use a text function where I reference a number from another cell but I need the text part to be bold and the number not to be bold. This is the formula I'm using right now: ="Sales: "&TEXT(A16,"$#,##0_);($#,##0)") Unfortunately, excel won't let me just make the text bold without making the number bold. Anyone have any suggestions? Thanks M, I think a macro could do this, since it's really a string you're going to wind up with. But if you can put the Sales: part in a separate cell, life will be much easier anyway. then you ...