<Je*************@rmhp.orgwrote
>I am trying to add a picture to a form that
is visible depending on certain criteria. The
picture works perfectly on my computer,
but on other users computers this image is
either black or scrambled. Can
someone please help!??!?
There are multiple ways to "add a picture to a form". How are you going
about it? My off-the-top-of-my-head guess is that you are using a Bound
Object Frame to display an OLE Object and that you have different image
processing software registered for the image file type on the two computers.
Newsgroups are good places to get answers, and you will find that people in
this one try to be more helpful than in many others. The questions most
likely to get useful answers are those that are "precise and concise". Yours
meets the latter criteria, but contains almost no detail. For good
suggestions on effective use of newsgroups, see
http://www.mvps.org/access/netiquette.htm
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. They do not
illustrate every way to handle images... one is to put a hyperlink field in
a table, another is to just put a path and filename in the table and use the
Application.FollowHyperlink to call the registered image processing
software. Finally, you'll find an ActiveX control, freely downloadable, at
MVP Stephen Lebans' site, for displaying imagess. Access 2007 has
additional features.
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
