469,609 Members | 1,276 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,609 developers. It's quick & easy.

How do you change an image property on pages of a Access report?

I have a WinXP sp3 machine running Access 2007. I have a report that would like to show a jpeg image of a building diagram for various customers. Each page shows a different customer, and would like to have their particular image showing the map layout of their building.
In the customer table I have an attachment field that allows me to specify the jpeg file for that customer. I have the report group by customer number, so it shows one customer's data per page. The customers name and address I have appearing in the page header section. I placed an image control in the detail section. I noticed there is a property to set the file name of the image (properties window, format tab, "Picture" property.
What I would like to do is dynamically change this property every time a new page (aka a different customer) is produced. I can access the file name of the attachment field by setting a text box and setting the data control property to the attachment's filename property that appears in it. If I can see this data, the filename of the attachment, can I not somehow access this and change the image property to match that filename so the image for that customer would appear in the datail section of the Customer's page?
How would I write the code to set the image's property dynamically, and what event would I use code in so when I run the report, it would print the appropriate image for that page's customer?

The attached jpg file is a screen shot of my screen when in design mode of my report in Access 2007...
I hope I am being clear.... :-)
Thanks for any help...
Bruce V. ..aka OASys1
Attached Images
File Type: jpg rpt_bldg_map_img.jpg (85.4 KB, 77 views)
Jan 30 '12 #1
0 1248

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.