Displaying bound images in a form

[munroe47]

I am a stamp collector and have created an Access database of US stamps. Each record contains pertinent info about each stamp (year of issue, denomination, etc.) I would also like to include an image of each stamp in each respective record and display that image on the form that displays all the other data associated with the stamp.



In trying to do this, I created an OLE object field in the table. I created a bound object frame in the appropriate form and dragged the OLE object field into that frame. I inserted the stamp image (which is a .JPEG file) into the OLE object field. After I have inserted the image/object, the frame displays the file name of the image but not the image itself. If I double-click on the frame, another window opens and the stamp image is displayed in that window. I prefer to have the image displayed as part of the form without having to open a second window to view it? I understand the difference between linked and embedded objects, and I set this up specifically to be an embedded object because I didn't want to have to click on a link.

I'm not a Visual Basic programmer yet; I have used the wizards to create all the macros, queries, buttons, pick lists, and other bells and whistles that I use to find and view my data. Any guidance on this image issue would be greatly appreciated!

Thanks, Munroe47

[June7]

Access versions prior to 2007 need code to dynamically display images. Review
http://office.microsoft.com/en-us/ac...001147204.aspx
http://www.databasedev.co.uk/bound_image_form.html

[munroe47]

Access versions prior to 2007 need code to dynamically display images. Review
http://office.microsoft.com/en-us/ac...001147204.aspx
http://www.databasedev.co.uk/bound_image_form.html

Thank you. I have glanced over the links you gave, and I am sure that after I read them carefully, I will be able to resolve my issue.

In looking over those links and other comments on the forum, I'm thinking I'll probably be better off storing the images elsewhere and linking them to the form rather than embedding them and possibly "bloating" the .mdb file (there will be 2000+ images). If I link rather than embed the images, will I still be able to dynamically display them on the form?

Thanks again, munroe47

[June7]

Yes, instead of the image store the path to the image. At least one of those links describe that .

[bobbrewermmc]

I have Access 2007. I would like to store the actual picture in an OLE field in a table -- I can store a bitmap without difficulty -- but the jpeg only stores the link -- I have about 400 jpegs that I would like to store in OLE fields -- can it be done? Thanks bobbrewermmc

[June7]

No, I think OLE field type is specific to bitmap. Use Attachment field and an Image control to display the images.