Print Linked Images in a Report

[bosve73]

I have a problem with printing linked images in a report. I am using the tip from this site: http://www.tek-tips.com/faqs.cfm?fid=399 but i can't get it working in my DB as I am getting the run time error 2465 access can't find the field I am reffering to. I have doublechecked the field is there so there must be something else I am missing.

I have attached my dummyDB so that someone could point me to the right direction .

[maximus]

I checked PicLoc Field and you already have the extension .bmp added so its not necessary to add in the code any more.

Put PicLoc Field on the report and hide it setting Visible to No.

Here I have put the folder in my C drive you can use the path of your choice.



Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me!oleSymbolsReport.Picture = "C:\EP\" & Me.PicLoc
End Sub

[bosve73]

I checked PicLoc Field and you already have the extension .bmp added so its not necessary to add in the code any more.

Put PicLoc Field on the report and hide it setting Visible to No.

Here I have put the folder in my C drive you can use the path of your choice.



Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me!oleSymbolsReport.Picture = "C:\EP\" & Me.PicLoc
End Sub

Thanks! Now it works the way it's expected. Just one noob question :
Why do I have to have a field PicLoc on my report?

[maximus]

Yes here its important that the PicLoc Field is there on the report as the path in the VBA code uses the value of the field as reference.

[polarbearman]

I realize that the I am referring to an old post, but I was wondering if the same principle can be applied to the page header section instead of the detail section.

I wish to be able to change all my reports so that that image is static. The image will be the company logo and should the logo change, all I would have to do is replace the file on the network share, but maintain the same name.

Is this possible?

Polarbearman