msoFileDialogFilePicker: Variable Not Defined

[Stapes]

Hi

Why won't this work?
I have already got Microsoft Access 11.0 Object Library ticked.

Dim strFileName As String
With Application.FileDialog(msoFileDialogFilePicker)
.AllowMultiSelect = False
.Show
strFileName = .SelectedItems(1)
End With


Me.FilePathField.Value = strFileName

Stapes

 

[Stapes]

Hi

Why won't this work?
I have already got Microsoft Access 11.0 Object Library ticked.

Dim strFileName As String
With Application.FileDialog(msoFileDialogFilePicker)
.AllowMultiSelect = False
.Show
strFileName = .SelectedItems(1)
End With

Me.FilePathField.Value = strFileName

Stapes

I am trying to let my user browse & select a filename for a picture
file. The filename will be stored in the field FilePathField, and a
View Photo button added to display the picture.

Stapes

 

[Douglas J. Steele]

I am trying to let my user browse & select a filename for a picture
file. The filename will be stored in the field FilePathField, and a
View Photo button added to display the picture.

You're far better off using the API code in
http://www.mvps.org/access/api/api0001.htm at "The Access Web". There are
problems with the File Dialog.

 

[Stapes]

You're far better off using the API code inhttp://www.mvps.org/access/api/api0001.htmat "The Access Web". There are
problems with the File Dialog.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)- Hide quoted text -

- Show quoted text -

Done