Recent content by mrodent

thanks for this... I had indeed spotted "ensurevisible" and wondered about it... but it just seemed and still seems very peculiar that there is so much difficulty in obtaining the parent node (as a variable) from a given node... and presumably the same applies to everything else like "next...

Re: TreeView problem with Node.Parent [SOLVED] cracked it. For reference: Dim currentNode As Variant Set currentNode = nodThis Do currentNode.Expanded = True If currentNode.Parent Is Nothing Then Exit Do Set currentNode =...

Hi ozinm, I've just tried googling "nested set model" because I've never heard of this... is this used with a TreeView control? Or how visually is it represented? Do you have any examples of using this for a visual tree control? Thing is, treeview control is fairly simple... but this...

@vbalnet... just wondering if you had had a chance to look at this problem?

um... that previous post has an attached db (.mdb) and two gifs... which should go in the same directory...

Hi, Thanks for your interest... I've done this... see attachment... tblNodes is pretty self-explanatory... one thing to bear in mind is that a parent node must, as things stand, come before any offspring nodes in tblNodes if it is to be included in the tree

Thanks... this is the code for the whole function... basically I want a node to be expanded all along its path if the "reminder date" is less than [today minus 2 days, the "prewarn" date]... otherwise the node should be collapsed. I'm just finding it completely impossible to get hold of a Node...

Thanks. But I tried the following If Not nodThis.Parent Is Nothing Then Set parentnode = nodThis.Parent parentnode.Expanded = True ... and when I ran it I got "type mismatch" (on line 2)... any idea what I'm doing wrong?

TreeView problem with Node.Parent [SOLVED] Dear all, There is a simple thing I want to do with a TreeView (NB Access 2000): for certain nodes I want them to expand... and expand their parent node, and grandparent node... etc. all the way up to root. Without this there is no guarantee that...