pictures in Access report records

[bellwether5]

Can anyone suggest how I could get picture links in Reports to work.
I think I accurately followed the steps in
http://support.microsoft.com/default.aspx?scid=kb;en-us;285820
the How To page.
I'm using Access 2002 with Windows XP Pro. The above on last page says it
applies to to Access 2003 and Access 2002 Std Edition.
I also tried the How To for Access 2000 and could not make it work either.
--Martin

 

[Larry Linson]

Can anyone suggest how I could get
picture links in Reports to work.

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

 

[bellwether5]

Thanks for the reply Larry; I have no trouble embedding an OLE picture.
But have tried several "how to's" for linking to the photos and always get a
"can't find picture.jpg" message. The latest how to
http://www.databasedev.co.uk/bound_image_report.html for example. (This one I
get the same photo for each record, or the above error message)
Also tried http://support.microsoft.com/default.aspx?scid=kb;en-us;285820 with
same error messages + more.
My project is to build a database for about 300 rhododendrons in my garden.
I there a way you could review my workflow to see where it is faulty?
P.S.: I don't know VBA so can only copy and paste code.
Thanks, Martin Cloverdale,Oregon

 

[Larry Linson]

But have tried several "how to's" for linking
to the photos and always get a "can't find picture.jpg"
message. The latest how to
http://www.databasedev.co.uk/bound_image_report.html
for example. (This one I get the same photo for each
record, or the above error message)

The result would indicate that you mis-read the event in which you placed
the linking code. It should be in the Print or Format event of the Detail
section of the Report. (Please note that I did not 'carefully analyze' the
solution at the link you provided, just am commenting on 'same photo for
each record.')

My project is to build a database for about
300 rhododendrons in my garden.

I'm fond of rhododendrons, from my days living in the Pacific Northwest and
in Northern CA. Sadly, they don't do well at all where I now live.

I there a way you could review my workflow
to see where it is faulty?

Sorry. I have to limit my 'remote assistance' to answering specific
questions in newsgroups. But, I'll take under advisement that it might be
good to add OLE linking examples to my sample databases when/if I next
revise them.

P.S.: I don't know VBA so can only copy and paste code.

Even if you are just going to be a "power user," it is good to learn the
basics of VBA... not necessarily enough to write 'inspired new code' but
enough to follow and understand the gist of what someone else has done. The
Step-by-Step books from Microsoft Press are a good, simple beginning -- just
be sure to get the one on VBA, not the general one on just using Access.

Larry Linson
Microsoft Access MVP

 

[Larry Daugherty]

Hi Larry,

You need a greenhouse with coolers capable of keeping the inside
temperature about 20 degrees below ambient. First make a strategic
investment in Carrier stock.

Did you ever visit Florence, Oregon during their annual Rhododendron
Festival?

 

[Larry Linson]

You need a greenhouse with coolers capable
of keeping the inside temperature about 20
degrees below ambient. First make a strategic
investment in Carrier stock.

Alas, that isn't within my budget parameters.

And moving back to the Pacific Northwest isn't feasible. Hmm. Maybe I could
convince my offspring to move in that direction, and bring their offspring,
and ... Maybe if I promised them an annual family salmon fishing trip.

Did you ever visit Florence, Oregon during
their annual Rhododendron Festival?

No, but I'll bet it is spectacular. Maybe I'll get the chance someday.

Larry