Nodes in Access 2019

[PaquettePaul]

Access 2003 supported a box that allowed for storing data at multiple levels, or nodes. Click on a + sign and the node would expand to show more data. For example, the construct shows countries and click on US and it would expand to show the states. I used this subform window to support the maintenance of code tables.

I would set the construct with

Dim nodeTvw As Node

However, this results in a compile error in Access 2019 as node is not support with Dim statement. Anyone know whether the construct is still supported and how to setup.

 

[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

 

[GPGeorge]

Access 2003 supported a box that allowed for storing data at multiple levels, or nodes. Click on a + sign and the node would expand to show more data. For example, the construct shows countries and click on US and it would expand to show the states. I used this subform window to support the maintenance of code tables.

I would set the construct with

Dim nodeTvw As Node

However, this results in a compile error in Access 2019 as node is not support with Dim statement. Anyone know whether the construct is still supported and how to setup.

Tree view controls (which I think you mean) were deprecated for a couple of reasons, one of which was frequent instability.

However, the description offered -- I used this subform window to support the maintenance of code tables -- could also apply to subdata sheets, which are a resource intensive way to show related tables in a datasheet view of the tables. If that's what you actually mean, they're still around and still resource hogs.

 

[MajP]

Tree View is alive and well. See my thread.

 

[GPGeorge]

Interesting. I thought they had been dropped. Thanks for correcting that.

 

[PaquettePaul]

Yes, tree view structure was what I was talking about. Very stable when I used them. I will download the sample zip file and explore. Thanks a bunch MajP

i have some tables with minimal data that I did not want to create multiple search boxes for. So, I loaded the keys and descriptive info into the tree view pertaining to each of the forms such as people, projects, and code tables. When a person touches an entry, then the focus would switch to that subform in a multi tab form for add or edit. That is what I want to recreate in my new database app.

 

[PaquettePaul]

Quick point for MajP.
i looked through the tree view properties and when I went to change the font, another window popped up with the t review specific properties. Is there a way to change the font and/or font size in the tree view? Old folks with less than sharp eyes.

 

[Eugene-LS]

Is there a way to change the font and/or font size in the tree view?

Dim objTV As Object
  
    Set objTV = Me!objTreeView.Object

    objTV.Font.Name = "Verdana"
    objTV.Font.Size = 10
    'objTV.BorderColor = RGB(255, 255, 255)

   'TVRebuildTree objTV ...
   Set objTV = Nothing

 

[PaquettePaul]

Thanks again