vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

Smart Access
The Magazine that Access Developers loved to read and write for is back Read More

RSS & Newsletter
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More

Get Good Help
If you need help with a database, our Professionals could be the answer
Read More

Is Your Database Corrupt ?
If you have a corrupt database, Try our Access Recovery service

The Workbench Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, mde compile, shutdown database Read and Download

Access >>> SQL
Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query
translation and web form conversion.
Read More

The Toolbox
Libraries of software that we regularly import into our projects. This is a newer version of the Toolshed More..

SharePoint
For our company file sharing and task management, we use
SharePointHosting

Datamining/Graphs
Explore your data with this versatile graphing and data mining shareware tool. Read More

DryToast
Backup and query your BaseCampŽ projects
Read More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

Like FMS Products?
Purchase them from us and get a free Workbench or Toolbox More

Smart Access is Back
We have recently purchased exclusive rights to the Smart Access magazine

About The Editor Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia
Contact Us ...

Search ...

or try our new site built with SharePoint Designer
vb123.com.au

Treeview Control In Access 97

If you want to use a treeview control in Access 97, what does it look like ?

Figure 1 : This is the Treeview control for visual basic 5.

The information shown in figure 1 is drawn from 2 different datasources. The top of the heirachy is 2 fields from a consolidation query

Products and Count of rows

The second level is the detail rows from the original table where the link is on the product code. A number of fields are displayed here. The display is not really that great for this sort of table data but used wisely could be very informative.

If you think that you need this control, you need to download the Access 97 treeview wizard. Follow the instructions from this page to get the download. Without the wizard, this control is hard to setup. Here are the notes from the Microsoft download form.

"The WzTreevw.mde file is a Treeview Control Wizard for Microsoft Access 97. When you insert a Treeview Control on your form with this wizard installed, the wizard will guide you through configuring the Treeview Control. The appearance of the Treeview Control Wizard is similar to that of the Data Outline Control Wizard in Microsoft Access 7.0. The functionality of the Treeview Control is similar to that of the Data Outline Control in earlier versions of Microsoft Access. NOTE: The TreeView Control Wizard requires that you have the TreeView ActiveX Control, which is included with the Microsoft Office 97 Developer Edition Tools."

You may also need to download the registration tool from the same Access page. Before you get to carried away with this tool, you must test the installation of this tool on your clients databases.

Click for the next help page or try these other advanced pages

Other Pages On This Site
Microsoft FreeStuff

External References

Here is the direct link for the wizard download.