Hierarchy

[Anonymous_354]

Ok, here's my next assignment. I need to make a hierarchy in a form that looks like the one in Windows Explorer (or with the same functionality) to display a series of products with childern and grand-children even, and maybe great-grand-children. Or maybe add a button to add n amount of levels. I have a feeling that would take code, so go easy on me.

 

[CraigDolphin]

I can't help except that what you are looking for, I think, is called a tree view control and you can find more information about these using the search function here on the forum and via Google.

Maybe one of the gurus will have more to say.

 

[Anonymous_354]

I can't help except that what you are looking for, I think, is called a tree view control and you can find more information about these using the search function here on the forum and via Google.

Maybe one of the gurus will have more to say.

Well, ok. That might help. I'm surprised that it took bob longer to respond.

 

[boblarson]

Yes, look into the treeview control. I've never mastered that one though. The nodes confuse me. Maybe some day I'l get it down.

 

[CraigDolphin]

If Bob responds it will inevitably contain far more information than I will ever possess. More to type means longer to respond.

Or maybe he just has a life?

 

[boblarson]

Well, ok. That might help. I'm surprised that it took bob longer to respond.

Unfortunately I occasionally get disrupted here by my work Darn work...

 

[CraigDolphin]

How inconvenient!

 

[Anonymous_354]

You should get paid for how much you do here, bob. Can you tell my what you know about the tree-view stuff.

 

[boblarson]

You should get paid for how much you do here, bob. Can you tell my what you know about the tree-view stuff.

It'll probably be a few hours before I can respond, since I have to run now. Hopefully someone else might be able to chime in, but maybe you will want to post one more post titled "Help using Treeview control" to see if someone else will pop in.

 

[boblarson]

Here's a few possible links to check out. As I said, I have very little knowledge of how to use them.

http://support.microsoft.com/?kbid=209927

http://support.microsoft.com/kb/209891

 

[Anonymous_354]

Does anyone know much about the TreeView control?

 

[jvirk]

I Tried the examples in here. Get type mismatch error.

Here's a few possible links to check out. As I said, I have very little knowledge of how to use them.

http://support.microsoft.com/?kbid=209927

http://support.microsoft.com/kb/209891

I have tried the code example from the support article 209891 in an independent database. It works very well. But when I use the same table and same form in my working database which is a split and workgroup secured, it gives me an error of type mismatch in the line
AddBranch rst:=rst, strPointerField:="ParentNo", strIDField:="TagNo", strTextField:="TagDesc"

I have the same tree name, same table name and same field names as in my example database.
Could you please Help me or guide me to the my mistake.

 

[jvirk]

Thanks to everybody who replied to me in person.

I have tried the code example from the support article 209891 in an independent database. It works very well. But when I use the same table and same form in my working database which is a split and workgroup secured, it gives me an error of type mismatch in the line
AddBranch rst:=rst, strPointerField:="ParentNo", strIDField:="TagNo", strTextField:="TagDesc"

I have the same tree name, same table name and same field names as in my example database.
Could you please Help me or guide me to the my mistake.

I found an alternative to the problem. Which is unique to my programme, but I still wonder why did this example work on an independant database but not on my existing database?

 

[Ron_dK]

Does anyone know much about the TreeView control?

Here's an example that I copied from this site a while ago.

Hth