Display Image in Form

[John R. Youngman]

Hi. I'm using Access 97 to set up an employee form that includes the
employee picture. I have a table with an ole object for the picture field,
and the form has a bound object frame to display the picture.

After entering pictures in the table, the picture field says "package" and
the form field displays a bitmap icon with the image file name.

I cannot get the form to display the picture--just the icon. I can double
click the icon, which loads IE and then displays the image. But I can't get
the form to show any image!

What am I missing??

TIA

John

[John R. Youngman]

Hi. I'm using Access 97 to set up an employee form that includes the

employee's picture. I have a table with an ole object for the picture

[Kurtis Smith]

Hello John

Thank You for using Microsoft Access Newsgroups

My name is Kurtis and I will be assisting you today.

I am not clear if your images are bitmaps or jpg's, but I think they are
Bitmaps based on your information.

The issue here is that the default file association for the image must be
to a program that is an Automation OLE Server.
For Bitmap images that is MS Paint.
For JPG's we recommend Microsoft Photo Editor (Ships with Office 2000)

What you need to do is make sure that MS Paint is the default program to
open Bitmaps with.
Sometimes, just changing the Open with option in the file associations
dialog box does not work. There is a Knowledge Base article called Q177587
"OLE Object inserted into an object fram displays as icon"
Here is the URL to view this article on the web.
http://support.microsoft.com/support/kb/articles/q177/5/87.asp
Follow the directions in this article to resolve this issue if your images
are Bitmaps.

If you images are JPG's the best Program to use is Microsoft Photo Editor
for JPG's
There is also a Knowledge Base article on this problem with JPG's, it is
Q258644 "A linked JPEG file is displayed as an icon on a form"
Here is the URL for this article
http://support.microsoft.com/support/kb/articles/q258/6/44.asp
Follow the directions in this article if your images are JPG's.

One other thing to keep in mind. When embedding images in your Access
database, depending on how many images, your database is going to grow in
size very fast.
If you are going to have a lot of images you may want to consider an
alternative method which does not store the images in the database, it just
displays them from a folder on the hard drive. The catch here is if you
move the database to another machine, the images in the folders must also
be moved to the same location on the new computer.

There is a Knowledge Base article that discusses how to do this, it is
Q210100 "How to display an image from a folder on a form"
Here is the URL for this article
http://support.microsoft.com/support/kb/articles/q210/1/00.asp

I hope this helps

Thank You

Kurtis Smith A+, MCP
Microsoft Access Newsgroup Support

[Exponent]

One simple possibility that avoids many of the problems of using the standard 'OLE Object' approach is to
use our bound image control, DBPix. You can simply bind the control to the relevant field like a normal
control and write a line or two of code to load images from the filesystem, clipboard or a digital camera/scanner.
It doesn't suffer from the common 'OLE Bloat' issue (which can cause compressed images to take up 10-times
the space or more in the database file) or from problems with the associated OLE Server application.
Additionally it can be configured to automatically resample images as they are loaded, which avoids storing
unnecessary resolution (reducing storage and improving performance) or can also be used to create thumbnails.
You can also publish the database on a web-server to avoid all configuration isses for clients.

If this is of interest you can download the control, documentation and samples from http://www.ammara.com