Photgraphs on forms?

[John Johndon]

I have a table with aircraft details e.g number of engines, number of
doors, type of engines etc....
I have a table with photographs of some of the aircraft, this table has two
fields, one is the registration number and the second is a OLE type field
with the link to the photo (JPEG)

I have created a form to display the data, sorted by the registration number
of the aircraft.

One of the tabed pages on the form is a spot for photographs (if any ) of
each aircraft

If I create a image frame and put the photo in there, a jpeg, it displays
fine. If I create an OLE Bounded Frame to insert a photo from a table, when
I go to form view, i see the name of the file in the frame, and if I double
click on the frame, the program associated with JPEGs opens up and I can see
the photo.


My Questions

How do I account for the fact that there might be zero or 10 photos of each
aircraft?
Any ideas on how to get the photo to show up right away on the form, like
the image frame?
I also was wondering how I would go about putting thumbnails on the form and
then if one double clicks on the picture then you get a full sized view of
the photo..any ideas?

Thanks


JJ

 

[Matthew]

It is not feasible to use the OLE type field for storing
images. Yes, it works but it doesn't really, in the long
run, due to the enormous space overhead of storing images
and the degradation in database performance. For example,
a 500kb jpg will occupy 19mb's in the mdb.

See - Microsoft Knowledge Base article 210100 on how to
display images in forms and reports.

Matthew