Thursday, November 21, 2013

Using a file dialog box in Access 2010

When installing a "Microsoft Common Dialog Control 6.0" in an Access 2010 form, I receive the error "You don't have the license required to use this ActiveX control".

Apparently the ActiveX controls have a lot of new limitations for security reasons in Access 2010.

To work around this, I dimenioned the control directly in the code as follows:

Dim f As FileDialog
Set f = Application.FileDialog(msoFileDialogFilePicker)
MsgBox "file choose was " & f.SelectedItems(1)

When doing this, make sure to add "Microsoft Office 14.0 Object Library" to the references.

No comments:

Post a Comment

Checkmark in Office Products

 Font: Wingding, ALT 0525: &#x2713 Note that the Unicode for that to be able to see it in HTML is  &#x2713 Note that the Blogger...