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.comBlogger8125tag: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-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-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-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.com3