Help On Locating Text by Position (Fake Treeview)

[CJ_London]

Would it be enough to add another column "PreviousState (expanded / collapsed)"?

possibly - or could use the value in the ptr column to indicate open/closed (needs more work since I might use different characters) and perhaps modify the open routine to not reset these on open

 

[Thales750]

As I said this is still in works. But for those interested.
FYI. The large demo loads fine because you load level by level. But if you collapse it it has to do a recursive call and lengthing search through a large (10k) records. It runs real slow and I may need to think of a better/improved method.

Is this the latest version?

 

[MajP]

I did not go any further with my version, but @CJ_London pointed out several possible enhancements. If you know the upper most levels (which you often do) then by storing the relation at all levels you can speed up the expanding and collapsing. Using the same idea but using a continuous form allows you to format and color the "nodes" at different levels. Is there some specific functionality you are looking at? May want to ask @CJ_London for his copy. Any reason not to use a real treeview control? Legitimate question since there are many reasons like stability why you may choose not to.

 

[Thales750]

I did not go any further with my version, but @CJ_London pointed out several possible enhancements. If you know the upper most levels (which you often do) then by storing the relation at all levels you can speed up the expanding and collapsing. Using the same idea but using a continuous form allows you to format and color the "nodes" at different levels. Is there some specific functionality you are looking at? May want to ask @CJ_London for his copy. Any reason not to use a real treeview control? Legitimate question since there are many reasons like stability why you may choose not to.

Just looking at it. No there is not. One of the participants of last years video asked about having indents in the tables controlled by the Tree. (I think that's what I read)
my big goal is to mimic the old Microsoft Project from the 90s. It had a tree to expand the lits and the Gantt would expand with it. There are some excell spreadsheet Gantt chrts that have indented data in the list. I was hoping to use automation and put the date from the tree in the spread with indents.
Something like that, just getting started.

 

[MajP]

If you look at the indented form below the tree view in this post

Nested Headers - Nested Subqueries/ Normalization Correct?

Video linked for explanation. I have 7 different HeaderTypes. Which I need to be displayed in a continuous form; similar to grouping on a report. Do not be fooled by the apparent sorted order of the BillTemsF. It appears sorted because correctly because BillHeadersAndItemsT ID has been created...

www.access-programmers.co.uk

I do some indenting that makes it look "tree ish"
As I say in that post somewhere I have to write to a table the following

NodeLevel - How many levels in it is
NodeSort - Reading from the top down where it need to be in the list.

The level will tell you how many spaces or characters to add to indent it
The sort is the only way to sort the tree correctly and has to be done by code. Because you Sort by Parent child, sub child ..., Next parent, ....

Sometimes like this one I add numbering too.