Like many of you, I have used the TreeView control in the past for a couple projects. Sadly, everything came crashing down on me when Microsoft released their update KB2596856 and instantaneously my clients who were running my databases with the TreeView control could work no longer! … I cleaned up the mess and stayed as far away from ActiveX controls as possible.
On top of that, it never got ported to x64 bit, so those developers were screwed (for lack of a better word).
Then Microsoft decided to do away with the TreeView control altogether.
So what does one do?
The TreeView itself can be a very useful tool no doubt, but Microsoft’s solution was too limited and fragile.
Once again, the community answered the call! JKP Application Development Services developed and freely released 100% VBA TreeView, no strings attached!
Pros:
- 100% VBA
- Nothing to install/register (dll, ocx, …)
- 32bit and 64bit compaticle
- Even work on MACs
- They offer samples to learn from!
- They have a samples for Excel, Word and Access.
If you are looking for a TreeView control I’d highly urge you to take a look at it, see:
Example Treeview in MS Access
If you follow the link, they provide very extensive sample that illustrates many of the things you can do. So, go to their website and download their Access sample.