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
.
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