Populate an Unbound image frame from an Access Table 1

[dRahme]

Hi, I posted this question in the Access Reports forum and while an alternative solution was posted, I am still curious as to if this can be done.

I have an Ole field in an Access table with one bitmap embedded. What I would like to do is to be able to read the contents of the table field into an unbound image control on a report.

This is more of a curiosity of mine than anything else. Bound forms, subreports all work and I use them but I would like to know if this is possible and how one would do it. If not, no big deal either. I would just like to know.

Thanks, dRahme

 

[MajP]

Something like?

http://support.microsoft.com/?id=148463

http://support.microsoft.com/?id=158941

http://support.microsoft.com/kb/263021

http://support.microsoft.com/kb/148463

http://www.tek-tips.com/faqs.cfm?fid=1294

 

[dRahme]

No, but thanks for the links. As I said, I was not interested in linking to an external file which I can do, but reading a stored image in an access table and populating an unbound image control with it. Apparently it cannot be done.

Thanks anyway,

dRahme

 

[MajP]

I am sure it can be done, but why? If it is in the db already why not stick the image control within a subform and pick the appropriate record? Seems a heck of a lot easier.

For some bizarre reason if you really had to do this (and I can think of no good reason), you would probably have to do BLOB to file and then File to BLOB code.

Could you get away with a imagelist?

 

[SBerthold]

The problem is probably that in an Access Ole field is also saved the information about the application it was created with.
So, using an Ole control to hold the object and then automating a process to save the picture in a file through the the application which created it, and then reading this file into the image control, could be an option.

So, storing it in a long binary field from the start, or just a path, is easier to work with.

 

[genomon]

I thought the reply I posted in the other forum worked for you?

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."