Insert picture into bound OLE frame

[John Baker]

I have a form with a bound object frame. I have in the past been able to use
insert object from the menu to insert a picture into this field. The
pictures are in jpg format. I have tried the database in both MSAccess2000
and MSAccessXP format.

At present the pictures I want to insert are only coming in as the file
name. If you double click on the file then the picture will open up in Photo
Editor. I want to be able to see the picture in the frame on the form.
The "Display Type" property is set to "Contents" and not "Icon". The "OLE
Type Allowed" is set to "Either". I want the picture to be Embedded and not
linked!

This was all working before but I am not sure what happened. Any Ideas?

ps: I've just noticed that bmp file will insert as pictures but jpg, gif and
wmf file type will not. They come in as the name of the file only.

I need the frame to be bound to a recordset.

Any help greatly appreciated
John Baker

 

[Arvin Meyer]

I think you'll find that unless you embed the picture as a BLOB it will
bloat the database. I store the pictures in the file system and use an image
control to display them directly in the Access form. Go to my website and
download the sample application PictureMgr to see a sample of what I am
talking about.

http://www.datastrat.com/Download/Picture2K.zip

If you want to store them as a BLOB, there may be some code at Larry
Linson's site:

http://members.tripod.com/accdevel/imaging.htm

or you can use a third party activeX control like DBPix.

http://www.ammara.com
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access