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 - Form_DynamicGrpLevels
  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: Form_DynamicGrpLevels
    Posted: 09 Jul 2008 at 10:28pm
  This sample db demonstrates incorporation of dynamic group levels and hiding of
duplicates on a form in a manner similar to that for reports. Group headers and
group footers as well as overall footer (like report footer) are also included.

    The demonstration covers a book list. Default outermost group level (i.e. first
group level) is based upon Topic, while the inner group level is based upon author.
The set of headers and footers for topic (first level group) are highlighted in
matching color. Similarly the headers and footers for author (second level group) are
highlighted in matching color different from that of first group. Overall footer is
highlighted in another color.

    Group footers show the total number of books for the pertinent groups while the
overall footer shows the grand total.

    Double click on either of the first two columns (Topic or Author) toggles the
grouping level. For example if Topic is first group and Author is second group, the
arrangement gets reversed: Author becomes the first group while Topic becomes
the second group. Simultaneously, the order of columns also gets re-adjusted so
that the first column always displays the first group level.

    The demonstration covers continuous form view as well as datasheet view.
Toggling between datasheet and continuous form views (in the subform) is carried
out by clicking a command button on the parent form.

    (a) RecordSource for the form is made up of union queries and it is non-editable.
    (b) Visible property for column heading labels (located in detail section) meant for
         datasheet view is set to No. This does not hinder their display in datasheet
         view. At the same time, such labels remain hidden in continuous form view,
         where the purpose is met by labels located in form's header section.
    (c) Conditional formatting of controls, as required, is carried out via subroutine
          P_SetFormat() in subform's module.

Download Access 2000 File Format: 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.