W
whistler
Hi, I am building an explorer type interface in access using the excellent guidelines at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart04/html/sa04k6.asp
It works fine enough, but I am however encountering a few small problems
1. When the form load event fires, I get this small dialog window requesting input for the parameter query as indicated in the above url. It's only a small bugging since I can just click it away and the treeview loads fine afterwards. Can anybody tell me if there is a way around the dialog window ?
2. I need to load quite a lot of data into the treeview (approximately 1000 records on the first node and about 10000 on the child node). That takes around 5 seconds loading. Are there any hints how to speed up that process (e.g. small changes to the code ?) Also, when closing the form on which the treeview sits I get an hourglass for 5 seconds.
3. The treeview in the above example is based on a table for the data of its first node. Can I also use a query for that ? How do I put that in VBA coding ?
The help of the wizzards in the newsgroup is much appreciated as always.
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart04/html/sa04k6.asp
It works fine enough, but I am however encountering a few small problems
1. When the form load event fires, I get this small dialog window requesting input for the parameter query as indicated in the above url. It's only a small bugging since I can just click it away and the treeview loads fine afterwards. Can anybody tell me if there is a way around the dialog window ?
2. I need to load quite a lot of data into the treeview (approximately 1000 records on the first node and about 10000 on the child node). That takes around 5 seconds loading. Are there any hints how to speed up that process (e.g. small changes to the code ?) Also, when closing the form on which the treeview sits I get an hourglass for 5 seconds.
3. The treeview in the above example is based on a table for the data of its first node. Can I also use a query for that ? How do I put that in VBA coding ?
The help of the wizzards in the newsgroup is much appreciated as always.
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-