Error Adding MS Common Dialog Box

[Mark]

I'm trying to add the MS Common Dialog Box to my form, and
I get this error message that says "You don't have the
license required to use this Active X control."

Why am I getting this? I never used to prior to install
SP3 for my Office 2000 Pro. version of Access.

Any suggestions would be appreciated. Thanks

Mark

 

[Douglas J. Steele]

If you're using it for the Windows File Open/File Save dialog, drop the
control, and call the API directly. You'll find it's far less problematic.

See http://www.mvps.org/access/api/api0001.htm at "The Access Web" for
sample code.

 

[Luiz Cláudio]

....or, if you work with Office XP or 2003, you can use FileDialog object.

Dim fd As Office.FileDialog
Dim strArq As String

Set fd = Application.FileDialog(msoFileDialogFilePicker)
fd.Title = "Your title"
fd.AllowMultiSelect = False
fd.Filters.Add "image files", "*.bmp;*.jpg;*.jpeg"
If fd.Show = -1 Then
strArq = fd.SelectedItems(1)
End If

Luiz Cláudio C. V. Rocha
São Paulo - Brazil