Retrieving just the Folder name using Common Dialog

[JWS315]

I have converted my code to use the WINAPI calls to display the Open and Save
As dialogs for use with my Access 2003 FE/BE database, it works great.
However I want to be able to have the user just select a folder and be able
to pass the information to my code. I have tried using the lpstrInitialDir
but it does not give me the full path/folder name when I am connecting to a
network folder.

Any suggestions would be greatly appreciated!

John

 

[Brian]

I have converted my code to use the WINAPI calls to display the Open and Save
As dialogs for use with my Access 2003 FE/BE database, it works great.
However I want to be able to have the user just select a folder and be able
to pass the information to my code. I have tried using the lpstrInitialDir
but it does not give me the full path/folder name when I am connecting to a
network folder.

Any suggestions would be greatly appreciated!

John

There's lots of code for dedicated Browse Folder dialogs here:

www.planetsourcecode.com

or here:

http://www.freevbcode.com/searchresults.asp

It's mostly very easily converted from VB to VBA.

 

[Douglas J. Steele]

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