Hyperlink

How can I link to a folder and not to a file in either
ACCESS or Excel? The folder contains subfolders with
different kinds of files. I would like the user to be
able to click a button in the form and be directed to the
folder. From there, he can choose which subfolder or file
he wants to open.

Try using the standard Windows File Open/Save dialog box. The following link
is to a code which includes a wrapper function to the standard Windows APIs.
There is a optional parameter in the function named InitialDir and its use
is demonstrated in the accompanying test function:

http://www.mvps.org/access/api/api0001.htm

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

aurora wrote:
How can I link to a folder and not to a file in either
ACCESS or Excel? The folder contains subfolders with
different kinds of files. I would like the user to be
able to click a button in the form and be directed to the
folder. From there, he can choose which subfolder or file
he wants to open.