MS Common Dialog Control

[Peter]

Hi,

I am using Access 2000 and I attempt to add the MS Common Dialog Control
(Version 6.0) on a form.
However, it says that "You don't have the license to use this ActiveX
Control".
I would like to know how can I buy / obtain the license to do so ?

Thanks

 

[Alex White MCDBA MCSE]

Hi,

you don't need it use the API

Declare Function GetOpenFileName Lib "comdlg32.dll" Alias "GetOpenFileNameA"
(pOpenfilename As OPENFILENAME) As Long
Declare Function GetSaveFileName Lib "comdlg32.dll" Alias "GetSaveFileNameA"
(pOpenfilename As OPENFILENAME) As Long
Declare Function ChooseColor Lib "comdlg32.dll" Alias "ChooseColorA"
(pChoosecolor As CHOOSECOLORS) As Long
Declare Function CommDlgExtendedError Lib "comdlg32.dll" () As Long
Declare Function GetShortPathName Lib "kernel32" Alias "GetShortPathNameA"
(ByVal lpszLongPath As String, ByVal lpszShortPath As String, ByVal
cchBuffer As Long) As Long
Declare Function ChooseFont Lib "comdlg32.dll" Alias "ChooseFontA"
(pChoosefont As CHOOSEFONTS) As Long
Declare Function PrintDlg Lib "comdlg32.dll" Alias "PrintDlgA" (pPrintdlg As
PRINTDLGS) As Long


if you want some example code post back here and I will post it up.



Regards

 

[Tony Toews]

I am using Access 2000 and I attempt to add the MS Common Dialog Control
(Version 6.0) on a form.
However, it says that "You don't have the license to use this ActiveX
Control".

There could, likely will, be lots of version problems when you go to
distribute the common dialog OCX.. Instead use the common dialog API
calls as documented at the Access Web or the MS Knowledge Base.
Call the standard Windows File Open/Save dialog box
http://www.mvps.org/access/api/api0001.htm
"ACC97: How to Use the Common Dialog API in an Access Database"
http://support.microsoft.com/?kbid=303066
While the article is in A97 the same code will work in newer versions
of Access

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm