INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

access 2007 - how to show page footer of report on 1st page only?

access 2007 - how to show page footer of report on 1st page only?

access 2007 - how to show page footer of report on 1st page only?

(OP)
Hi all - having a problem with an old application I did few years ago. User now wants his logo at bottom of page 1 only. But still wants to have page numbering on all pages. Have been tinkering around with the PageFooterSection_Format code as below that I found on these forums ...

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
Cancel = Page > 1
End Sub

This works to hide the logo after page 1 but also hides the page numbering after page 1.
Am just a novice with access code so sorry if too simple??

RE: access 2007 - how to show page footer of report on 1st page only?

Have you considered making the logo invisible in pages 2 and beyond?

CODE --> vba

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
    Me.LogoControlName.Visible = (Page = 1)
End Sub 

Duane
Hook'D on Access
MS Access MVP

RE: access 2007 - how to show page footer of report on 1st page only?

(OP)
Thanks for that suggestion Duane. On my PC I only have Access 2013 so have not been able to test as yet till I go to the users site with Access 2007. One question - will the visible switch set to NOT in that code ie pages 2 and following free up the page space at the bottom. The logo images (x4) take up about 5cm at the bottom of the page and the earlier solution code I was using just made them not visible but still kept the space tied up so the report body text could not flow the full depth of the following pages - just white space was showing which the user did not want. Thanks for your help much appreciated.

One further question how popular is Access nowadays as a client solution? Given it was a bit flaky in the past and with the increase in functionality of cloud business software is it still a force and should I be putting time into up skilling in Access in todays market?

RE: access 2007 - how to show page footer of report on 1st page only?

The solution I suggested will not free up any space at the bottom.

You might want to start a new thread regarding MS Access and the future. It's still the very best solution for creating database front-ends.

Duane
Hook'D on Access
MS Access MVP

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close