Picture in Report

[srikanthpai007]

Hello...
I am trying to attach pic in the table and get pic as output in Qurry and Report.. I am facing problem in doing this... can any one help me in this....

This is just to help mgt in visualizing report...

Thanks

 

[srikanthpai007]

Hi, srikanthpai007.
I just know RAQ Report can do what you want easily.
If you like, you can get this free reporting tool at http://www.raqsoft.com/.

thanks Freezea

 

[pl456]

To start add a field to you table that will hold the full path to the image you want in your report including the file extension e.g. c:\test.jpg

Add this field to your query.

Open/design the report and add the image control (add any image for now), keep this control unbound.

Add some VB code. Right click on the detail section of the report and select build event. Make sure the 2 drop downs read Detail & Format.
Copy this code in

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me![name of the image control].Picture = Me![name of the field holding the image path]
End Sub