Access Treeview Wizard

[kent]

In case anyone was interested, I came across a wizard that Microsoft built to help create Treeview controls in Access forms. It's only for Access 97. Out of curiosity I tried it but thought it was unintuitive, as they want to have each level of nodes to come from a different table. I attached it if you wanted to try it out.

[kd2017]

Anyone know why m$ didn't maintain treeview controls? Sometimes I feel like could really use them.

[CJ_London]

suspect because they are activeX and use commoncontrols - which doesn't or didn't work with 64bit access. There are a number of good vba solutions about. This is quite a good one
https://www.jkp-ads.com/articles/treeview.asp

[kent]

Is the idea that there is an included wizard to implement the treeview in your database, or would you just copy out his vba code from the sample and rework it? It wasn't clear to me when I looked at the site.

[CJ_London]

You need to copy the code and modify to your requirements. The point is that it does not use an active X control but a form which can be used as a subform. Active X controls are generally considered to be unsafe and often version specific.

[kd2017]

You need to copy the code and modify to your requirements. The point is that it does not use an active X control but a form which can be used as a subform. Active X controls are generally considered to be unsafe and often version specific.

But I'm looking at it now and it does use an active x control... some kind of images container? OLE Class: MS Forms 2.0, Class: Forms.Frame.1 Is this considered a 'safe' active x control to use?

[CJ_London]

I hadn't realised - the link I provided is one that is often provided as a reference

[Minty]

There are a couple of VBA only treeview's about - an excellent discussion and examples are available here: https://www.access-programmers.co.uk...8#post-1683317