Problem with JPG Images

[Ashby]

Hello Everyone,

I have an Access 97 database which has our client photos.
The photos are stored on the server not in the database.
I link the photos to the form using an image control. The
code is in the on current event.

Here is the problem: The photos are in jpg format. When
I go to the first record the photo will display correctly,
all other record showing nothing. Does Access have a
problem with jpg files? The same does not happen with bmp
files.

 

[Bradley C. Hammerstrom]

I am using 2000, but I am sure 97 will do as you wish.

This is the code I use in the OnCurrent event:
'This line loads the Photo
Me.Parent![imgPhoto].Picture = Me![FilePath] & Me![FileName]
(This is on a subform. imgPhoto is on the main form.)

You didn't mention the path. Check to see if you are including it. Keep in
mind that Volume names are irrelevant since Access only sees Drive letters.

Does that help?

Brad H.