[AccessD] Access 2010 Report footer at Page Bottom

Bill Benson bensonforums at gmail.com
Fri Dec 5 11:44:29 CST 2014


Hi Charlotte,  I misinterpreted the requirement,  thank you.

Bill
On Dec 5, 2014 11:34 AM, "Charlotte Foust" <charlotte.foust at gmail.com>
wrote:

> Not sure what you want to achieve with that.  The report footer always
> prints on the last page.  The report formats itself before the print occurs
> but the page numbering can change depending on the volume of data in the
> report.
>
> Charlotte
>
> On Fri, Dec 5, 2014 at 6:25 AM, Bill Benson <bensonforums at gmail.com>
> wrote:
>
> > 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
> > >
> > --
> > 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