Windows explorer

[Bill]

I use a hyperlink string and assign it to a command button
to open a specific folder over a network. Is there a
better way to do this?

Problems occur when folders are moved from one source to
another.

 

[GVaught]

Regardless of how you connect a hyperlink to the source document's location,
you will still have the same problem if the source file is moved. It's a
fact of life anywhere. You may be able to write some VBA code to check if
the source document exists in a particular location and if not prompt the
user with the browse dialog box to go find it. Unfortunately, I don't have
any code to do this, but I'm sure one of the MVP's may have or will point
you in the right direction.

 

[Van T. Dinh]

Not sure whether it is better or not but you can use:

Shell "Explorer.exe ""Drive/PathName""",vbNormalFocus

Regardless what you do, if the Folder is moved, Access / VBA needs you /
someone to tell it the particular folder you want to open.

You can use code from The Access Web article:

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

for you/the user to specify the Folder to open before my posted code above
to specify the Drive/PathName to open.