Inserting Images in a Form

[RS]

I am having a hard time inserting images into a form. I set a field in the
original table to be an OLE object. Every time I enter a picture to
coordinate with a record, it gives me the word "Package" in the field. I
have read that Office 2003 does not have Microsoft Photo Editor as did Office
2003 and XP. I, however, do not have either of the earlier versions to
reload Editor. I also read that you could install drivers to fix this
problem. I went to the Microsoft web site, did the download (which said it
was successful) and I still have the problem.

Does anyone know a fix to this problem? It is very frustrating!! All I
want it to do is place a picture on the form to coordinate with each record.
I thought it would be easy. Any assistance would be greatly appreciated!!

Thank you,

RS

 

[Boyd Trimmell aka HiTechCoach via AccessMonster.co]

I have found it is bese to avoid the whole OLE stuff.

Check out:
http://www.databasedev.co.uk/bound_image_form.html

I am having a hard time inserting images into a form. I set a field in the
original table to be an OLE object. Every time I enter a picture to
coordinate with a record, it gives me the word "Package" in the field. I
have read that Office 2003 does not have Microsoft Photo Editor as did Office
2003 and XP. I, however, do not have either of the earlier versions to
reload Editor. I also read that you could install drivers to fix this
problem. I went to the Microsoft web site, did the download (which said it
was successful) and I still have the problem.

Does anyone know a fix to this problem? It is very frustrating!! All I
want it to do is place a picture on the form to coordinate with each record.
I thought it would be easy. Any assistance would be greatly appreciated!!

Thank you,

RS

--
Boyd Trimmell
aka HiTechCoach
http://www.hitechcoach.com
http://www.officeprogramming.com

Message posted via AccessMonster.com

 

[Stephen Lebans]

There are no "drivers" you can install to resolve your issue. Your system
must have a Paint/Drawing application that can function as an OLE Server to
serve the Images to Access via OLE. Unfortuntately, as you stated MS no
longer makes MS Photo Editor available. This application was used as an
Image OLE Server for the majority of Access users.

I use:
MS Paint for BMP
Paint Shop Pro(the older versions are Shareware/FreeWare and can be
downloaded off of the Internet)) can handle a lot of Image file formats.


As another poster in this thread mentioned, you really should abandon OLE
and use the standard Access Image control.
--

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

 

[Paul Sanguinetti]

The problem with that solution is that the image control is missing some
capabilities that the unbound object frame can do. I'm trying to load
multiple .png images into multiple frames with transparent background and
stack them so that you can look down through all images to see a composite
(building a complete piece of equipment from its selected components). The
image frame even with a transparent background displays as a solid so the
only thing visible is the top control. It also does wierd things to the
transparent portion of the .png.

I've been looking for a control that will accept HTML as a source similar to
the Data Access Page so I could use the Div capability to stack transparent
images, with no luck so far.

What I'm fighting with now is that the unbound object frame displays the
file name and "package" as the class when I try to use a linked png even
though I've got Photo Editor selected as the default server for png's. When I
imbed the graphic by not using the "build from file" method it works fine. I
can get it to work fine on my other desktop, but not on my development
machine. Its driving me buggy.

Any suggestions?

 

[Paul Sanguinetti]

Adendum: I'm using AccessXP and haven't installed 2003. When I click on a png
it displays in Photo Editor so the default appears to be working. My next
step is to search the registry to see if there is anything there that may
override.

 

[Stephen Lebans]

Here's a thread on your issue:

I have seen cases in the NG's where MS Paint was the app
registered for BMP files but NOT as the OLE Server for BMP files.
Here is a thread on this topic. WHile it refers to MS Office Photo Editor
the logic is what you need to follow for MS Paint. Watch our for NG
linewrapping!

http://groups.google.ca/group/micro...en&lnk=st&q=lebans+paint+bob#7cc573b7d86e58c9

--

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

 

[RS]

Thank you, everyone, for all your input! I realize it is not just me who is
having this problem.