Microsoft Common Dialog Control Problem 1

[cbd]

I am trying to use an activeX control-Mircosoft Common Dialog Control- to use a Browse button to Open and Save files?, like in faq181-152. Unfortunately I keep getting an error that I don't have the license required to use this component. Does anybody know why or how I can get a license? If not does anybody know of another way to use a Browse button to Open and Save files?

 

[Guest_imported]

There are two versions of ActiveX controls.. A design-time license and a runtime license. If you don't have the Office Developer Edition or any other development package such as Visual Basic installed on the computer that you're developing your application on, then you don't have a design-time license for the control. Take a look at Microsoft Technet articles "How to Resolve Reference Issues in an Access Database [Q310803]" and "ActiveX Controls Installed by MS Access, ODE, and Others [Q179117]" for more information on the issue.
My preference for ActiveX controls is not to use them if possible. You can get exactly the same common file dialog control and functionality by using the Windows API. See a very good example at

http://www.mvps.org/access/api/api0001.htm.

Hth,
Tweetldee

 

[cbd]

Thanks Tweetldee. I realised after I wrote the post that I needed a development package but I couldn't find an alternative to using ActiveX. I'll try out the windows API example you suggested.

Thanks,
cbd