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_Treeview
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

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

Form_Treeview

 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: Form_Treeview
    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 >>:  uploads/37/Form_TreeView.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.