Access report with image as background

[Vulcan1500]

In an Access report I'm able to include an images as background. The image file is called 'template.png'. My problem starts when different users get a copy of the database and each individual user adds his/her own design image to the database directory with name 'template.png'. How can I address this file as being the backgroundfile (full page) with vba?

 

[arnelgp]

either put the image in each local pc. or fe table (attachment field).

 

[Vulcan1500]

My intention is indeed to add file to local pc, but I do not know how to address this file in vba to be the background image (transperent) of a a4 report.

 

[arnelgp]

on the report's load event you set the Picture property of the image to the path of your local image.
be consistent if this is fe/be, you might think of putting the image along the folder of the fe:

private sub report_load()
me.imageControlName.Picture = CurrentProject.Path & "\yourImage.Ext"
end sub