By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,060 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

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

P: 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, 73 views)
Jan 30 '12 #1
Share this question for a faster answer!
Share on Google+

Post your reply

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