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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Mohammad Alsolaimanapplication programmerAuthor Commented:
Is all of the report printed on the same special paper? Yes
i well try your solutions soon
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.