Access 2000 Forms: Inserting an image?

[NoGoodNamesLeft]

AAAARGGGGHHHHH!

Ok, now that’s out of my system…

Here’s my problem. I have a database that keeps track of club members. That database has a good form for entering the dat, and making changes.

However, I want to display a picture of the member with their profiel when I bring up the form (or a report fo that matter).

The image has to be that of the individual member, and change as I scroll through the memebrs in the db.

What I did was add a column to my table, and put links to my pictures in it. But when I try to show the omage in the form,
it gives me an icon instead. When I click the icon, it will open the picture in a new window.

The icons and their links all point to the right place, but I want to actually display that image there.

I checked the properties and it’s not checked under “display as icon”, and I made sure that was off when I added the data field to the form.

Can anyone PLEASE help?

[Starbury]

Here are the possible solutions I was able to find:

There is a connection somewhere between Access and MS Windows Paint program.
The very first image I inserted into my OLE field was a JPG image. Since MS
Paint can’t understand JPGs, and since Access is somehow setup to use MS Paint
as a default image viewer, Access got confused and instead inserted a “Package
Object”. I was able to view the Package Object as an icon, and could
double-click to view it in my default image viewer but the image would not
display in anything but an icon in my form. All settings in Access that
control whether an image is viewed as an icon or as a full image would not
work, since technically this was a “Package Object” and not an image…at least
as far as Access was concerned. (Normally in table view, when you insert a
bitmap for example…the field value will say “Bitmap Object” or
whatever…mine always said “Object”). Arrgh!

The work around is to insert an object, choose New when prompted (instead of
existing) and select Microsoft Photo Editor 3.0 from the list. Once Photo
Editor opens, choose a file with the standard file open procedure and then
select Exit to Table from the File dropdown menu. The OLE object in the record
will now be a Bitmap or JPEG or whatever instead of an Object. I haven’t tried
it, but I think you could probably open any image viewer or graphics
application instead of Microsoft Photo Editor with similar results.

Or it could be that Access doesn’t have all of the proper graphic filters installed. See online help via the index for ‘graphic filters’ for an explanation

At the bottom of this help screen is a double arrow link to show you how to run setup to intall them.

[jbird3000]

To extent what Starbury said…

Try putting an unbound image on the form of one of the images you want to display. If it shows up fine, then you can set the source or whatever property of the image object to the path of image from the database in the Current event.

[BF]

If you go into the Northwind sample database, there is an employee’s form with pictures of the employees on each record. See what you can find there. From my own experience, I stick to .bmp’s and jpegs.

[NoGoodNamesLeft]

Thanks, all…Starbury’s work around did it.