tag:blogger.com,1999:blog-8467396942183518214.post4861414671602296957..comments2022-03-24T20:19:44.253-04:00Comments on My MS Access Blog: Using Right-Click With Treeview NodesStephenhttp://www.blogger.com/profile/13190848153946763046noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-8467396942183518214.post-14896025802473806432011-04-07T18:28:21.920-04:002011-04-07T18:28:21.920-04:00Muito bom, parabens !Muito bom, parabens !Adelson R. M. Silvahttps://www.blogger.com/profile/08426605289422899322noreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-79103357199133423742010-10-04T10:58:08.091-04:002010-10-04T10:58:08.091-04:00Stephen-
Been trying to figure out a way to displa...Stephen-<br />Been trying to figure out a way to display a visual representation of a standard language library to automate preparation of canned reports. Everything I tried was klugey (sp?) until I found your website. With help i found here I was able to develop a three-level treeview display that shows reports with each reports sections and under each section the text options available fore each section. It looks great and should in production use soon. Thank you for organizing this rare to find subject matter into something a junior programmer like me could understand. Kudos!Joe Robeenhttps://www.blogger.com/profile/09756814649403109189noreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-62791066327403760702010-07-27T22:46:52.091-04:002010-07-27T22:46:52.091-04:00Hi There
How would I indicate that the event has ...Hi There<br /><br />How would I indicate that the event has been "handled" to the application in VBA? I keep on getting a default context menu--I'm using a listbox.<br /><br />Thanks!Unknownhttps://www.blogger.com/profile/03300490688756666518noreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-1740096499497190642010-01-27T05:30:37.257-05:002010-01-27T05:30:37.257-05:00Hi geckler,
I have the same problem, how did you ...Hi geckler,<br /><br />I have the same problem, how did you fix it?<br /><br />thanks<br />WarrenWarren Havemannhttps://www.blogger.com/profile/09489460442106658184noreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-86122385665662140992009-11-06T09:52:32.982-05:002009-11-06T09:52:32.982-05:00Geckler: congrats!Geckler: congrats!Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-77017062444084359502009-11-06T09:04:25.814-05:002009-11-06T09:04:25.814-05:00IT WORKS :-)IT WORKS :-)Gecklerhttps://www.blogger.com/profile/16717438015603122998noreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-46920783647411652182009-10-08T03:55:33.743-04:002009-10-08T03:55:33.743-04:00Hi again,
I hope you can give me a tip on how to ...Hi again,<br /><br />I hope you can give me a tip on how to do this :-)<br /><br />/larsGecklerhttps://www.blogger.com/profile/16717438015603122998noreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-61540274681581550232009-10-07T02:45:47.935-04:002009-10-07T02:45:47.935-04:00Stephen,
Thanks for your quick answer.
I'm f...Stephen,<br /><br />Thanks for your quick answer.<br /><br />I'm fairly new to this form of coding and therefore I'm not sure how to tell the button what code to run.<br /><br />/lars (Denmark)Gecklerhttps://www.blogger.com/profile/16717438015603122998noreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-6081767609269404212009-10-06T09:31:44.774-04:002009-10-06T09:31:44.774-04:00Geckler- it's in the code that creates your po...Geckler- it's in the code that creates your pop-up menu that you tell the button what code to run. Did you do that?Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.comtag:blogger.com,1999:blog-8467396942183518214.post-33683353357643145282009-10-06T07:05:10.082-04:002009-10-06T07:05:10.082-04:00Hi
I tried your code (Access 2007) but ...
The tre...Hi<br />I tried your code (Access 2007) but ...<br />The tree and the context menu (by right-click) is displayed but the routines are not being called. <br />It seems that the itms in the popup is not regarded as CommandButtons.<br />Can you help, please?<br /><br />CODE:<br />Public Sub treeview_MouseUp(ByVal Button As Integer, ByVal Shift As Integer, ByVal x As Long, ByVal y As Long)<br /> Set nodSelected = Me.TreeView.SelectedItem<br /> If Button = acRightButton Then<br /> CommandBars("MyTreeviewContextMenu").ShowPopup<br /> End If<br /> <br />End Sub<br /><br />Public Sub PopUpNodeNew()<br />MsgBox "New"<br /> With Forms!frm_new_domain.TreeView.SelectedItem<br /> MsgBox "Text=" & .Text & vbCrLf & _<br /> "Key=" & .Key & vbCrLf & _<br /> "Tag=" & .Tag<br /> End With<br />End Sub<br />Public Sub PopUpNodeEdit()<br />MsgBox "Edit"<br /> With Forms!frm_new_domain.TreeView.SelectedItem<br /> MsgBox "Text=" & .Text & vbCrLf & _<br /> "Key=" & .Key & vbCrLf & _<br /> "Tag=" & .Tag<br /> End With<br />End Sub<br /><br />Public Sub PopUpNodeDelete()<br /> MsgBox "delete"<br /> If MsgBox("Delete node " & Forms!frm_new_domain.TreeView.SelectedItem.Text & "?", _<br /> Buttons:=vbOKCancel) = vbOK Then<br /><br /> MsgBox "Node to be deleted"<br /><br /> ' delete code goes here<br /> ' usually as well as deleting the node there's some data to be deleted from tables as well<br /> Else<br /> MsgBox "Delete cancelled"<br /> End If<br />End SubGecklerhttps://www.blogger.com/profile/16717438015603122998noreply@blogger.com