Folder Picker?

[Guest]

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]

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

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]

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.

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.