Print Page | Close Window

Form_DynamicGrpLevels

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=107
Printed Date: 16 Dec 2017 at 9:47am


Topic: Form_DynamicGrpLevels
Posted By: A.D. Tejpal
Subject: Form_DynamicGrpLevels
Date 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.

    Note:
    (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: http://www.rogersaccesslibrary.com/forum/uploads/37/Form_DynamicGrpLevels.zip - uploads/37/Form_DynamicGrpLevels.zip



-------------
--

Email: mailto:adtejpal@gmail.com - adtejpal@gmail.com



Print Page | Close Window