note on the bottom of first page

Hi Experts,

I have a report with 10 sub reports. the first 5 sub reports are often on page 1. But some times there are more records so the last sub report are moved to the next page. I also have a footer that can't be higher do to some layout restrictions.

Now to the question:

A have a label that should always be at the bottom of page 1. How do i insure that?
And if the last sub report is on top of the label at the bottom, then it should be moved to the next page. Is this possible?
DCRAPACCESSAsked:
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.

MikeMcEvoyCommented:
Use the page footer instead of the report footer and set it to only display on page one.

A similar question:Print page footer only on the first page
http://www.access-programmers.co.uk/forums/showthread.php?t=194970
0
Jeffrey CoachmanMIS LiasonCommented:
The issue here is that any solution should account for this "Label" to be on any sheet (and not hardcode it for page one or two)

If it were me I would simple Group the report on the individual Records (The Primary Key) and then set this "Lable" as a Textbox, and put it in the Groupfooter.

This is why we need you to tell us a bit more about the design and layout of the Report.
Also explain the logic behind why this "label" must only appear on page 1 or 2.

If possible, post a sample DB

Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Remove any records unless they are relevant to the issue.
5. Delete any objects that do not relate directly to the issue.
6. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
7. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
8. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
9. Compile the code. (From the database window, click: Debug-->Compile)
10. Run the compact/Repair utility.
11. Remove any Passwords and/or security.
12. Post explicit steps to replicate the issue.
13. Test the database before posting.

In other words, ...post a database that we can easily open and immediately see the issue, and if applicable, also include a Graphical representation of the Exact results you are expecting.

JeffCoachman

 
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
DCRAPACCESSAuthor Commented:
Hi MikeMcEvoy,

That is not possible since there should always be a page number as the last thing showing on each page. So i can't hide the report footer after page 1.
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.