Change folders on open or save

[Michael Daly]

I use the Common Dialog Control within my Access 97
program to allow the user to change "folders" to open or
save files. The trouble is it expects the user to select
files or enter a filename after they have moved folders.

I don't want the user to enter filenames, but just change
the folder (or create a folder) in the Explorer view, then
be able to click [Ok] or [Cancel].

Can you use the Common Dialog control to ONLY move between
folders, without the need to select or enter file names?
Are there other ways to do this without using the Common
Dialog control?

Thanks.

Michael Daly
19 Sept 2003

 

[Michael Daly]

Marsh

Thanks for such an excellent link. This code produces
exactly what I want to perform. Thanks again... Michael
Daly

-----Original Message-----

I use the Common Dialog Control within my Access 97
program to allow the user to change "folders" to open or
save files. The trouble is it expects the user to select
files or enter a filename after they have moved folders.

I don't want the user to enter filenames, but just change
the folder (or create a folder) in the Explorer view, then
be able to click [Ok] or [Cancel].

Can you use the Common Dialog control to ONLY move between
folders, without the need to select or enter file names?
Are there other ways to do this without using the Common
Dialog control?

I never use that control, it's got way too many issues going
against it.

A very popular way to do what you want is to use that code
at: http://www.mvps.org/access/api/api0002.htm