Leaving space at top of second page

Hi:
i have an official sheets with heading and footer to print my letter on it.
I need to pull down the printed records at the second page , so i can leave a space at top of page for the heading on the official sheets.
Please help.

1.PNG
3.PNG
-Report-Q2.mdb
Mohammad Alsolaimanapplication programmerAsked:
Who is Participating?
 
pteranodon72Commented:
PageHeader.Height is now 0.698cm.  Increase this to 5.698cm (assuming 5cm of print on special paper). Move the labels within PageHeader from the top edge (top=0) to the bottom edge (top = 5cm).

Now, this will affect all pages by default, possibly messing up the design of page1 because that's where the Report Header goes. You can:

Easy) Redesign the Report Header to accommodate the new Page Header or:

Harder) Put the Page Header labels at the bottom of the Report Header and suppress the Page Header on Page 1. In the OnFormat Event of PageHeader:
Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)
If FormatCount = 1 Then ' only make changes in the first format event
    If Page = 1 Then 'treat page 1 differently
        PageHeaderSection.Visible = False ' suppress page1 page header
    Else
        PageHeaderSection.Visible = True ' keep page header after page 1
    End If
End If
End Sub

Open in new window


pT72
0
 
pteranodon72Commented:
M_SOLAIMAN,
Is all of the report printed on the same special paper? If so, you can adjust the Report's top and bottom margins to reflect the effective margins you want to use.
Or, you can use PageHeader and PageFooter sections to account for the space blocked by the special paper's design. It looks like you have a big space in the Report Header section, which will only affect page 1. remove that space and stretch the PageHeader and PageFooter to block printing on the special paper's ink.

HTH,
pT72
0
 
pteranodon72Commented:
Now I see that you use PageHeader within the report. You can lengthen it by the (distance from page top edge to special paper text bottom) minus (Report's top margin), then move all controls from the top of the page header to the bottom of the page header.

I think it will help if you post the dimensions of the special paper to be more precise.

pT72
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Mohammad Alsolaimanapplication programmerAuthor Commented:
Is all of the report printed on the same special paper? Yes
i well try your solutions soon
0
 
Jeffrey CoachmanMIS LiasonCommented:
This is confusing as the solution here may effect the solution to your other related question.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27478731.html

Why not wait and get the answer to one question before posting another question...?
0
 
Mohammad Alsolaimanapplication programmerAuthor Commented:
You are right boag2000: I suppose to wait , sorry for harry
Your answer to the first question was good
Here I need the record in second page to start shifted to meddle of sheet
to leave a space for the formated papers.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Again, this is "If-y" because the number of records is set by the page itself.

AFAICT, this will not be easy, as the only way I know of to do this would be to adjust the margins.
Unfortunately doing this "Dynamically" will be tricky.

Why not dump the pre-printed papae stock and put the headings in your report, ...then this will all be easy AFAICT...

Let's see what the other Experts post, in case I am not understanding something here...


JeffCoachman
0
 
Mohammad Alsolaimanapplication programmerAuthor Commented:
wonderful pteranodon72:
but how to show header on 1st page ?
i couldent understand the second part of your comments
please
1.PNG
2.PNG
0
 
pteranodon72Commented:
Great! You just need to make a small change to the Report Header now.

Make the Report Header 0.698cm longer (original size of the Page Header).
Copy the 5 labels that are in the Page Header and paste them at the bottom of the Report Header section.

That way:
Page 1 shows Report Header including data labels -- and no Page Header.
Page 2+ shows Page Header with data labels.

Hope this helps,
pT72
0
 
Mohammad Alsolaimanapplication programmerAuthor Commented:
pteranodon72 , Yes , wonderful solution
thanks to all of you people in here
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.