Call the standard Windows File Open/Save dialog box

[Andy G]

How do I call the standard Windows File Open/Save dialog box from an A2003
form?

I tried using the http://www.mvps.org/access/api/api0001.htm but quit when
it killed some wizard functions in Access (add button wizard; don't know
why).

Thanks smart people.

 

[Dirk Goldgar]

How do I call the standard Windows File Open/Save dialog box from an
A2003 form?

I tried using the http://www.mvps.org/access/api/api0001.htm but quit
when it killed some wizard functions in Access (add button wizard;
don't know why).

I've never heard of that code causing any problem such as you describe,
and it's been used by a lot of people. Maybe with more details we could
figure out what happened and fix it.

Alternatively, with Access 2003 you can use the built-in
Application.FileDialog object to display the File Open dialog. You
can't use it to call the File Save dialog from Access, though, so if
that's what you need, the API solution is still your best bet.