Displaying Image in Form

[John R. Youngman]

Hi. I'm using Access 97 (on Windows XP Pro) to display member photos in a
form. Only the "bmp" images display--the jpg, gif and tif image formats are
blank. I checked to make sure that the graphics filters were installed, but
still no images? Any ideas?

TIA

John

 

[Bruce M. Thompson]

Hi. I'm using Access 97 (on Windows XP Pro) to display member photos in a

form. Only the "bmp" images display--the jpg, gif and tif image formats are
blank. I checked to make sure that the graphics filters were installed, but
still no images? Any ideas?

It's possible that Stephen Lebans's website might have something that can help.
Particular reference is made to http://www.lebans.com/loadjpeggif.htm. Read the
warning on the use of the provided functions under Windows 98.

 

[Exponent]

Are you using an OLE Object field &/or bound OLE Frame ?
If so then the following may apply:

This is most commonly caused by not having MS Photo Editor (or other suitable OLE server application) installed
on the system and registered for the relevant file types.

But note that there can be significant drawbacks with this approach (quite apart from your users being
stuck with having this app associated with the file-types), usually the most serious of which is an overhead
of between 10 and 100 *times* the filesize for jpeg images (even when linking). To store compressed images
inside the database it is usually better to store only the raw binary data, or when working with external
image files just store the path and load the file into an Image Control.

 

[John R. Youngman]

Thanks, Bruce.

I downloaded the sample db from Leban's page--it displays jpg, gif and bmp
just fine. I guess that there's something wrong with my db because the same
images will not display. I checked the References and have the same items
checked and also have the same modules installed.

Any other ideas?

TIA.

John

 

[John R. Youngman]

The images are stored separately--not in the db. There's just a path
address to each image file in the table.

Thanks.

John

Are you using an OLE Object field &/or bound OLE Frame ?
If so then the following may apply:

This is most commonly caused by not having MS Photo Editor (or other

suitable OLE server application) installed

on the system and registered for the relevant file types.

But note that there can be significant drawbacks with this approach (quite apart from your users being
stuck with having this app associated with the file-types), usually the

most serious of which is an overhead

of between 10 and 100 *times* the filesize for jpeg images (even when

linking). To store compressed images

inside the database it is usually better to store only the raw binary

data, or when working with external

 

[Bruce M. Thompson]

I downloaded the sample db from Leban's page--it displays jpg, gif and bmp

just fine. I guess that there's something wrong with my db because the same
images will not display. I checked the References and have the same items
checked and also have the same modules installed.

If you are using the standard Image control and, in all other respects, you have
included all that is referenced in Stephen's sample project, then I would try
compacting your MDB and then creating a NEW form upon which you can try to
duplicate the technique implemented in Stephen's example. If it still won't
work, then your MDB might be corrupted in some way. You could then try creating
a new MDB and importing all the objects from this MDB and see if the problem
still exists (you'll need to double-check your references). If it works in
Stephen's sample database, then it's not Access or your graphic filters,
obviously, and I would suspect that there was something that you may have
overlooked in setting up your form or other aspect of the project. Try my
suggestions, or re-examine your file, and let us know how you make out.

 

[John R. Youngman]

Thanks, Bruce.

Now I'm totally baffled. I tested this photo db on a Win2000 system and it
works *perfectly*! I can run it directly from a server or load it onto the
2000 PC and it's fine. But when I try to run it locally or from the server
on my XP system, no picture.

Is there something unique about XP handling of images?

Thanks again.

John

 

[Bruce M. Thompson]

Thanks, Bruce.

Now I'm totally baffled. I tested this photo db on a Win2000 system and it
works *perfectly*! I can run it directly from a server or load it onto the
2000 PC and it's fine. But when I try to run it locally or from the server
on my XP system, no picture.

Is there something unique about XP handling of images?

I don't think so. I'm running WinXP Pro and it works fine. Besides, you said
that Stephen Lebans' sample db worked fine on your system, so I think there is a
difference between your project file setup and that of Stephen's sample db.

Does seem a little strange, though, doesn't it?

 

[Exponent]

Using the Access Image-Control, not a Bound OLE Frame ?

If so, then you're right that this should be down to graphics filters, not OLE servers. In which case
the only thing I could suggest is to remove and reinstall them, just in case the wrong versions are installed,
bad installation or something like that.