[AccessD] Access 2010 Report footer at Page Bottom

Hi Andy,

I already have other stuff in the page footer for each page and including
the report footer information would take up too much extra space on the
other pages.

I am running with the Microsoft article pointed out by Jim.

Regards

David

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Tuesday, 2 December 2014 8:47 a.m.
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2010 Report footer at Page Bottom

Sorry David, typo. I meant to put your stuff in the Page Footer and put that
code in the OnFormat of the PageFooter, not ReportFooter. Doh! This will put
it at the foot of the page (as per Page Footer) but suppress it for all but
the last page.

Andy

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
Sent: 01 December 2014 17:12
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2010 Report footer at Page Bottom


Hi Andy,

Thanks for taking the time to reply.  I am not sure how your solution will
help.  The report footer will always be on the last page anyway so there is
no need to check the previous pages.  What I am after is how to position it
on the last page always at the bottom.  Jim seems to have confirmed the best
way to do it.

Regards

David

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Monday, 1 December 2014 10:45 p.m.
To: AccessD at databaseadvisors.com
Subject: [AccessD] Access 2010 Report footer at Page Bottom

Hi David

How about this?

Create a textbox whose ControlSource is

="Page " & [Page] & " of " & [Pages]

You can make it invisible if you like but it needs to be there.

Then  In the OnFormat of the ReportFooter put this code

If Me.Page <> Me.Pages Then
Cancel = True
End If

The reason you need the textbox is that the Pages property only has a value
if you have a control on the report invoking it.
 
I reckon that should do it.

Cheers

Andy

 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
Sent: 01 December 2014 04:46
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2010 Report footer at Page Bottom


Thanks Charlotte,
I have seen some code by Microsoft for putting it at the bottom of the last
page but it seemed to cover more situations than what I wanted.
Because the text I want is higher than what I want to allow for a page
footer on every page it would waste too much space on all the pages before
the last one.
Back to the drawing board.
Regards
David Emerson
Dalyn Software Ltd
Wellington, New Zealand

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Monday, 1 December 2014 1:48 p.m.
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 2010 Report footer at Page Bottom

The report footer is always going to print immediately after the report.
If you want it at the bottom of the page, you need to use the page footer.
Alternatively you can put a dummy subreport on the report and force it to a
size that will move the report footer to the bottom. That requires more care
and feeding than it's worth.

Chafrlotte

On Sun, Nov 30, 2014 at 2:40 PM, David Emerson <newsgrps at dalyn.co.nz> wrote:

> Hi Listers,
>>
> Does anyone have some simple code that puts the report footer at the 
> bottom of the last page. I don't want to use the page footer section, 
> just the report footer section.
>>
> Regards
>
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand