pictures in Access report records bellwether5 16.09.2006 17:50:02 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

Re: pictures in Access report records "Larry Linson" <bouncer[ at ]localhost.not> 18.09.2006 23:09:57 "bellwether5" wrote > 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

Re: pictures in Access report records bellwether5 18.09.2006 23:38:01 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" wrote: [Quoted Text] > > "bellwether5" wrote > > > 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 > > >

Re: pictures in Access report records "Larry Linson" <bouncer[ at ]localhost.not> 19.09.2006 15:58:33 "bellwether5" wrote > 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

Re: pictures in Access report records "Larry Daugherty" <Larry.NoSpam.Daugherty[ at ]verizon.net> 20.09.2006 06:50:55 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- -- "Larry Linson" <bouncer[ at ]localhost.not> wrote in message news:Oxm10RA3GHA.3476[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > "bellwether5" wrote > > > 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 > > >

Re: pictures in Access report records "Larry Linson" <bouncer[ at ]localhost.not> 20.09.2006 21:49:46 "Larry Daugherty" wrote > 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