Provide a native Treeview control
The Treeview control is an extremely powerful way to display related and hierarchical data in a nodal fashion. I have built application for years using the vb Treeview common control. These applications could not be successful without it. There is certain data such as a computer folder and file structure that would be nearly impossible to comprehend without it., However, the non native Treeview require serious knowledge of Access and VBA to use successfully. Also portability has always been a problem. A native control with some features that make binding data simpler (possibly a wizard), would really expand what the common user can do with Access.
We are actively looking at providing a native tree view control.
Please continue to vote and provide more info – scenarios, examples and requirements will all feed into our exploration.
Mischa Haller commented
To create modern business applications, a modern and fast Treeview Control is absolutely necessary! It is unbelievable that MS Access in 2017 has no such control.
See at Klaus Oberdalhoffs post.. me too.. but a MS integrated solution would makes me happier...
Have a look at Exontrol.com's Grid control. It has lots of capabilities. We are using it, but not for tree view yet. It is expensive but has alot of customization.
Anders Ebro (TheSmileyCoder) commented
In response to the admin reply: "Please continue to vote and provide more info – scenarios, examples", I can demonstrate the 2 applications I have which have used the treeview extensively, should it be of any interest.
One is a requirements management tool (10.000 requirements) and as requirements are nested, it would have been extremely painfull to do this without a treeview.
The other is a review tool, which tracks documents, files, packages, and review comments across multiple versions, for a construction project in Central Copenhagen. It has currently reached 8000 document submittals, and has been running for 6 years. The treeview is used to display grouping of documents within packages, within areas. In a different form, the first treeview level shows document versions, second shows comment groupings, while the third level shows the comments themselves.
any update on this topic?
Last communication was about 3 months ago.
Any news getting a treeview that works with 64bit Access?
How soon is soon?
I too was hopeful that this will be implemented at some time and still am eager that the Access team will get around and provide a TV. It is a very basic feature to have in our day and age.
I understand that there are a couple of TV controls on the market. They are really great but:
1. One is currently free but the authors already claim that they have a beta version for a better one that will no longer be free. The other is quite expensive. I also tried the demo file they provide and it is buggy: clicking some of the nodes causes an error with a message claiming that there is no room for some sub-form and points to a vblr6.chm file and then crashes.
I realize that these can be dealt with by the authors (and I do have great respect and admiration for their coding abilities and expertise) but still, a native control will be fair after all this time, and will not require extra expenses from the Access community for such basic functionality.
2. Both do not have drag and drop capability at this time, which to me is very important, and is a game changer.
I hope you will reconsider and if I could I would have added my votes here but can no longer do so as this suggestion item has been closed
Klaus Oberdalhoff commented
a german company (picoware) sells VBA sourceCode - Free of any OCX and API (so also 64 bit with no problem) - a pure continuous subform which acts as a pure treeview. For the moment the docu is german only, but the head behind that idea is translating for the moment and an MVP-collegue showing it on the MVP summit ... www.picoware.de
I've bought it and use it and i'm overwhelmed and absolute happy.
Adrian Bell (MVP) commented
I feel your frustration Mark.
I suspect they have to be careful with what they commit to in the current round though, as resources are always finite.
Mark Taylor commented
Just goes to show how out of touch the Access developer team is with the needs of its users.
This has already been proposed and is under review. Delete this suggestion and save your votes :-)
Create a new Treeview-Control with more Features, design and a better performance
Adrian Bell (MVP) commented
I think this code is great. It comes as freely usable source code that anyone can include within their own projects.
However, I believe such functionality belongs within the product itself. As it can be used from Excel as well as Access, perhaps it should be included as an Office feature rather than limited solely to Access.
Consistency between projects is important and if each has a chance to implement this in their own different ways then how easy is that to take on for a third party?
There is a vast difference FMPOV between this as some published VBA and this as a feature provided by Microsoft and included within Office itself.
I truly do not understand this request as it has already been mentioned there exists a FREE (no strings attached), 100% VBA treeview which work in all versions and bitnesses.
What else do you guys need? Is there a problem with it? There are soooo many more important things that need to be fixed. This truly isn't an issue. It used to be, but thankfully someone took it upon themselves to fix it since MS wasn't doing it!
It would really nice if a TV control could load its images either from a table or from a folder and not another control (imagelist)
Coming late to the party, I understand the Access Team already has it "under review". Let me throw in a couple of observations anyway:
(1) Don't bother unless you (Microsoft) promise to support it in the future; nothing worse than telling a client, "You know that beautiful tree view we built? It no longer works because MS says so." Folks just think of this as bait and switch, only we are the bad guys.
(2) Let us have a TV that works for all versions, 32 bit, 64 bit, 2010, 2013, 2016 in all combinations
(3) A TV where we can drag-and-drop a limb or a branch in a very intuitive manner
(4) An intuitive connection between a node and an external path to files (images, documents, spreadsheets, etc.); think what this will do for inventories, people memberships and so on. I almost got it working some years ago when MS jerked the rug out on TV all together
I am aware I am asking a lot late in the game, but I would not use this feature without a promise from MS not to "deprecate" it in the future.
'Native' implies a non-ActiveX solution. Whereas there are number of 3rd party solutions. it would still be nice if a TV was native.
However, would it end up being just a 'partial' implementation - a good idea not implemented with enough functionality to be usable. And example of this is the Spilt Form view for a Form/SubForm scenario. A cool idea, but when you get in to using it ... there are a lot of gotchas :-(
Instead of requiring an ActiveX control why not use http://www.jkp-ads.com/Articles/treeview.asp which is a 100% free, 100% VBA solution. No need to wait upon Microsoft from anything!
Mark Burns commented
Also, to further this request - since the VB6-era Microsoft Treeview ActiveX controls WERE NEVER PORTED to 64-bit environments, this currently leaves 64-bit MS-Access with NO shared, common alternative treeview controls across 32-bit and 64-bit platforms (at least not without needing to resort to 3rd-party controls or unsupported shareware/freeware, which are also becoming harder to find and obtain/support).