tag:blogger.com,1999:blog-84673969421835182142015-11-06T13:36:54.964-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.Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.comBlogger17125tag:blogger.com,1999:blog-8467396942183518214.post-13824255242962157712011-09-04T14:45:00.003-04:002011-09-04T14:48:24.578-04:00

You may have noticed I haven't posted in a while. I have not been working in VBA/MS Access and have neglected the blog. But I'm still here.... I was doing some reading today and noticed that we now are given to expect that the treeview control is not supported in the 64-bit version of Access 2010. Sounds like most folk should be installing the 32-bit version and so will continue to have access

Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.com0tag:blogger.com,1999:blog-8467396942183518214.post-83389258887229763082009-11-17T06:00:00.000-05:002009-11-16T22:23:39.910-05:00

In Episode 7 of My Treeview Project we're going to look at another approach to reading through our data and adding nodes to the treeview. Different ways to get data for the treeview nodes In Episode 1 we didn't use a table at all; the nodes to be added were defined in the code. That approach may be suitable for treeviews that are used for navigation where the nodes don't depend on your data.

Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.com3tag:blogger.com,1999:blog-8467396942183518214.post-43868681206795858612009-09-08T10:02:00.003-04:002009-11-07T06:28:40.877-05:00

Here'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 Treeview Control Recursively). In addition, frmFolderExamples illustrates one way to fill the Treeview Control with the names of the folders located on a drive. It also shows how to return some of the

Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.com0tag:blogger.com,1999:blog-8467396942183518214.post-48614146716022969572009-09-04T19:58:00.005-04:002009-11-07T06:41:17.809-05:00

Lets 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 do you show a context menu? And how do you know what node was clicked? There's no OnRightClick event for Treeviews- that would have been the easiest solution. There are MouseUp and MouseDown events

Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.com10tag:blogger.com,1999:blog-8467396942183518214.post-51007554077039720032009-03-17T21:11:00.011-04:002009-11-13T12:19:30.197-05:00

This (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 Traders sample data In Episode 3 we learned how to change the appearance of the treeview In Episode 4 we added Expand All and Collapse All buttons that interact with the treeview And in Epsiode 5 we

Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.com17tag:blogger.com,1999:blog-8467396942183518214.post-75043811088311934012009-03-16T16:41:00.004-04:002009-03-17T14:12:59.457-04:00

Here'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 have a detailed explanation of how it works, but it does include a downloadable working example, and the zip file for the example includes the elusive help file that covers the treeview and

Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.com0tag:blogger.com,1999:blog-8467396942183518214.post-70114635074852464942008-09-14T20:21:00.012-04:002009-11-13T14:10:49.891-05:00

In 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 episode is a little more than in the last two, but we'll go through it step-by-step. We're building on the work you've done in previous episodes. If you started in the Northwind database in episode

Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.com20tag:blogger.com,1999:blog-8467396942183518214.post-22863566693934098952008-03-29T07:09:00.011-04:002009-11-13T13:47:37.531-05:00

In 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 episodes I told you to make sure you'd built the treeview from the last episode so we could add to it. This time you can download the completed treeview including this episode. Download the

Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.com13tag:blogger.com,1999:blog-8467396942183518214.post-31980094999588714022008-03-13T10:08:00.025-04:002009-11-16T22:29:05.265-05:00

Treeviews 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 using VBA code, they're not part of Access and so aren't covered in the Access help (they're ActiveX controls), and they are often used with complex data, such as hierarchical relationships. I see lots

Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.com7tag:blogger.com,1999:blog-8467396942183518214.post-33865537118078244512008-03-11T22:12:00.016-04:002009-11-13T12:26:10.211-05:00

Here'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 Categories and Products we created a treeview that displayed products in categories based on data from the Northwind sample database. In this episode we'll take the treeview from epsiode 2 and add some

Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.com12tag:blogger.com,1999:blog-8467396942183518214.post-58313437916638000162008-02-24T20:30:00.010-05:002009-11-13T13:41:46.588-05:00

In 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 use data from Microsoft's Northwind Traders sample database. If you don't have a copy you can download it here . Start by creating a blank form in the Northwind Traders database and add a

Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.com9tag:blogger.com,1999:blog-8467396942183518214.post-70859517079680252872008-02-21T05:10:00.003-05:002009-03-16T22:04:24.141-04:00

I 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.

Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.com0tag:blogger.com,1999:blog-8467396942183518214.post-90394382913544013632008-02-14T21:30:00.016-05:002009-11-13T15:38:33.901-05:00

The 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 series on treeviews we'll build the hello world treeview in an Access form. Create a new blank Access database, create a new form and go into design view. Using Insert/Activex Control, place a

Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.com3tag:blogger.com,1999:blog-8467396942183518214.post-12387235356240186422008-02-13T06:00:00.004-05:002011-08-27T08:07:47.993-04:00

Here'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 from a listview into the treeview where you drop them on the staff that will work on them. A nice implementation indeed. The author, Brent Spaulding, is one the the treeview experts at UtterAccess.

Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.com4tag:blogger.com,1999:blog-8467396942183518214.post-73980254672416376072008-02-11T19:37:00.004-05:002008-02-28T19:24:54.870-05:00

Treeview 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 searching for answers to I'll post some detailed tips or solutions. For now, here's here's a zip file from Helen Feddema's Access Archon page with a working example: original version circa 2002 with

Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.com7tag:blogger.com,1999:blog-8467396942183518214.post-35569500373876563202008-01-10T06:00:00.003-05:002009-11-15T06:38:03.731-05:00

Treeviews 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 using VBA code, they're not part of Access and so aren't covered in the Access help (they're ActiveX controls), and they are often used with complex data, such as hierarchical relationships.I started

Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.com0tag:blogger.com,1999:blog-8467396942183518214.post-65978932923716379092008-01-08T06:00:00.015-05:002008-03-13T22:56:21.358-04:00

Subscribe 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 lot of folk have trouble getting started with them. Here's a simple working example from the code archive at www.UtterAccess.com. See more treeview posts on my blog.

Stephenhttps://www.blogger.com/profile/13190848153946763046noreply@blogger.com0