Load picture from OLE field

[caubaydon]

Dear all,

I stored a logo picture to the field [colorlogo] / table [organization]

I am now at report design screen. I am creating a report for other table (let’s say [suppliers]).

I am trying to load the picture from [organization] table to this report header area but can not.

I use both the =DLookUp("[ColorLogo]","Organization") and =loadpicture([organization]![ColorLogo]) but can not get the picture.

Anyone can help me?

Thank you in advance

Mamtom

 

[Sum Guy]

I assume you have this logo somewhere else on your computer.

If so, simply insert it into your report while in design view.

Be sure to Embed it.

 

[CyberLynx]

Perhaps use the Image Control and and a Hidden TextBox in the Report that is bound to the Table Field ColorLogo. Then in the OnFormat event of your Report use code something like this:

If IsNull(Me.myHiddenTextBoxName) = False Then
   Me.myImageControlName.Picture = Me.myHiddenTextBoxName
End If

Make sure the PictureType property for the Image Control is set to Linked. To much Embedding can really bloat your Database especially when Images are involved.

.

 

[caubaydon]

To much Embedding can really bloat your Database especially when Images are involved.

.

Thanks a lot for your reply. I tried to do it but still not work. But anyway quoted from your advice I decide to keep the picture out of the database.

Thanks again for all replies.