Hierarchical table control needed

Can anyone recommend a quality third-party control that meets the following
criteria:

-Capable of displaying flat table in hierarchical "tree grid" form (given
good data)
-Must be usable in MS Access 2007
-Must be able to bind to data
-Must have trappable events model (i.e. VBA programmability)
-In cell editors a plus

I have looked at DevExpress and Bennet-Tec TList, but I am still in the
market. I am also interested in other solutions, but my users are demanding
expandable/collapsable tree displays.

Thanks!
Matthew Pfluger

Matthew,

Please give an example of your data and an example of your data in an
expandable/collapsable tree display.

Thanls!

Steve



"Matthew Pfluger" wrote in
message ...
Can anyone recommend a quality third-party control that meets the
following
criteria:

-Capable of displaying flat table in hierarchical "tree grid" form (given
good data)
-Must be usable in MS Access 2007
-Must be able to bind to data
-Must have trappable events model (i.e. VBA programmability)
-In cell editors a plus

I have looked at DevExpress and Bennet-Tec TList, but I am still in the
market. I am also interested in other solutions, but my users are
demanding
expandable/collapsable tree displays.

Thanks!
Matthew Pfluger

Matthew,

What is wrong with the Treeview that is already available in Access, it is
listed as Microsoft Treeview Control Version 6 in the list of controls that
pops up when you select the "more controls" button in the toolbox
commandbar.

The only one of your "requirements" that it doesn't precisely meet is the
"bind to data" requirement, but there are all sorts of ways to work around
that. I use the treeview quite a bit, and generally add a subform right
next to it to display the detailed data associated with the selected item.
This is not difficult.

The first time I tried this, I was extremely disappointed by the number of
events that showed up in the properties window for the control, but if you
go to the VBA window and select the treeview control, you will see a large
list of other events that are associated with the treeview control.

HTH
Dale

"Matthew Pfluger" wrote in
message ...
Can anyone recommend a quality third-party control that meets the
following
criteria:

-Capable of displaying flat table in hierarchical "tree grid" form (given
good data)
-Must be usable in MS Access 2007
-Must be able to bind to data
-Must have trappable events model (i.e. VBA programmability)
-In cell editors a plus

I have looked at DevExpress and Bennet-Tec TList, but I am still in the
market. I am also interested in other solutions, but my users are
demanding
expandable/collapsable tree displays.

Thanks!
Matthew Pfluger

My end users and I do not like the TreeView's single column nature. I know
you can link the control to another subform, but I want to display each row's
additional columns while providing a tree structure.

As far as sample data is concerned, choose any hierarchical data set; this
question does not pertain to a specific set.

Referring back to my previous post, I've looked into DevExpress'
XtraTreeList and found that to be interesting, but that is only for Visual
Studio. I also this Adobe's Advanced DataGrid is what I need, but that only
works with their Flex program. I need an ActiveX control to embed in my
database applications.

Thanks for reading,
Matthew Pfluger


"Dale Fye" wrote:

Matthew,

What is wrong with the Treeview that is already available in Access, it is
listed as Microsoft Treeview Control Version 6 in the list of controls that
pops up when you select the "more controls" button in the toolbox
commandbar.

The only one of your "requirements" that it doesn't precisely meet is the
"bind to data" requirement, but there are all sorts of ways to work around
that. I use the treeview quite a bit, and generally add a subform right
next to it to display the detailed data associated with the selected item.
This is not difficult.

The first time I tried this, I was extremely disappointed by the number of
events that showed up in the properties window for the control, but if you
go to the VBA window and select the treeview control, you will see a large
list of other events that are associated with the treeview control.

HTH
Dale

"Matthew Pfluger" wrote in
message ...
Can anyone recommend a quality third-party control that meets the
following
criteria:

-Capable of displaying flat table in hierarchical "tree grid" form (given
good data)
-Must be usable in MS Access 2007
-Must be able to bind to data
-Must have trappable events model (i.e. VBA programmability)
-In cell editors a plus

I have looked at DevExpress and Bennet-Tec TList, but I am still in the
market. I am also interested in other solutions, but my users are
demanding
expandable/collapsable tree displays.

Thanks!
Matthew Pfluger