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 Next Tip for the next help page or try these other advanced pages

Other Pages On This Site
Microsoft FreeStuff

 

Our Tools and Resources

  • RSS & Newsletter Here
    Join our newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics

  • Smart Access is online 
    The best magazine written about Microsoft Access is now being transferred to the web. There are 400 articles written by a 100 authors in the collection. 

    See the Smart Access 2010 specials here

  • The Workbench
    Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, creation versions,  shutdown database

  • Read about the Toolbox
    Sample downloads, library resource kit and searchable help file comprising most of the information at vb123.com.au plus hidden downloads etc.

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

 

 

vb123 Professionals


Get Good Help Here

If you need help with a database or Office programming, our Professionals could be the answer because we have worked on many similar solutions


Frontpage Conversions
We have converted vb123.com to Expression Web, contact us if we can help you move to the latest Microsoft web tool.


About The Editor ~ Contact Us
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

Access 2003 Security

MS Access Security

Read More here