
Help: Need dialog to select drive and directory path (not files)
I'm developing an Access 2.0 application where I need to display some sort
of dialog box that would allow the user to select the full path to where
certain files reside. So far, I've been able to dig up some sample code
for displaying a common file open, save, etc. box, but this naturally
includes the files list and filter, which I don't really want. Ideally,
I'd like to display a dialog that contains a drive selection box and a
folders (directory) list, and then capture the full path (including server
name) that the user selects.
I've developed a (hopefully temporary) solution using VB, but it's rather
clunky.I wrote a VB 3.0 app that simply displays a form with a drive list,
a
directorylist, an OK button and a Cancel button - when OK is clicked, the
current
path is written to a file and the app shuts down. My Access app contains a
procedure that shells to the VB app, waits for the app to close, and then
reads the path from the file created by the VB app. While this works, I
don't like it because it's kind of messy to implement and maintain.
Is there a way to do what I want in Access? Any tips (or sample code!)
would be greatly appreciated.
Thanks,
Sue