[AccessD] Access 2010 Report footer at Page Bottom

Bill Benson bensonforums at gmail.com
Fri Dec 5 08:25:36 CST 2014


Question:  This is probably a catch 22 / non-starter but... is there a way
Access can "know" the number of pages in a report without that footer, by
running a version without the footer in "the background" (as if there were
such a thing - am making this up as I go along)... then, re-run the report
with a provision that the footer shall not print unless the current page is
that page count that was achieved from the previous run?

Feel free to tell me I am off the wall and out of air.

On Thu, Dec 4, 2014 at 1:30 PM, Charlotte Foust <charlotte.foust at gmail.com>
wrote:

> I've used the dummy group technique many times for both headers and footers
> and it works quite well.
>
> Charlotte
>
> On Mon, Dec 1, 2014 at 9:13 AM, David Emerson <newsgrps at dalyn.co.nz>
> wrote:
>
> > Thanks Jim,  I think that is the way I ned to go.
> >
> > Regards
> >
> > David
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
> > Sent: Tuesday, 2 December 2014 1:05 a.m.
> > To: 'Access Developers discussion and problem solving'
> > Subject: Re: [AccessD] Access 2010 Report footer at Page Bottom
> >
> > David,
> >
> >  Couple methods here:
> >
> > http://support.microsoft.com/kb/208979
> >
> >  Keep in mind that you can create a dummy group using the expressions =1
> to
> > give you a extra header/footer.
> >
> > Jim.
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
> > Sent: Sunday, November 30, 2014 05:40 PM
> > To: AccessD
> > Subject: [AccessD] Access 2010 Report footer at Page Bottom
> >
> > 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
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list