Show new pictures in image control

[Jean Van Harlingen]

I am trying to set up a form that will display pictures in an image control
based on the contents of a text box control that contains the path to the
external image file. In design view I am able to access the external image
file, but when I try to change the picture property of the image control via
VBA I get an error message which says that access can't open the external
file.

This is the code I am using:

Dim Pf As String
If Not IsNull(Me.PictureFile) Then
Pf = (Me.PictureFile)
Me!ActualImage.Picture = Pf
Else
Me!ActualImage.Picture = ""
End If

Any ideas???

 

[bob]

What path do you see in the error message?

If you’re trying to use a relative path then your code is making assumptions about the ‘current’ path –
see the following articles:

http://www.ammara.com/access_image_faq/image_relative_paths.html

http://www.ammara.com/access_image_faq/get_mdb_database_path.html

 

[Jean Van Harlingen]

The path is D:\jpg\filename.jpg - so no relative path

 

[bob]

I just tried your exact code (in the Form_Current event) using the same path and filename and it worked
for me. I can only suggest making absolutely sure that the path is correct, and try opening the image
in a graphics app to verify the image is ok (try copying the path from the table then pasting it in the
app's file-open dialog).



--
_______________________________________________________
DBPix 2.0: Add pictures to Access, Easily & Efficiently
http://www.ammara.com/dbpix/access.html

 

[Jean Van Harlingen]

Ahhh there was a space in the filename I didn't see - works great now.
Thanks for the help!