Embedded Pictures

[Ken]

First, I know it is bad "Form" to embed pictures instead
of linking to them as you get picture bloat. However, the
database I am establishing is for a limited number of
records (<125). It is for a homeowner's association and I
want to import individual pictures of houses. I tried
linking and it took forever to open Photoshop Elements, my
graphics program.

So, my intent is to embed the .jpg files. I have tried
importing them and cut and pasting them to no avail. All
I ever get is the name of the file (as I didn't want an
icon. I thought it may be that it didn't like .jpgs, so I
tried the .bmp format. this didn't work either. I had
done this before. I think I go it to work by using
MicroSoft's "Picture It" software and converted the
pictures to this proprietary format and they would
import. I really didn't want to have to do this again.

Does anybody have any ideas how I can get the embedded OLE
files to display? Thanks in advance!

Ken

 

[Damon Heron]

I am puzzled by your problem. Are you adding the bound object control to
your form? Your table should have a picture field with data type OLE
Object, and the control source on the form's bound object should be this
field. From there, when form is opened, right-click on the object control
area, and select insert object, select create from file, and pick your
existing picture by browsing to the picture.

HTH
Damon

 

[Stephen Lebans]

You have to have a Paint program that can function as an OLE Image
Server to any objects you insert into your table. MS Photo Editor is the
standard choice. Make sure that the relevant file associations(JPG, BMP
etc.) point to the MS Phot Editor application.

--

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

 

[Ken]

Damon and Stephen,

Thanks for the response. Yes the field on the form was a
bound field. I would right click and the go throught the
insert object maneuver and all I would get is the name of
the object when the form was opened.

It seems that I had remembered opening the folder from
Microsoft's Picture It! software and then being able to
right-click-copy and then open the form to the specific
record and then right-click-paste. So, I reinstalled the
Microsoft program and then tried it and it worked. The
only reason I can figure that this works isthat the
object, when opened up in MS Picture It! thinks it was
created in a MS program and therefore corresponds with MS
Access. Before, I was using Adobe Elements and not having
success.

Upon reading Stephen's suggestion of using MS Paint - this
may work as well to where I wouldn't have had to install
MS Picture It! This would have been the way to go.
Thanks again to both of you!!

Ken