Print Page | Close Window

ReportGrpPgTrack.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=45
Printed Date: 20 Oct 2017 at 12:08pm


Topic: ReportGrpPgTrack.mdb
Posted By: A.D. Tejpal
Subject: ReportGrpPgTrack.mdb
Date 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: http://www.rogersaccesslibrary.com/forum/uploads/37/ReportGrpPgTrack.zip -




Print Page | Close Window