Update Images in All Reports Together (1 Viewer)

Hi,

In our database, we have a number of reports based on the same "template". These reports include standard images such as company logo, tag line, accreditations etc.

Is there a method to automatically update these images in a similar way that SSI works in html?

Thanks

create a table and save the path and image name to the table.
then use dlookup to fetch the image from this table.

say you create a table, tblReportImages
fields:
id------------------------------autonumber
rptTag................................short text
rptValue.............................short text

sample data:
id......................................................rptTag.........................................rtpValue
1.......................................................CoLogo......................................d:\path\logo.bmp
2.......................................................tagLine.......................................d:\path\tagline.bmp
3.......................................................accreditations.............................d:\path\accreditation.bmp


now you can change the paths to point to the new path by editing the records in this table.

on your reports load event, set the path of each entity:

private sub report_load()
me.imagLogo.picture = dlookup("rptValue","tblReportImages","rptTag='CoLogo'")
me.imageTagLine.picture = dlookup("rptValue","tblReportImages","rptTag='tagline'")
me.imageAccreditation.picture = dlookup("rptValue","tblReportImages","rptTag='accreditations'")
end sub

Fantastic, thank you so much