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?

3
Greetings,
.
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...
.
Regards,
.
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.