Print Page | Close Window


Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
Printed Date: 24 Jan 2021 at 5:48pm
Software Version: Web Wiz Forums 12.03 -

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: -

Print Page | Close Window

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