File Dialog application fail

[Jack]

Dear friends,

I have a problem on running a code of FileDialog in my access runtime. The
code run well in the MS Access Program. After deploying the program to an
access runtime, this application was failed. The error message shown was that
"Method 'FileDialog' of object '_application failed". I think the application
library (MS office 10.0) is missing, but I am not sure. How can I resolve
this problem.

Thanks a lot

Jack

 

[Allen Browne]

The FileDialog object is provided by the Office library, which (as you
found) does not work with the runtime. It also does not work for Save As,
even in the full Access.

Use the API call instead. Details:
http://www.mvps.org/access/api/api0001.htm

 

[jack]

Thanks a lot

Allen

Regards,
Jack

The FileDialog object is provided by the Office library, which (as you
found) does not work with the runtime. It also does not work for Save As,
even in the full Access.

Use the API call instead. Details:
http://www.mvps.org/access/api/api0001.htm