starting MS Explorer from MS Access

[DBinPhilly]

I need to find specific folders on our server based upon information within
an MS Access database. Specifically, I have a job number and wish to open a
shared job subdirectory within access to see any saved documents within that
job's subfolder.

 

[Ken Sheridan]

Most means of opening the file-open dialogue have a means of setting the
folder at which the dialogue opens. One I use commonly is Bill Wilson's
BrowseForFileClass class module from:


http://community.netscape.com/n/pfx...yMessages&tsn=1&tid=22415&webtag=ws-msdevapps


The class has an InitialDir property to which you simply assign the path to
the folder as a string expression, which you can build from your job number,
e.g.

Dim OpenDlg As New BrowseForFileClass
Dim strPath as String

OpenDlg.InitialDir = "\\MyServer\MyFolder\MyJobs\" & Me.JobNumber

strPath = OpenDlg.GetFileSpec

Note that the dialogue does not itself open a file, just returns the path to
whatever file you select. You can then use the returned path in whatever way
you wish, or not at all if you merely want to see the list of files without
taking any further action via the code.

Ken Sheridan
Stafford, England