A small project on Access (VBA)--2, reading Access table data to the TreeView and ListView

When I was asked if I could do a program, my first reaction was to say "can."

--this time in access, a data linkage model was made with the TreeView and ListView.

Brief analysis of the process:

1) from the Internet to find a TreeView Learning Tutorial "Three-hour learning tree control", the establishment of the TreeView and the use of nodes;

2) The data of a column in a data table is parsed into a tree structure (VPPs) in the TreeView according to a certain rule;

3) by traversing the collapsed state of a node in the TreeView, the data (uniqueness) generated by the above-mentioned rules is read into the ListView by the contents of the data table;

4) Select the corresponding data in the ListView by double-clicking the node in the TreeView (the data generated by some of the above rules is implemented);

At this point, the core code of a simple TreeView and ListView Data linkage model is all OK.

Note the point:

1) The single row data height of the TreeView and the ListView does not adjust;

2) The TreeView does not have its own double node event, and one way to do this is to combine the TreeView node with a click on the TreeView itself and double-click to simulate.