TreeView

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

Any know if 2007 can make a tree view form?
This site has a good free example (http://www.datapigtechnologies.com/)
but doesn't seem to work with 2007. Maybe due to VBA changes.

I wanted to do exactly as their example with a table columns shown as tree.

Any help is greatly appreciated.

Robert
 
If you put the database in a Trusted Location and set the references as per
his tutorial, it should work OK in 2007.
 
If you put the database in a Trusted Location and set the references
as per his tutorial, it should work OK in 2007.
Click to expand...

Thanks alot for your reply. I guess this points to Operator Error!
Will keep looking at what I might be doing wrong.
Robert
 
Robert said:
Any know if 2007 can make a tree view form?
This site has a good free example (http://www.datapigtechnologies.com/)
but doesn't seem to work with 2007. Maybe due to VBA changes.

I wanted to do exactly as their example with a table columns shown as
tree.

Any help is greatly appreciated.
Click to expand...

I just tried that example in 2007....it works fine.....

Make sure your view the tutorial. In his example he using access 2000 in
which you need to set a dao reference. In 2007, we don't have to do that
anymore (yea!!). His code for SOME VERY STRANGE reason ALSO USES ADO, and
thus you need while looking at code go tools->references and setup the
reface to the common dialogs (as his video shows). You then need to setup a
reference to ADO (just choose

Microsoft ActiveX Data Objects (choose 2.6 or the latest you find).

I would think long and hard about introducing activeX controls into your
application. Often, in place of a drill down, I use two sub-forms as show in
these screen shots:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

You can also in place of the common dialogs, use the VB6 treeview. In access
2003, the runtime does install the treeview, I have to assume that access
2007 (and runtime) does the same.
 
Thanks very much for the help. Sorry for the delay.
------------------------------------------------------
 
Back
Top