Form_DynamicGrpLevels |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
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: uploads/37/Form_DynamicGrpLevels.zip |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |