Insert Image from database to Access Report (1 Viewer)

[Alvein17]

Hello guys,

Have a good day sir/mom.

i would insert image in database table to report. i already create table to store file location from image, how to insert the image to access report? i have try to insert with this way but didn't work.

table name: Test
field1: pic
field2: path location

i want to know and learn how to do it?

thank you All.

 

[theDBguy]

Bind the report to the table and then bind the picture control to the field.

 

[arnelgp]

and if your Report is already bound to another table/query,
you add code to the Report's Load Event, to set the Picture
property of your Image control:

Private Sub Report_Load()
Me.Image0.Picture = DLookup("location", "test", "pic='Dwi'") & ""
End Sub

 

[Alvein17]

Bind the report to the table and then bind the picture control to the field.

huy DBguy, thank you for your answer, but i have bind the report with other Table.

 

[Alvein17]

and if your Report is already bound to another table/query,
you add code to the Report's Load Event, to set the Picture
property of your Image control:

Private Sub Report_Load()
Me.Image0.Picture = DLookup("location", "test", "pic='Dwi'") & ""
End Sub

hai arnel, thank you for your answer and i would try it.

 

[theDBguy]

huy DBguy, thank you for your answer, but i have bind the report with other Table.

Can you use a query joining the image table with them?

 

[Alvein17]

Can you use a query joining the image table with them?

hy theDBguy, yes i'm using query to join the image. thank youuuu

 

[theDBguy]

hy theDBguy, yes i'm using query to join the image. thank youuuu

Is it working now?

 

[Alvein17]

Is it working now?

yes, it's working

 

[theDBguy]

yes, it's working

Excellent! Good luck with your project.

 

[Alvein17]

Excellent! Good luck with your project.

thank you theDBguy