Picture in form

[Guest]

Forgive me, please, I'm going to need a little hand holding on this one. I am
trying to attach a different picture to each record in a table in Access 03.
My field for the picture is data type OLE Object. When I insert the picture,
on my form it only shows the box for the picture and the name of the picture
(candy1.jpg) near the upper left hand corner. I have to click ithe file name
in the box for it to show up, where it is displayed in the Windows Picture
and Fax viewer. I have tried the methods available in the Help with the same
results, and I would really prefer that it not view in the Pic and Fax
viewer. I would like for a picture to display with each record- if I have to
do something like make a command button for it to pop up, that is ok, too. If
I can supply any further info, please let me know.Thank you for your patience
!

 

[Guest]

I suspect you are using office 2003 and for some reason Microsoft decided to
remove the OLE server from this version. If you are using Office 2003 then
you need to install JUST the Microsoft Photo Editor from an office XP CD

 

[Guest]

I am using Office 03, but windows XP. I don't know that I can get the office
XP (I'm at a remote jobsite) Is there a way to just get it to come up at all
(even in the pic and fax viewer) either automatically or with a command
button? Thank you very much for your help-

 

[Guest]

I don't know of one. When I had this problem, this was the only solution I
could get.

 

[Larry Linson]

I am using Office 03, but windows XP. I don't
know that I can get the office XP (I'm at a
remote jobsite) Is there a way to just get it to
come up at all (even in the pic and fax viewer)
either automatically or with a command
button? Thank you very much for your help-

The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.

If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.

Larry Linson
Microsoft Access MVP

 

[Guest]

Thank you very much for your help- Sorry for the delayed reply, I was out of
the office for a few days- Thank you, I will try your suggestions!