VBA Explorer Folder List

[CrackerBoy]

I'm using code that was originally written by Terry Kreft and modified by Dev Ashish. The database they have is called "Explorer" and it can be found here:

http://www.mvps.org/access/resources/downloads.htm

I'm trying to modify it so that it only show's 'mypath' in the folders list 'lbxFolders'. I don't want it to go into any folder above 'mypath' but I still want to be able to access the folders and files within 'mypath'.

Any suggestions?

 

[jedraw]

See

http://allenbrowne.com/ser-59.html

for other techniques

Do a search on FilePicker for another method.

http://support.microsoft.com/kb/288543

Are you working with ACC97?

 

[CrackerBoy]

I'm using an ACC97 db converted to 2010.

I've seen the allen browne file list before, but I like the look of the "explorer" and the functionality of it better.

What I'm trying to do is have the files for a project be easily accessible from access. We track all our projects and hours in access and it would be nice to have quick access to all the project information. Currently I just have a hyperlink to the network folder