Common Dialogue Control

[BRC]

Hello All,
I hope this has a simple answer.
I want to use the Common Dialogue Control (comdlg32.ocx)
to get the file open/save dialogue box.
I keep getting the error message that I don't have the
required license. I thought this was part of Access?
What am I missing (other than my mind)?
Thanks in advance,

BRC

 

[Allen Browne]

The Common Dialog Control is not installed as part of Access.
It has been included in some of the Access/Office Developers' Toolkits.

However, you are better off without it. It's buggy, and prone to broken
reference issues.

Instead use this code to execute an API call:
http://www.mvps.org/access/api/api0001.htm
If you have never used an API call, that may look a little scary, but it's
really just a matter of pasting the code into a standard module (not your
form's module), and then calling it from wherever you need it. It is simple,
stable, works for Open or Save, works with any version of Access, works with
MDE/runtime, and requires no extra References.

There is a FileDialog object in Access 2002 and 2003, but it requires a
reference to the Office library, does not work with earlier versions, does
not work with MDE/runtime, and the SaveAs option (which it appears to offer)
does not work at all.

 

[BRC]

Thanks Allen,
Funny you should point me to the Access Web.
I just found it and it is wealth of information.
Thanks for your assistance.

BRC