[AccessD] Page numbers

Susan Harkins harkins at iglou.com
Thu Jul 24 08:38:09 CDT 2003


What about a forced page break at the end of each contract? Then a Print or
Format procedure that checks the section that's printing... if it's the
header (indicating a new contract) reset the page number.... and I have no
clue what I'm talking about really. How would you return the section that's
currently printing/formatting? Or, what would happen if you treated each
individual contract as a subreport?

Susan H.


> Bobby,
>
> One simple way, at least in theory it is simple, is to make each
> contract into its own report instead all the contracts being one report.
> However, it may be impractical in your situation to make this change.
> Only you can tell whether this is a simple solution.
>
> Charles Wortz
> Software Development Division
> Texas Education Agency
> 1701 N. Congress Ave
> Austin, TX 78701-1494
> 512-463-9493
> CWortz at tea.state.tx.us
>
>
>
> -----Original Message-----
> From: Bobby Heid [mailto:bheid at appdevgrp.com]
> Sent: Thursday 2003 Jul 24 08:18
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Page numbers
>
> Hi all,
>
> Have a report that ideally prints on one page per contract, but many
> times could spill over to 2 or 3 pages for the contract.  The client
> wants me to put page numbers like so:
>
> page 1 of 1
> page 1 of 2 | 2 page report
> page 2 of 2 | here
> page 1 of 1
> page 1 of 1
> page 1 of 2 | 2 page report
> page 2 of 2 | here
>
> etc.
>
> I am not sure on how to go about doing this.  Any ideas?  I know that I
> can reset the Page variable, but I do not think that I can reset the
> Pages variable.
>
> I am using Access 97 on Win 2k.
>
> Thanks,
> Bobby
> _______________________________________________
> 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