Mark "Pseudo Access Expert"

  • Thread starter Thread starter Michelle
  • Start date Start date
M

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
 
Michelle said:
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
Click to expand...

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
 
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
 
Back
Top