Dean Davids
dnod at aol.com
Fri Oct 7 11:29:33 CDT 2011
I did this sort of thing some years ago and it worked well exactly as you are saying. Update the image property on print, I believe. I had started with tables and bound images but that failed miserably as soon as the number of records became substantial. Everything I know of the process, I learned from AD TejPal (forgive me if I missed that spelling). If you look up his posts I would defer to his expertise. I think he even has some sample databases out on the Access reference sites that cover what you are trying to do. It has been a long time time and I am an infrequent Access developer these days so I can offer very little help from memory. If you don't get anywhere I will see if I can pull out my own examples and refresh my brain. Dean S. Davids On Oct 7, 2011, at 12:06 PM, "Brad Marks" <BradM at blackforestltd.com> wrote: > All, > > Earlier I posted a question about Attachment fields. I was able to find > an answer to my question and I have a test application that works Okay, > but it seems a bit complicated for what I am trying to do. > > I thought that if I explained what I am trying to accomplish, maybe > someone would have some insights or suggestions. > > I am pulling "Part" information from a SQL Server database into Access > 2007 via ODBC. One of the fields in the Parts table is the location of > an image of the Part. (for example C:\Part_Images\Part001.jpg). > > I want to be able to use an Access 2007 Report (in Report View) to > display the appropriate .jpg file for each detail line on the report. > > I am able to accomplish this via the use of a "temporary" Access table > that has an Attachment field for the images. This works, but I wonder > if there is a better/simpler approach. > > I have experimented with placing an "Image" on the Report Detail lines, > with hopes of changing the Images's "Picture" property on the fly for > each detail line on the report. I cannot figure out how to do this. > Perhaps Access 2007 does not allow this when using "Report View". > > I would guess that others may have run into similar situations and may > have some advice. > > Thanks for your help, > > Brad > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com