tag:blogger.com,1999:blog-8467396942183518214.post7011463507485246494..comments2022-03-24T20:19:44.253-04:00Comments on My MS Access Blog: My Treeview Project | Episode Five: Using The Treeview To Select Records to View/EditStephenhttp://www.blogger.com/profile/13190848153946763046noreply@blogger.comBlogger20125tag:blogger.com,1999:blog-8467396942183518214.post-69956971461261690582010-01-29T11:00:32.796-05:002010-01-29T11:00:32.796-05:00Hi,
beautiful article, it made me able to use tree...Hi,<br />beautiful article, it made me able to use treeviews in my app with a very professional and good-looking effect, thanks!<br /><br />Rsalpantehttps://www.blogger.com/profile/01527662370375947941noreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-81149097299950136742009-07-17T06:37:47.206-04:002009-07-17T06:37:47.206-04:00Hello,
Glad to be here!
I have a question.
I'm...Hello,<br />Glad to be here!<br />I have a question.<br />I'm trying to fill a listbox from a treeview control.<br /><br />I tried doing something like this:<br /><br />CodCIETree = The name of my treeview control<br />CIEID3digID = The name of the field bound to the listbox<br /><br />Private Sub CodCIETree_MouseUp(ByVal Button As Integer, ByVal Shift As Integer, ByVal x As Long, ByVal y As Long)<br /><br />If Button = RIGHT_BUTTON Then<br />Me.CIEID3digID.SelectedItem.Key<br /><br />End If<br /><br />End Sub<br /><br />... but it didn't work<br /><br />Can you give me a hand?<br /><br />Thanks in advance,<br /><br />DiegoDiego F. Pereira-Perdomohttps://www.blogger.com/profile/13278341035337058898noreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-79884578245902726282009-06-04T16:42:22.091-04:002009-06-04T16:42:22.091-04:00One of the best references on the Treeview control...One of the best references on the Treeview control I have ever found.<br /><br />Am currently having a problem with one of mine.<br /><br />My main form contains a treeview which is filled with activities. It also contains a subform with the activity details. On the subform there are several buttons that pops-up other forms.<br /><br />When one of these forms is opened (and it only happens with this one form), and then closed, the treeview inexplicably expands all of the nodes, but it only does it some of the time.<br /><br />I put a breakpoint on the cmd_Close_Click event, and tracked it through to the point where the treeview expands, and there is NO code that references the treeview in any way.<br /><br />I've used treeviews many times in the past (A2003 and earlier) but this is my first attempt to use it with an accdb file.<br /><br />Any ideas?Dalenoreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-34995091606153146862009-05-12T05:53:00.000-04:002009-05-12T05:53:00.000-04:00Apologies, just seen you have already uploaded Epi...Apologies, just seen you have already uploaded Episode 6. Blind as a bat sometimes!! ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-18546194422861555762009-05-12T05:50:00.000-04:002009-05-12T05:50:00.000-04:00Hi Stephen.
You articles are brillant!! You menti...Hi Stephen.<br /><br />You articles are brillant!! You mentioned a couple months back that Episode 6 will be a treeview with images for the nodes. The database is done and you just needed to write the article! - have you managed to post it yet? Also, is it possible to link the nodes to PDF files so that if I click on a node the PDF file for that specific product will pop up? If so, could you suggest the best way to do that? ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-40398925328924857102009-03-23T12:51:00.000-04:002009-03-23T12:51:00.000-04:00Thanks Stephen.Tried what you said and it worked. ...Thanks Stephen.<BR/><BR/>Tried what you said and it worked. Thanks very much.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-23356807852216870112009-03-17T07:12:00.000-04:002009-03-17T07:12:00.000-04:00Anonymous: there must be a code library that your ...Anonymous: there must be a code library that your code references that the other users don't have access to. For instance it might be on your c: drive. From the VBA window on their PC go to Tools/References and look for a library that says "MISSING".Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-91042759899985461262009-03-17T06:00:00.000-04:002009-03-17T06:00:00.000-04:00HI. I think your treeview articles are really impr...HI. I think your treeview articles are really impressive. One problem through, when I open my database my treeview automically pops up just fine, when other users go into the database, they are greeted with a message that says "compile error can't find project or library" and highlights private sub SetupTreeview (). But we are all working out of the same db. How come I can get the treeview but others users get that message? Could anyone explain the problem and offer a solution. ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-74612690668512729152009-03-16T00:45:00.000-04:002009-03-16T00:45:00.000-04:00Just wana say THANK YOU for this!! my uncle asked ...Just wana say THANK YOU for this!! my uncle asked me to create a database for him using access, and i only have experience in Java (although i do have a small amount of exp in VB [using excel tho, not access])<BR/><BR/>So thanks!!<BR/>PaulAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-66421745460809526242009-03-15T14:33:00.000-04:002009-03-15T14:33:00.000-04:00Episode 6 will be a treeview with images for the n...Episode 6 will be a treeview with images for the nodes. The database is done and I just need to write the article!Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-25921129836205463042009-03-05T12:21:00.000-05:002009-03-05T12:21:00.000-05:00Thanks for the great feedback all! I'm glad you've...Thanks for the great feedback all! I'm glad you've found treeviews as fun to develop with as I have, and I'm glad I could help you navigate the mystery!<BR/>Do let me know what you'd want to see in future "episodes". I'm going to make time to put at least a couple more up.Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-61859070045726684322009-03-05T10:33:00.000-05:002009-03-05T10:33:00.000-05:00HiUp until I found this site, finding anything, an...Hi<BR/><BR/>Up until I found this site, finding anything, anywhere about treeview controls was a nightmare. This site has literally changed how users interface with my database overnight. Fantastic alround. Hope you manager to write Episode 6, in an earlier comment you mentioned doing it about Pop up forms when you double click a node. Look forward to it! and Thank you.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-30954903032765938622009-03-01T12:03:00.000-05:002009-03-01T12:03:00.000-05:00In the Open Event of the Form, suggest both subfor...In the Open Event of the Form, suggest both subforms have the Visible property set to False. This will prevent both subforms appearing/overlapped etc before the user clicks on the Treeview control.<BR/><BR/>jackUnknownhttps://www.blogger.com/profile/04211173209613515345noreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-56000528829293213382009-02-07T21:45:00.000-05:002009-02-07T21:45:00.000-05:00having problem withe the click funktion !Private S...having problem withe the click funktion !<BR/><BR/>Private Sub TreeView1_Click()<BR/>Dim nodSelected As MSComctlLib.Node ' a variable for the currently selected node<BR/> <BR/> Set nodSelected = Me.TreeView1.SelectedItem ' get the currently selected node<BR/> <BR/> If nodSelected.Key Like "Sys=*" Then ' are we on a product node<BR/> MsgBox "fredrik"<BR/> ElseIf nodSelected.Key Like "Usys=*" Then ' are we on a category node<BR/> MsgBox "Undersystem"<BR/> <BR/> <BR/> Else ' somehow this is neither a category or product node<BR/> MsgBox "inget"<BR/> <BR/> End If<BR/>End Sub<BR/>geting an error when i click on the node <BR/>refrens not conected or ?<BR/>anyone a clue?Fredrikhttps://www.blogger.com/profile/07790551679212554469noreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-84788232783393546992009-01-02T17:10:00.000-05:002009-01-02T17:10:00.000-05:00Many thanks for this info. I wrote a lot of treev...Many thanks for this info. I wrote a lot of treeview stuff for Access some years ago, but since then I've been doing my "proper job" (big, big, big databases) and I'd forgotten the details. I needed a refresher. Thanks! Andrew in LondonAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-1145614648003551592008-12-22T17:42:00.000-05:002008-12-22T17:42:00.000-05:00Well done description of a complicated and underdo...Well done description of a complicated and underdocumented topic<BR/><BR/>However, I note that Click() isn't triggered if the user is navigating via keyboard and I couldn't find a useful alternate Event; any recommendations as to modifications to accommodate arrowing from one treeview record to another and expanding child nodes via plus signSoulcrafterhttps://www.blogger.com/profile/14418005552533129761noreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-72337928007575977442008-12-17T11:57:00.000-05:002008-12-17T11:57:00.000-05:00Nice job.Do you have an example of a recursive rou...Nice job.<BR/><BR/>Do you have an example of a recursive routine for products (like a mult-level bill of material) -- products used to make higher level products?<BR/><BR/>Please email me at dave.meyer@live.com.<BR/><BR/>Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-47026688447336479752008-12-06T12:00:00.000-05:002008-12-06T12:00:00.000-05:00tree have become fun..thanks to u..but there is a ...tree have become fun..thanks to u..but there is a issue ..if i am having a date validatin(eg.compare validator) then tree just expands once before validation and dies..can u help..Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-54990046124435230892008-11-25T14:33:00.000-05:002008-11-25T14:33:00.000-05:00From zero humble steps on my own in one night ... ...From zero humble steps on my own in one night ... many thanksPaulhttps://www.blogger.com/profile/11526352338190576390noreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-68089881659435198032008-10-08T02:07:00.000-04:002008-10-08T02:07:00.000-04:00Perfectly wonderful information.Before I found thi...Perfectly wonderful information.<BR/>Before I found this blog, using Treeview control seems like something under scope of high-level programmer.<BR/>Now I feel it get much familliar.<BR/><BR/>I am looking forward next story.SNAKEBOBhttps://www.blogger.com/profile/06520794565457962277noreply@blogger.com