OLE Objects

I

Ian on Cowan

Is there any way to display the contents of an embedded OLE Object as a field
in a report?
 
L

Larry Linson

Is there any way to display the contents
of an embedded OLE Object as a field
in a report?
Click to expand...

Bound OLE Frame from the Controls Toolbar?

Larry Linson
Microsoft Access MVP
 
I

Ian on Cowan

The embedded object is a Package, and contains a document image. The field is
put in the report (together with other fields in the underlying query), and
properties are set as OLE Type Allowed 'embedded' but it only shows icon whe
the report is generated, whatever the Size Mode property is set to. What am I
not doing that would make this work? Should the doc image be embeded in a
Word or other document type in the OLE field?
 
L

Larry Linson

Under the Data tab, in the Property Sheet for the Bound OLE Control, is
"Display Type" set to "Content"? If it is set to "Icon", that's what you'll
see, even if it makes no sense in the context of a Report.

If not, start working through: A "package"? What software generates a
package? Is that software installed on the machine where you are having the
problem, and registered for that file type?

I'm not a particularly good source on details of debugging OLE Frames, as I
don't use them, for a variety of reasons. The only thing I display as images
are, umm, images (pictures), so other approaches work better for me.

Larry Linson
Microsoft Access MVP
 
I

Ian on Cowan

Laryy,

Thanks; with a bit of experimentation I did get what I wanted. However, the
way the bound OLE controls work seems to vary with the software that's used
to generate the object, and you can only suck them and see!
 
L

Larry Linson

Yes, that is one of the reasons I am not fond of using OLE Objects for
displaying pictures. You are "held hostage" to whatever software the user
(who often isn't the developer) has registered for the file type of the
image.

Larry Linson
Microsoft Access MVP
 
R

Richard Thompson

I have an database in Access 2003 (converted from Access 97) that holds
pictures of plants in an OLE field. The files were put in a BMP format.
When i try to add new records now, the pictures display as a "package object"
i.e. a small image of the picture with the file name written underneath. I
am not able to show just the picture.

I have tried making a new databse in Access 2003 and it does the same thing.
Could you please advise how I can insert pictures in the access database and
see them as pictures in reports and forms,
Thanks

Richard
 
R

Richard Thompson

DEar Stephen,
Thanks for the response.
The Table in datasheet view shows PI3.IMAGE in each cell where there is a
photo. The original images were scanned from prints using software
(PhotoImpact3)from a company (Ulead). I saved the images in bmp format as
Access is limited to importing only bitmaps.

I now have a digital camera. I usually use CanonZoomBrowser to download
them although with my Nikon I use windows explore to transfer them from the
camera to the computer. They are saved in JPG format. I convert these to
Bitmaps using MS Windows Picture and Fax Viewer or MS Paint (MS Picture
Manager greys out the option to save JPG files as BMP for some reason). When
imported as objects they always appear as packages.

I think the limitations of Access are forcing me to give up importing
pictures as objects - could you please give me your preferred alternative
solution - e.g. as a link. Remember that the main puropose is to produce a
report that shows a names, descriptions, and photos of plants that I select
for a new garden.

Thanks for your help

Richard
 
Top