Access 2007 version of common dialog

[Guest]

Hello

What is the access 2007 version of the common dialog control from earlier
versions. I need to open a dialog which lets a user select a folder from
like the file open on the office applications.

 

[Allen Browne]

Use the API call.

To select a file:
http://www.mvps.org/access/api/api0001.htm
of a folder:
http://www.mvps.org/access/api/api0002.htm

If you have never used this kind of thing, it can look a bit daunting, but
honestly it is the best solution in any version of Access. The FileDialog
object had problems: it was unreliable with some file types, library
dependent, didn't work in runtime, and didn't work at all for Save As (even
though it appeared to offer that option.) Likewise, the common dialog
control (in runtime/earlier versions) was buggy and had registry/reference
issues, so the API call has always been the reliable approach.