FileDialog control not found

[LadyReader]

I have an Access2003 db that was converted from an Access2000 db. I would like to add a FileDialog control to a form but I don't see it in the Toolbox.

I added a reference to Miscrosoft Office 11.0 Objects. What more must I do?

Than you.

[sierra7]

Hi
You need Microsoft Common Dialogue Control, which is an Actixe X component that ships with VB or other Developer tools. I don't think it is a part of Access

The file to look for is;- cmdlg32.ocx

S7

[ADezii]

I have an Access2003 db that was converted from an Access2000 db. I would like to add a FileDialog control to a form but I don't see it in the Toolbox.

I added a reference to Miscrosoft Office 11.0 Objects. What more must I do?

Than you.

If you are referring to the Microsoft Office File Dialog, which is shared by all Office Components, make the Reference as you already did, and write similar code to that below:

'First, set a Reference to the Microsoft Office XX.X Object Library
 
Dim strButtonCaption As String, strDialogTitle As String
Dim strHyperlinkFile As String
 
'Define your own Captions if necessary
strButtonCaption = "Save Hyperlink"
strDialogTitle = "Select File to Create Hyperlink to"
 
With Application.FileDialog(msoFileDialogFilePicker)
  With .Filters
    .Clear
    .Add "All Files", "*.*"     'Allow ALL File types
  End With
  'The Show Method returns True if 1 or more files are selected
    .AllowMultiSelect = False       'Critical Line
    .FilterIndex = 1 'Database files
    .ButtonName = strButtonCaption
    .InitialFileName = vbNullString
    .InitialView = msoFileDialogViewDetails     'Detailed View
    .Title = strDialogTitle
  If .Show Then
    For Each varItem In .SelectedItems 'There will only be 1
      'Caption and Address of Hyperlink will be the same (Caption#Address)
      strHyperlinkFile = varItem & "#" & varItem
        Me![Link] = strHyperlinkFile
    Next varItem
  End If
End With

[sierra7]

If you are referring to the Microsoft Office File Dialog, which is shared by all Office Components, make the Reference as you already did, and write similar code to that below:

Wow, that's far better than using the OCX which may not exist on every user's computer.
Thanks ADezii

[ADezii]

Wow, that's far better than using the OCX which may not exist on every user's computer.
Thanks ADezii

You are quite welcome, the code that I gave you is just a guideline, but it does list several Options for the File Dialog.