display an image from a path in a table

[valkyry]

Hello,
I can't figure out the OLE Object. It's not working for me.

I have a field in a database (SQL Server table) that stores the image name. example: logo.jpg

I have created a table in MS Access of the fields I need including the image field but added the path with the image name of only the data that is needed.

I need to create a label that will display the image (picture) not the field (the path) and I can't get this work.

Please help!

 

[dhookom]

Add an image control to your report and name it imgMyImage. Add a text box to the same section of your report that is bound to your complete image file name with the drive and folder information. Name the text box "txtImageFile".

In the On Print event of report section, add code in the event module like:

Me.imgMyImage.Picture = Me.txtImageFile

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[valkyry]

Hello and thank you!
I believe I did everything but when I preview I get
can't find the macro "Me"

Why would it mention a macro??

thank you for your help!

 

[dhookom]

You entered the line of code in the Property rather than opening the event procedure (code window).

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[valkyry]

Ah, yes it worked!

Any idea how I can get the sizes of each image to "expand" or "reduce" depending on the image size itself?

thanks again! this was awesome help!

 

[dhookom]

You might want to search around

http://www.lebans.com.

The solution might depend on your version.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[valkyry]

Hey,
I figured it out
changed it the Clip to Zoom and it worked

thanks again!!!