Brad Marks
BradM at blackforestltd.com
Fri Oct 7 11:06:42 CDT 2011
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