Launch a Windows folder from within the .mdb

[Kevin Dahlke]

Hi,

I am planning digital document storage. 100's of clients, and several sub
folders within each client folder.

Using Access 97 and Win 98 SE my plan was to create a field in the client
tbl to hold the string to be
used a part of the path to call the directory so that the filtered Win
folder opens on the desktop independent of Access.

The goal is to be able to double click to launch the file in its related
application (.pdf) without having to page through volumes of folders, would
not require the creation of hyperlinks or any house keeping if the file is
removed or renamed for any reason etc.

So I need to know if VBA will accept a string in this manner and if it can
open the folder. There would be no need to close as Win98 can handle that.

Has anyone coded anything similar to this? I was planning to attach it to a
cmd btn.

Thanks for any help.

Kevin

 

[John Nurick]

Hi Kevin,

Probably the simplest way to do it is with the HyperlinkAddress property
of a command button. In the form's Current event, use something like

Me.cmdOpenFolder.HyperlinkAddress = Nz(Me.txtRootFolder.Value, "")

where cmdOpenFolder is the button and txtRootFolder is the textbox that
displays the folder in question.

Hi,

I am planning digital document storage. 100's of clients, and several sub
folders within each client folder.

Using Access 97 and Win 98 SE my plan was to create a field in the client
tbl to hold the string to be
used a part of the path to call the directory so that the filtered Win
folder opens on the desktop independent of Access.

The goal is to be able to double click to launch the file in its related
application (.pdf) without having to page through volumes of folders, would
not require the creation of hyperlinks or any house keeping if the file is
removed or renamed for any reason etc.

So I need to know if VBA will accept a string in this manner and if it can
open the folder. There would be no need to close as Win98 can handle that.

Has anyone coded anything similar to this? I was planning to attach it to a
cmd btn.

Thanks for any help.

Kevin

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.