Company Logo pulled from a field.

[hooi]

I have a report which has a fixed company logo. I would like to change it so that the logo is pulled from a table field. I will design a form to allow user to upload their own logo to the field. How should I go about doing it? as I'm having problem redesigning the report to use the new image field.

Thanks for helping...

 

[Oldsoftboss]

On my reports I created a sub report that is not linked to the main report (Master/Child), then put the data on it directily from the table you have with the logo as the record source.
HTH
Dave

 

[hooi]

Hi Dave,

My table which contains a field for 'OLE Object', is pasted with a Jpg file. I've created a subreport as per your suggestion, but the graphic is not being shown, where could I have done wrong?

Thanks for helping...

 

[Oldsoftboss]

I suggest using linked images as the dont blow out the Db size.
I will whip up a demo but in the mean time view the attachment.
Dave

 

[Oldsoftboss]

Hope this helps.

Dave

 

[hooi]

Fantastic! Thank you very much Dave. Your help is much appreciated.