Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - ReportGrpPgTrack.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)


 Post Reply Post Reply
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP

Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: ReportGrpPgTrack.mdb
    Posted: 07 Jul 2008 at 10:30pm
This database demonstrates the display of page numbers for group headers
on a report, while retaining natural page sequence of the main report. Three options
exist for the type of output -

    (a) Normal report with the added feature that for groups spanning over more than
one page, start & end page numbers for the group are also displayed along with the
group header, which is repeated on all pages falling in the range (along with
continuation Suffix).

    (b) Summary Report listing just the group headers and their page particulars. This
can be useful supplement for very large reports.

    (c) Comprehensive report - In addition to covering (a) above, it contains a
subreport at the end summarising the groups with their page particulars.

    Note - Two alternative methods have been used for navigating through the
pages -
        (i)  Method A - Using SendKeys
        (ii) Method B - Using function  fTurnPage() taken from Stephan Leban's site.

Download Access 2000: uploads/37/


Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.