Common Dialog Object Reference...
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Could somebody kindly tell me what the object reference in Microsoft Access is for the Common Dialog box for the Open File Dialog? The code that I have is as follows:
Private Sub cmdOutputFilePath_Click()
'The error message is a compiler error stating 'User-defined type not defined'Dim dlgLoadOutputFilePath As FileDialog Set dlgLoadOutputFilePath = Application.FileDialog( \_ FileDialogType:=msoFileDialogOpen) With dlgLoadOutputFilePath .AllowMultiSelect = False .Show
End With
If txtInputFilePath.Value = Null Then txtOutputFilePath = "" txtInputFilePath.SetFocus Else prgProgressBar.Value = 20 txtMessageBoxText.SetFocus txtMessageBoxText.Text = "" End If
End Sub
:confused::confused::confused: