Windows explorer

  • Thread starter Thread starter Bill
  • Start date Start date
B

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.
 
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.
 
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.
 
Back
Top