Folder Picker?

Guest · Mar 23, 2004

I'm familiar with the VB/VBA common dialog control. However, I need some way for the user to select JUST a folder, not a specific file. I need this so the user can select a destination for Access to export information to. In other projects where I've had this type of problem, I bastardized the common dialog box by making the user pick any file in the desired destination folder, and then peeling off the file name and using that

However, there's got to be a control somewhere that lets the user browse to a folder and returns the path of the selected folder....right

I'm in Access 2000 and I can't download/install any controls that don't come as part of Access.

Cheryl Fischer · Mar 23, 2004

Here is a link which allows you to do this in code:

http://www.mvps.org/access/api/api0002.htm

hth,

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

MDW said:
I'm familiar with the VB/VBA common dialog control. However, I need some

way for the user to select JUST a folder, not a specific file. I need this
so the user can select a destination for Access to export information to. In
other projects where I've had this type of problem, I bastardized the common
dialog box by making the user pick any file in the desired destination
folder, and then peeling off the file name and using that.

However, there's got to be a control somewhere that lets the user browse

to a folder and returns the path of the selected folder....right?

I'm in Access 2000 and I can't download/install any controls that don't

come as part of Access.

Allen Browne · Mar 23, 2004

Use the API call here:
http://www.mvps.org/access/api/api0002.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.