Showing an image on a aform

[Tiger955]

Hi!

A topic which often discussed, still I do not find a solution.

I stored JPEG in an SQL-Server 2008 table. Pictures are small therefore I did not use the FILESTREAM format but varbinary(MAX), which works well in the form frmArticleGroups with a BOUND objectfield. I only have less than 50 pictures in total therefore I did not store the path of the image but the whole picture in the datebase embedded.

The table tblArticlegroups has following columns:
GrpID
Grpdescription
GrpImage

In another form, where I specify the different articles within the groups, I want to show the image from tblArticlegroups.

So, I habe a combobox with a qry as recordsource connecting tblArticles with tblArticlegroups. On of the columns is GrpImage, which I wanted to show in a UNBOUND objectfield on the form frmArticles by

Form_Current

me.GroupImage=me.Article.column(3)

But this does not work.

Me.GroupImage has no .Picture property, so I do not know how I could show the GrpImage with the specific article.

Please help me to solve this problem.

Thanks!
Michael

 

[pr2-eugin]

Is it .Picture or .Image? I think it is .Image, even if it does not come up, just type it in and see if it works.

 

[Tiger955]

No .Image is not available either!

 

[pr2-eugin]

Read again !

I think it is .Image, even if it does not come up, just type it in and see if it works.

Or have you tried that?

 

[Tiger955]

Sorry, I did not read correct...

Me.GroupImage.Image = Me.Article.column(3)

brings an Error that this property or method is not supported.

 

[pr2-eugin]

So to be clear, you have an Unbound Image control on the Form? Not Unbound Object frame? If it is an Object frame change it to Image control.

 

[Tiger955]

Hi Paul!

It is an unbound object field ( I do not know, if it is translated correct from German; there are two icons, on is a bound object field - the one with XYZ on top - and an unbound one, I took the unbound one. By the way I could not find an unbound object FRAME control - or it is the same?).

But mehanwhile I found another solution which works:

As I said before, I can see the picture in the frmArticleGroups i made a query WITH the GrpImage included and just droped the field on the form in a BOUND object field and it shows up!

Thanks your efforts!
If you know a solution for an unbound one, pls let me know, would be interested to know, how it works!

Michael