Browse to a folder, not a file

[M Skabialka]

I am trying to automate a procedure to browse to a folder and the folder
name is then put in a text box for other functions to run. Those functions
work OK but I can't get the browse window to start in a specified folder -
it always starts at the root folder. The function I use is
SHBrowseForFolder.

I have found functions fGetBaseFileName and LaunchCD but they return a file
name, I only want a folder name.

Is there a function which will do this - browse to a certain default folder
then allow the user to select the subfolder they need (or browse anywhere
else)?

Mich

 

[Douglas J. Steele]

Check http://www.mvps.org/access/api/api0002.htm at "The Access Web"

 

[Dirk Goldgar]

I am trying to automate a procedure to browse to a folder and the folder
name is then put in a text box for other functions to run. Those functions
work OK but I can't get the browse window to start in a specified folder -
it always starts at the root folder. The function I use is
SHBrowseForFolder.

I have found functions fGetBaseFileName and LaunchCD but they return a
file name, I only want a folder name.

Is there a function which will do this - browse to a certain default
folder then allow the user to select the subfolder they need (or browse
anywhere else)?

I think this from Stephen Lebans is what you need:

http://www.lebans.com/callbackbrowser.htm
Functions to allow you to specify the opening folder to be
displayed when calling the Browser Folder Dialog window.

 

[M Skabialka]

This browses to a folder but starts at the root directory. How can it be
modified to start at a specified folder so the users only have to click once
to select the correct subfolder?

Mich

 

[Douglas J. Steele]

Follow the link from that page to what Stephen Lebans has at
http://www.lebans.com/callbackbrowser.htm

 

[M Skabialka]

Exactly what I needed - thank you.
Mich

I think this from Stephen Lebans is what you need:

http://www.lebans.com/callbackbrowser.htm
Functions to allow you to specify the opening folder to be
displayed when calling the Browser Folder Dialog window.


--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[M Skabialka]

This doesn't work if I set the folder to \\server01\folder\subfolder
I do this because users map the same folder to different drive letters...

Is there a work-around?
Mich

 

[Douglas J. Steele]

You can use the code in http://www.mvps.org/access/api/api0003.htm at "The
Access Web" to determine how each user's drives are mapped.

 

[M Skabialka]

Tricky - but it worked. I converted the UNC to a drive letter, did the
browse, then converted it back.
Thanks,
Mich

 

[hor vannara]

This doesn't work if I set the folder to \\server01\folder\subfolder
I do this because users map the same folder to different drive letters...

Is there a work-around?
Mich

 

[G Himangi]

If you dont mind a commercial control, also take a look at FolderView
control from Shell MegaPack at http://www.ssware.com/megapack.htm

It does all that you want and is a control so you can put in inside your
form intead of popping up a modal dialog.

-GH