Solved Treeview automomaticly filled from an Access table, without code ?

[Alain CHAZOT]

Hello,

I guess the question has been asked multiple times.
Sorry to ask it once again, but what I found didn't quite meet my request.

I have an Access table called "Category" with the following fields:

• N_Category: auto num - identifier of the category (unique key) - long int
• Category: category name - string
• ParentCategory: contains the N_Category ID of the parent category

Is there a TreeView type hierarchical list control that can be filled in automatically (i.e. without code) by indicating the source table (like a form or a drop-down list to which a table is linked in the "Source property ")?

I couldn't find the source property in the OCX Treeview 6 that came with Access 2016.

If that doesn't exist, I'll write the necessary VBA code, but the first solution would be better ;-)

Thank you !

Alain

 

[arnelgp]

you'll need to write it.
don't worry there are many example on the net.

 

[bob fitz]

Cross-Posted: https://www.accessforums.net/showthread.php?t=83126

Please read: https://www.excelguru.ca/content.php?184

 

[MajP]

Would a single line of code be OK?

Hierarchical Data, Recursion, Tree-Views, and a Custom Class to Assist

Would monitor size or resolution have anything to do with it and/or having a modal form? I'll try again when I get back home.

www.access-programmers.co.uk

 

[Alain CHAZOT]

Thanks a lot MajP, that's perfect !

 

[MajP]

Good luck. But seriously, if you can make that simple query and alias all the fields correctly you should be able to load that tree in a single line of code. I should have just mentioned to go to the front of that thread, because after my first post that thread blew up. Simply how to load the tree based on the class was in the first thread. The final solution of that thread was a super powerful treeview with just about every bell and whistle you could ask for.

 

[Alain CHAZOT]

Hi MajP,

I took a look at the code and it's very usefull for me.

Once again, thanks a lot, that's perfect ;-)

Alain

 

[Gasman]

Cross-Posted: https://www.accessforums.net/showthread.php?t=83126

Please read: https://www.excelguru.ca/content.php?184

Serial cross poster Bob, just crossposted two new threads today.

Obviously did not read the link you posted, or couldn't care less.