Print Page | Close Window

Form_Treeview

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=518
Printed Date: 18 Dec 2017 at 11:40am


Topic: Form_Treeview
Posted By: A.D. Tejpal
Subject: Form_Treeview
Date Posted: 29 Sep 2009 at 8:09pm

Form_Treeview
Explanatory Notes

    This sample db demonstrates treeview control with two way synchronization visa-vis conventional form. Two styles of  treeview control are covered as follows:

    1 - Employees organization chart:
    1.1 - Treeview at left shows the organizational set up in hierarchical style, department-wise, as per chain of command, while
the adjacent subform at right displays the same information in conventional style. 

    1.2 - Name of employee in current row of subform is highlighted in light green. Name of top boss for this employee is highlighted in light maroon while all intermediate superiors in the chain of command reaching up to current employee are highlighted in light orange.

    1.3 - In synchronization, corresponding nodes in treeview (current employee, top boss and intermediate superiors of current employee) get highlighted in colors matching those in 1.2 above.

    1.4 - Treeview - Drag and Drop feature:
    Any employee node can be moved to another employee or department node. The resulting change in command structure
gets reflected promptly in the treeview as well as the subform. If an employee node is dragged to empty space within treeview control (instead of specific destination node), a new department gets added, with the dragged employee designated  as top boss in that department.

    1.5 - Complete two way synchronization between treeview and the subform (Navigation / Editing):
    For navigation as well as editing, the treeview and subform are mutually synchronized. Any action on treeview is reflected on
corresponding record in the subform and vice versa.

    2 - Student grading:
    2.1 - Treeview at left displays classes and students while the adjacent treeview shows subject-wise grades for current
student.

    2.2 - Subject-wise grades can be entered / edited conveniently just by clicking the pertinent check boxes.

    2.3 - For convenient viewing, as soon as a given class node caption is clicked or navigated to (say by Up / Down arrow keys), it expands, displaying all student nodes belonging to that class. Simultaneously, all other class nodes get collapsed.

    2.4 - Complete two way synchronization between treeview and the subform (Navigation / Editing):
    For navigation as well as editing, the treeview and subform are mutually synchronized. Any action on treeview is reflected on
corresponding record in the subform and vice versa.

    Note:
    For editing the label caption for employee or student nodes in the above treeviews, select the node by clicking on its label.
Thereafter, click again so as to make the contents editable.

Version: Access 2000 file format.

References:
    DAO 3.6
    Microsoft Windows Common Controls 6 (SP 6) - (This is file MSCCOMCTL.ocx - normally in System 32 folder of
Windows directory)

   [Special Note Of Thanks to Drew Wutka for his outstanding series of instructive posts on AccessD discussion group (Database Advisors), and to Arthur Fuller of AccessD, for his excellent article in Database Advisors on the subject]

Download >>:  http://www.rogersaccesslibrary.com/forum/uploads/37/Form_TreeView.zip - uploads/37/Form_TreeView.zip
 
 
 


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

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



Print Page | Close Window