All User to Set Their Own Data Path

[cforput]

I am building an application and want to build an interface where the user can use an "explorer" type GUI to select where they want their data to be stored.

Any ideas? I am a complete novice so put it in plain english if you can!

thanks
Craig

 

[mp9]

Search Access VBA Help for FileDialog object for syntax and examples of how to use Windows' standard dialog boxes - this may give you what you're after.

Alternatively, you may wish to explore TreeView and ListBox controls if you want to mimic an Explorer-style interface in you app.

 

[cforput]

Thanks for the tip. On the treadmill right now reading your response and did a quick search in Access VBA. FileDialog looks like it will do the trick. I will try today at work and see how it goes. Thanks again!