OLE Objects

[Guest]

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

 

[Larry Linson]

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

Bound OLE Frame from the Controls Toolbar?

Larry Linson
Microsoft Access MVP

 

[Guest]

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?

 

[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

 

[Guest]

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!

 

[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

 

[Guest]

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

 

[Stephen Lebans]

Open the Table containing the OLE field. What class name does it give the
object embedded in the OLE field?
MS Photo Editor or Paint are commonly used as the OLE Server application to
embed Bitmap images. You have recently installed an Application that has
taken over the registration on your system for Bitmap files. You need to
reset it to whatever app was previously successful at inserting your images.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Guest]

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