Creating a folder select dialog in Access VBA
Posted on 2005-05-11
I simply need to create a "folder selection dialog" in Access XP (2002). Functionality is more important than looks.
I've tried several approaches but they all seem to mainly use the Application.FileDialog which is if I "get it" is really just calling the common dialog for selecting a "file" not a "folder".
In this case we would like to just select a "home folder" which could be empty and contain no files.
Optionally, it would ideally also provide for the basic ADD FODLER (folder icon with an asterisk on the corner) to create a folder if they wished. This exists on the common dialog file picker dialog already.
I apologize for not offering more points but I am new and this was all they provide at first.