Treeview

[Dreamweaver]

@MajP Looking for the download for yourtree view, Must be going blind or just not having a good day

 

[MajP]

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

The one in the beginning of the thread is bare bones.
By the end it has every bell and whistle we could think of (Drag drop, right click menu, left click menu, images, dynamic images, dynamic load, auto paragraphs, auto sort....)

Is this thread we are doing more with the MSForms version and has some links to the source.

Solved - Multiple search engine with dropdowns

See demo. I used module level variables, it was the simplest but maybe not the cleanest way.

www.access-programmers.co.uk

The MSFORMS is not as fast or capable, but if you need portability it is the way to go.

 

[Dreamweaver]

Thanks I Think I'll try your Class first as it's more down to the Query.

I'll shout when I get stuck lol

 

[MajP]

Thanks I Think I'll try your Class first as it's more down to the Query.

If you look at the example there are some demos on the first page for different table structures. There are two types of queries. The easy is a single table self referencing. The other is a union query of parent child tables.
In both examples you need
NodeID (Since they could come from different tables you need to concatenate the real id with something telling it where it came from. I call the the NodeLevel or Identifier)
ParentID (Same as the nodeid where you need to concatenate it with something identifying which table it came from)
NodeText (What you want to print in the tree)

If I click on a node its Key is the PK + the identifer of where it came from. So if the key is
22_Clients
I can then pull record 22 from the clients table.

If you make the query correct, It is really one line of code to populate a treeview.

In the MSFORMS version I did not put my loading code into their code. It would have been cleaner that way, but I did not want to break anything.
I made another class to reference their class to do the same thing as above.

 

[Dreamweaver]

Cool Thanks I think I have 3 tables, I want to replace the list on left of image which is filtered at the moment by the 2 combos.

don't think I need worry about images.

 

[Dreamweaver]

I think I'll try and leave the platforms as a combo and that would leave me with Objects and the main code table which should make it simpler lol