list files in specific folder?

[deBassMan via AccessMonster.com]

HI all

Access2K/2003, Win XP Pro

I need to be able to:

list all files in a spcific folder.(I'd like to perhaps send a folder name
as an argument)
The files should be 'clickable' and open with their associated app.
The user should not be able to navigate away from the specified foder.

all ideas gratefully received

cheers

 

[Allen Browne]

See:
List files recursively
at:
http://allenbrowne.com/ser-59.html

The code shows you how to list the files with options for:
- starting folder (path);
- file spec (e.g. only show zip files);
- subfolders too if you wish.
And it can load them into a list box.

From there, you could use FollowHyperlink to open the files, e.g. in the
double-click event of the list box.

Or, if you want something more powerful, use ShellExecute to open them:
http://www.mvps.org/access/api/api0018.htm

 

[deBassMan via AccessMonster.com]

Thanks Allen

I've cracked it now

cheers

See:
List files recursively
at:
http://allenbrowne.com/ser-59.html

The code shows you how to list the files with options for:
- starting folder (path);
- file spec (e.g. only show zip files);
- subfolders too if you wish.
And it can load them into a list box.

From there, you could use FollowHyperlink to open the files, e.g. in the
double-click event of the list box.

Or, if you want something more powerful, use ShellExecute to open them:
http://www.mvps.org/access/api/api0018.htm

Access2K/2003, Win XP Pro

[quoted text clipped - 4 lines]

The files should be 'clickable' and open with their associated app.
The user should not be able to navigate away from the specified foder.