Mark "Pseudo Access Expert"

[Michelle]

Mark,
Sorry to bug you again, especially after being chastised.

I am having problems with my picture upload on a
particular jpg. Others seem to work, so I don't know if
there is something wrong with this picture or the code.

When I try to upload it, I get run-time error '2114'
Access doesn't support the format of the
file 'C:\\ThePath\Dog1.jpg' so it can't load the picture

1) If IsNull(Me.ImagePath) Then
2) Me.ImagePicture.Picture = ""
Else
3) Me.ImagePicture.Picture = Me.ImagePath
End If

1) Me.ImagePath="C:\\ThePath\Dog1.jpg
2) Me.ImagePicture.Picture = "(none)"
3) Me.ImagePicture.Picture = "(none)"

So the code knows that it's not null (1), yet
assigns "(none)" to it, doesn't upload the picture,
freezes up, I close Access, reopen it and it goes straight
into debug.

Null, "", "(none)"...
Bad file, bad code, bad karma?
Thanks, Michelle

 

[SteveS]

Mark,
Sorry to bug you again, especially after being chastised.

I am having problems with my picture upload on a
particular jpg. Others seem to work, so I don't know if
there is something wrong with this picture or the code.

When I try to upload it, I get run-time error '2114'
Access doesn't support the format of the
file 'C:\\ThePath\Dog1.jpg' so it can't load the picture

1) If IsNull(Me.ImagePath) Then
2) Me.ImagePicture.Picture = ""
Else
3) Me.ImagePicture.Picture = Me.ImagePath
End If

1) Me.ImagePath="C:\\ThePath\Dog1.jpg
2) Me.ImagePicture.Picture = "(none)"
3) Me.ImagePicture.Picture = "(none)"

So the code knows that it's not null (1), yet
assigns "(none)" to it, doesn't upload the picture,
freezes up, I close Access, reopen it and it goes straight
into debug.

Null, "", "(none)"...
Bad file, bad code, bad karma?
Thanks, Michelle

PMFJI, but.....

Since the code seems to work for the other pictures, I would rule out a
problem with the code.

Can you open the picture using MS Photo Editor (or any viewer)? If it
opens, then it is not a problem with the jpeg.

Does all of the other paths begin with "C:\\". Fondly remembering my DOS
days, I would think the path should be

"C:\ThePath\Dog1.jpg"

with only one backslash after the colon.

HTH

 

[Michelle]

Thanks for the reply- I've only had problems with this
picture so I'm going to call it good as all of the other
jpgs are OK. My path was correct by my typing skills not
so good. Thanks, Mich