[AccessD] treeview control

Nice... I can see how this would be useful in the right app.

Cheers
Darryl 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D.Tejpal
Sent: Wednesday, 30 September 2009 10:31 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] treeview control

Dale,

    My sample db named Form_Treeview might be of interest to you. It is
available at Rogers Access Library. Link -
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45

    This sample is in Access 2000 file format and works on Access 2007
as well. It demonstrates two styles of treeview, one represents
employees organization chart, while the other facilitates marking of
student grades in a convenient manner.

    In both cases, there is two way synchronization between the treeview
and adjacent subform, for navigation and editing. 

    An interesting feature has been incorporated in employees version.
Whichever happens to be the current employee, complete chain of command
is highlighted. The employee and his top boss are shown in two different
colors while all intermediate supervisors in direct chain of command are
shown in another color. This highlighting gets implemented on the
treeview as well as subform in identical style.

    If an employee node is dragged over to another employee or
department, the resulting modified structure gets displayed on the
treeview as well as subform, duly highlighting the revised chain of
command in the manner described in previous para.

    Note:
    This is a fresh sample db and as mentioned at the end of explanatory
notes accompanying the sample, Drew's wonderful series of posts on
treeview control, and Arthur's excellent article on the subject (in
DatabaseAdvisors) have been of great help.

Best wishes,
A.D. Tejpal
------------

  ----- Original Message -----
  From: Dale Kalsow
  To: Access Developers discussion and problem solving
  Sent: Wednesday, September 23, 2009 01:14
  Subject: [AccessD] treeview control


  Good Afternoon,

  Does anyone have a simple treeview example for Access 2007, they are
willing to share?

  Thanks!

  Dale
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

"This e-mail and any attachments to it (the "Communication") is, unless otherwise stated, confidential,  may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any of its related entities including ANZ National Bank Limited (together "ANZ"). ANZ does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication."