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 - RunningCountSum_2K.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

RunningCountSum_2K.mdb

 Post Reply Post Reply
Author
Message
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: RunningCountSum_2K.mdb
    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: uploads/37/RunningCountSum_2K.zip

--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

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.