How can I do explanding folders like Explorer does?

D

Dennis

All,

I'm on Access via Xp Office Pro w SP3 on XP PRo w SP3.

Is there a way to do or simulate expanding folders like Window Explorer does
in the directory pane? For example:

+ Documents and Settings
+ Program Files

expands to:

- Documents and Settings
+ All User
+ Owner
+ Program Files

expands to

- Documents and Settings
+ All User
- Owner
+ Application Data
+ Desktop
+ My Documents
+ Other
+ Program Files

expands to
- Documents and Settings
+ All User
- Owner
+ Application Data
+ Desktop
+ My Documents
- Other
Data file 1
Data file 2
etc. .....
+ Program Files


I don't want to create another Window Explorer, but I want the expanding
folder capability.

I'm trying to organize documents into a "folder" or "binder" with tabs and
sub-tabs. The folders / binder would for a customer, a project, a vendor, or
marketing effort, or something like that. Within the binder, there would be
user defined tabs and sub-tabs. The purpose of this is to let the user
organize Word, Excel, PowerPoint, web pages, images, audio, or other data
files into an electronic Binder. The user would be able to browse the
electronic binder via Access, pick the document in which they are interested
and click on it. Access would then launch the associated application and the
user specified document.

I have the table layout done and have a plan for dealing with the rest of
the software, but I would like a little advice on how to build the expanding
folder.

I don't know if Access supports this directly or if I'm going to have to use
sub-forms within sub-forms. I'm thinking that I could do this with a
sub-form by making the sub-sub-form visible and not visible.

Also, I would like to be able to create these sub-forms on the fly because I
don't know how deep I will have to go (I'm aware of the 12 or 13 sub-form
limitations). I don't know if this is possible. I could predefine the 12
levels of subform and then only make visibles the ones I want.

Any suggestions would be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top