tag:blogger.com,1999:blog-84673969421835182142009-11-12T22:41:22.270-05:00Tips, tricks, best practices and more about Microsoft Office Access and Visual Basic for Applications (VBA). Links to great articles and posts around the web plus some things I've learned that I'd like to share.Stephenhttp://www.blogger.com/profile/13190848153946763046noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-8467396942183518214.post-43868681206795858612009-09-08T10:02:00.003-04:002009-11-07T06:28:40.877-05:00Stephenhttp://www.blogger.com/profile/13190848153946763046noreply@blogger.com0Here's another working Treeview example from the code archive at UtterAccess. Quote: This little database illustrates the implementation of Microsoft Knowledge Base Article Q20981 (How to Fill a...<br/> <br/> [[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/blogger/fpDE/~4/FIui2kz3Vnk" height="1" width="1"/>http://mymsaccessblog.blogspot.com/2009/09/treeview-example.htmltag:blogger.com,1999:blog-8467396942183518214.post-48614146716022969572009-09-04T19:58:00.005-04:002009-11-07T06:41:17.809-05:00Stephenhttp://www.blogger.com/profile/13190848153946763046noreply@blogger.com6Lets say you have a treeview and you want a user to be able to right-click a node and then be able to either delete it, copy it, or view details about it. How do you trap the right-click event? How...<br/> <br/> [[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/blogger/fpDE/~4/A7SSAUKv--s" height="1" width="1"/>http://mymsaccessblog.blogspot.com/2009/09/using-right-click-with-treeview-nodes.htmltag:blogger.com,1999:blog-8467396942183518214.post-51007554077039720032009-03-17T21:11:00.007-04:002009-11-07T07:30:17.973-05:00Stephenhttp://www.blogger.com/profile/13190848153946763046noreply@blogger.com8This (at long last) is Episode 6 of My Treeview Project. In Episode 1 we started with the "Hello World" treeview In Episode 2 we built a treeview that showed some simple data from the Northwind...<br/> <br/> [[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/blogger/fpDE/~4/OgcQhJS8n-8" height="1" width="1"/>http://mymsaccessblog.blogspot.com/2009/03/my-treeview-project-episode-6-images.htmltag:blogger.com,1999:blog-8467396942183518214.post-75043811088311934012009-03-16T16:41:00.004-04:002009-03-17T14:12:59.457-04:00Stephenhttp://www.blogger.com/profile/13190848153946763046noreply@blogger.com0Here's a treeview article I haven't run across before: Access TreeView-ListView Basics from Database Journal walks the reader through creation of a form with a treeview and a listview. It doesn't...<br/> <br/> [[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/blogger/fpDE/~4/80WMv2JNKjM" height="1" width="1"/>http://mymsaccessblog.blogspot.com/2009/03/access-treeview-listview-basics-from.htmltag:blogger.com,1999:blog-8467396942183518214.post-70114635074852464942008-09-14T20:21:00.011-04:002009-11-07T07:28:17.146-05:00Stephenhttp://www.blogger.com/profile/13190848153946763046noreply@blogger.com19In episode 5 we'll make the treeview really do domething. We'll use it to select records from the products and categories tables that we want to see or edit. The work you'll have to do in this...<br/> <br/> [[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/blogger/fpDE/~4/Ump4E1e38iw" height="1" width="1"/>http://mymsaccessblog.blogspot.com/2008/09/my-teeview-project-episode-5-using.htmltag:blogger.com,1999:blog-8467396942183518214.post-22863566693934098952008-03-29T07:09:00.009-04:002009-11-07T07:33:23.421-05:00Stephenhttp://www.blogger.com/profile/13190848153946763046noreply@blogger.com10In episode 4 we'll take the treeview we designed in episode 3 and add buttons for "collapse all" and "expand all". This will let us get started working with the nodes in a treeview. In previous...<br/> <br/> [[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/blogger/fpDE/~4/kxlFLf4LjiQ" height="1" width="1"/>http://mymsaccessblog.blogspot.com/2008/03/my-treeview-project-episode-4-expand.htmltag:blogger.com,1999:blog-8467396942183518214.post-31980094999588714022008-03-13T10:08:00.023-04:002009-11-07T07:36:25.209-05:00Stephenhttp://www.blogger.com/profile/13190848153946763046noreply@blogger.com6Treeviews are really powerful interface components. I love building with them. They aren't easy to get started with, though, for a few reasons: they can't be bound to data so you have to fill them...<br/> <br/> [[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/blogger/fpDE/~4/XYPEfpMgWR8" height="1" width="1"/>http://mymsaccessblog.blogspot.com/2008/03/my-treeview-project.htmltag:blogger.com,1999:blog-8467396942183518214.post-33865537118078244512008-03-11T22:12:00.015-04:002009-11-07T07:48:34.111-05:00Stephenhttp://www.blogger.com/profile/13190848153946763046noreply@blogger.com10Here's what we'll end up withafter this episode. In Episode 1: The Hello World! Treeview we built the simplest of treeviews, just to introduce some of the concepts. In Episode 2: Northwind...<br/> <br/> [[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/blogger/fpDE/~4/yb-Db8XNOtM" height="1" width="1"/>http://mymsaccessblog.blogspot.com/2008/03/my-treeview-project-episode-three.htmltag:blogger.com,1999:blog-8467396942183518214.post-58313437916638000162008-02-24T20:30:00.009-05:002009-11-07T07:44:05.938-05:00Stephenhttp://www.blogger.com/profile/13190848153946763046noreply@blogger.com9In Episode 1: The Hello World! Treeview we built the simplest of treeviews, just to introduce some of the concepts. In this episode we'll build a treeview to display products in categories. We'll...<br/> <br/> [[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/blogger/fpDE/~4/qIKyi_zTga0" height="1" width="1"/>http://mymsaccessblog.blogspot.com/2008/02/my-treeview-project-episode-two.htmltag:blogger.com,1999:blog-8467396942183518214.post-70859517079680252872008-02-21T05:10:00.003-05:002009-03-16T22:04:24.141-04:00Stephenhttp://www.blogger.com/profile/13190848153946763046noreply@blogger.com0I stumbled across this post on MSDN this morning. It gives a great overview of the treeview control that I hadn't seen before. See also: other treeview posts on my blog.<br/> <br/> [[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/blogger/fpDE/~4/GYk4_Su5PpU" height="1" width="1"/>http://mymsaccessblog.blogspot.com/2008/02/another-treeview-reference-from.htmltag:blogger.com,1999:blog-8467396942183518214.post-90394382913544013632008-02-14T21:30:00.014-05:002009-11-07T07:26:07.842-05:00Stephenhttp://www.blogger.com/profile/13190848153946763046noreply@blogger.com1The hello world program is a common first exercise when learning to work in a new programming environment: a program that simply displays or prints "Hello World!". In the first episode of this new...<br/> <br/> [[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/blogger/fpDE/~4/UC_RmmVmfkk" height="1" width="1"/>http://mymsaccessblog.blogspot.com/2008/02/my-treeview-project-episode-1-hello.htmltag:blogger.com,1999:blog-8467396942183518214.post-12387235356240186422008-02-13T06:00:00.004-05:002009-09-10T06:23:07.813-04:00Stephenhttp://www.blogger.com/profile/13190848153946763046noreply@blogger.com1Here's another working treeview sample from UtterAccess.com. This one's pretty sophisticated, with a drag and drop function used to change who staff report to and another to drag unassigned orders...<br/> <br/> [[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/blogger/fpDE/~4/qVn3QbjzNtw" height="1" width="1"/>http://mymsaccessblog.blogspot.com/2008/02/working-treeview-example-with-drag-and.htmltag:blogger.com,1999:blog-8467396942183518214.post-73980254672416376072008-02-11T19:37:00.004-05:002008-02-28T19:24:54.870-05:00Stephenhttp://www.blogger.com/profile/13190848153946763046noreply@blogger.com4Treeview continues to be one of the most common of the search keywords that bring folk to MyMSAccessBlog. I love developing with treeviews and if I can narrow down the specific questions folk are...<br/> <br/> [[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/blogger/fpDE/~4/WSfewwboSuk" height="1" width="1"/>http://mymsaccessblog.blogspot.com/2008/02/using-treeview-control-as-record.htmltag:blogger.com,1999:blog-8467396942183518214.post-35569500373876563202008-01-10T06:00:00.002-05:002008-02-21T04:57:20.448-05:00Stephenhttp://www.blogger.com/profile/13190848153946763046noreply@blogger.com0Treeviews are really powerful interface components. I love building with them. They aren't easy to get started with, though, for a few reasons: they can't be bound to data so you have to fill them...<br/> <br/> [[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/blogger/fpDE/~4/c0uwiazk9kA" height="1" width="1"/>http://mymsaccessblog.blogspot.com/2008/01/getting-started-with-treeviews-posts.htmltag:blogger.com,1999:blog-8467396942183518214.post-65978932923716379092008-01-08T06:00:00.015-05:002008-03-13T22:56:21.358-04:00Stephenhttp://www.blogger.com/profile/13190848153946763046noreply@blogger.com0Subscribe to RSS headline updates from: Powered by FeedBurner Treeviews are one of my favourite user interface components to develop with. But judging by the questions on the discussion forums, a...<br/> <br/> [[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/blogger/fpDE/~4/UiQL-9ObHas" height="1" width="1"/>http://mymsaccessblog.blogspot.com/2008/01/working-treeview-example.html