Access Treeview Tutorial Part 6 – New Nodes and Records
Introduction
This blog post is about how to use the treeview itself in combination with right click events as the platform for creating new records. This is a great feature since we can use the treeview and the mouseclick event to specify the location of the new record/node.
The video
As usual I have created a youtube video which shows all steps required. Hope you will like it.
I hope you have enjoyed this series on treeviews in Access. Please leave a comment if this was usefull to you!
Thank you for a great series on treeviews. It was really helpfull.
Thanks for the great videos. It’s amazing that even 8 years later, they are still the best tutorials on the subject.
I’d like to use a monotype font, like Consolas, in my treeview control. I don’t see any relevant properties, and I’ve found nothing online explaining how to do this. Is it possible, even by changing some system font in Windows?
If i want to search inside treeview ?
In the simplest form, you could use a textbox, then in the afterUpdate event something like
For each NodX in Treeview.Nodes
if NodX.text=me.txt_Searchbox then
nodx.Selected=true
NodX.EnsureVisible
exit sub
end if
Next
You can then expand on this with a search next or ….
An alternative could be to search the query directly, and then based on that result, find the node from the treeview based on the key.