[AccessD] treeview control

A.D.Tejpal adtp at airtelmail.in
Thu Oct 1 11:56:46 CDT 2009


    You are most welcome Darryl!

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

  ----- Original Message ----- 
  From: Collins, Darryl 
  To: Access Developers discussion and problem solving 
  Sent: Thursday, October 01, 2009 10:36
  Subject: Re: [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
  ------------


More information about the AccessD mailing list