Web Development

Ask something
Discussion Locked

+ and - expansion list controls

0 helpful
5 replies

by donq 2 views

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am creating a database software application using Microsoft Access 2000 and would like to construct a list box (SelectionList) on a form (MyForm) to display expansion +/- boxes like on-line Help says a Pivot Table will display. (much like the Explorer Window displays a computers directory and file hierarchy)

My list box is based on a 4 level query that is normalized and produces the correct record set. How do I permanently add this functionality (tool) into my Access development environment? Is it an ActiveX Control ? or what? Help explains I should click on the Toolbar ?Property Toolbox? and select the ?Show / Hide? bar ?Expansion Indicators?.

Where can I find (and/or download) these elusive little devils? Enter ?Hierarchy List? into the ?What would you like to do?? Access Help window and click Search to see what I get. I do not want to involve Excel (exports an imports ? or links) unless absolutely necessary.

Thanks for your Help ? Don Quigg

5 replies

by mark.thomson

Just off the top of my head try creating a data sheet form based on your query and then include that as a subform on your main form

by donq

Thanks Mark but your answer doesn't have anything to do with my question.

by peyison

Hey Don,

How's it going? By the way - I plan to spend some time this weekend going over things.

Anyway - Sounds like what you're looking for is a Tree View control. I did the search in Access help as you described and from what I can gather their solution does require a link to Excel.

There are several Tree View controls available, but I don't know how well or even if they work in Access. The one I like is from Sheridan - now Infragistics, called Active Tree View. There is also one that ships with VB6, if you have that. I will test Active Tree View in Access and let you know how it goes.

Hope all is well. Keep the points.

Mike

by donq

Thanks Mike, I'm converting BNM to a "stand alone" ActiveX component. It lies at the heart of my work.

This discussion is closed to new replies.