Make a form look like Windows Explorer

[modest]

I'm trying to make a custom Windows Explorer/File Browser in access. This is mainly because people at my work are old and are morons and they need something within the Access application.

Does anyone know of any API that I could use on a form? Please know that I don't want any popup windows... I know there are api calls to do file browsing that have an "Open File" dialog window. I want to be able to customize it and make everything the same color.

What I started doing is making my own images and using CreateControl() in combination with the FileSystemObject to create images and labels...this is good, however I can only create the form in design view. This means that if I have to do it this way, I'll have to prequery and each subfolder before the form is loaded (not what I have in mind), then design the form via code, then close it and reopen it.

If anyone has any suggestions.. let me know,
Modest

PS:
I might post what I have so far when I get to work next week.

 

[seth_belgium]

Found this on The Access Web:

Explorer.zip

 

[Oldsoftboss]

Now that is nifty.

 

[modest]

I know I could have used listboxes, but the point was to have a better GUI, with custom images and what not. Thank you for your demonstration seth - I guess I'll just have to settle with the listboxes

 

[modest]

The users see it all the time, they are used to it, and you don't have to spend time coding and testing it.

Pat, if that were true, I'd agree. However, users don't see it all the time (they're used to working with emulators). You would think they'd know, but I'm working with some people that are about as comuter-savvy as a 2 year old. Not to mention, I cannot have them viewing every file in the folder. Some of the data is sensitive material. To restrict their access I'd have to go through the LAN team and change user rights. I'd rather avoid all that and give myself some control.

My main dilemma is that controls must be created in design view. Which might have been okay for read-only folders because I could just create a new form at run time and add the controls for it in design view.

However, users are going to be adding files and will need a "refresh" or something. This means...argh.. I might have to make a whole new form using nothing but API programming.

 

[modest]

That's what i was going to look at on wed. since I've never had to use the tree view before. I still wish I could put my own personal touches on the form