Using Common Dialog

[kmedgyes]

Hi,

Interestingly, it appears that Access provides no mechanism to get to any of the common dialogs in Windows, such as Save As etc., (except the printing common dialog).

What kinds of solutions are you using?

[charlotte]

I've seen workarounds that involve setting a reference to the object library of one of the Office apps that does allow access to the common dialog, however, I use a class wrapper for the Windows api calls themselves. There is a common dialog control that comes licensed with the Office Developer edition, but ActiveX controls carry their own problems with them and the api calls are cleaner.

[kmedgyes]

Thanks Charlotte. The Office solution appears to be undocumented and may not be around the next time.
I was able to locate class wrapper that works and makes life a lot easier.
PS. Frankly, I expected to get a lot more activity for this post, but then again, maybe you said it all! [img]/w3timages/icons/smile.gif[/img]