How do I get the open dialog box in Access?

[Linn Kubler]

Hi,

I'm trying to write a macro in Access 2002 that opens the open file dialog
box. The example I found in the online help doesn't work for me, I get an
error when I try to use it.

The example has me define a variable as a FileDialog type like this:
Dim dlgOpen As FileDialog

But when I run the macro I get an error that states:
"User-defined type not defined."
And it points to "FileDialog". I would have thought this was a built in
type if they are going to use it in an example.

Any suggestions?

Thanks in advance,
Linn

 

[Ken Snell [MVP]]

FileDialog is available in ACCESS 2002 and higher. But it's a member of the
Office library, and is not native to ACCESS library.

It's a bit buggy, though, so you're better off using API call. See The
ACCESS Web for example code:
http://www.mvps.org/access/api/api0001.htm

 

[Linn Kubler]

Hi Ken,

At least that example seems to work. Would have thought there would be a
simpler method but this should work. Thanks for the info.
Linn