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: 18 Jul 2018 at 3:09am

Topic: RunningCountSum_2K.mdb
Posted By: A.D. Tejpal
Subject: RunningCountSum_2K.mdb
Date Posted: 06 Jul 2008 at 11:01pm
This database covers display of running count and  sum of records on continuous
forms. Two alternative methods are demonstrated -
    Method A (Form Based) -
        Values are computed locally in calculated controls on the form. There is no
dependence on any primary key or particular sort order. (Records Remain Editable)

    Method B (Query Based) -
        Values are computed in the source query. Though primary key is required,
there is no compulsion to sort on it (Records Remain Editable)
    Note - Typically, record counter in a query involves use of either a subquery or
DCount function. Both require (i) A primary key  and  (ii) Sorting to be in force - on
the primary key field. This can pose a limitation where main sorting is desired on a
field other than that holding primary key. Moreover if subquery method is used, the
records are no longer editable.
    The sample database is free from such limitations

Version - Access 2000
       References -
            Visual Basic For Applications
            Microsoft Access 9.0 Object Library
            OLE Automation
            ADO 2.6
            DAO 3.6

Download Access 2000: -

Print Page | Close Window