msoFileDialogFilePicker: Variable Not Defined

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stapes - 30 Nov 2007 13:14 GMT

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

Reply to this Message

Stapes - 30 Nov 2007 13:41 GMT

> Hi
>
[quoted text clipped - 11 lines]
>
> 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

Reply to this Message

Douglas J. Steele - 30 Nov 2007 14:30 GMT

>> Hi
>>
[quoted text clipped - 13 lines]
> 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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

Reply to this Message

Stapes - 30 Nov 2007 16:30 GMT

On 30 Nov, 14:30, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com> wrote:

> >> Hi
>
[quoted text clipped - 22 lines]
>
> - Show quoted text -

Done

Reply to this Message