Picture from table OLE Object field to report

  • Thread starter Thread starter Ivan
  • Start date Start date
I

Ivan

Hello,

I have put an JPG picture into the field named Logo of some initialization
table of my database. Data type of the Logo field is OLE Object.

Now I'm trying to put the same picture from these Logo field into the Header
of my report where data source is not my initialization table. I would like
something like inserting an object frame control to the report header and
then putting there my Logo field as a data source?

How can I solve this problem. I know how to link a picture from a file, but
how to include a picture from an OLE Object is for me a mystery.

I will be grateful for any hint.

Ivan
 
Ivan-

If there is only one record in your logo table, add the table to the record
source of your report, but don't link it to anything. Add the logo field to
your record source as well. It will show up a gajillion times in the records
source of your report (once for each record) but if you drop the ole filed
into the report header, it shoud only show up once on the actual report.

If you have more than one record in your logo table, you might have to add a
second field from your logo table and set a criteria, so that only the
correct one shows up.

Adam
 
Thank you Adam,

your suggesstion is OK for me. Befor I have been looking for a solution in
the form like Dlookup() for the source :-)

Ivan
 
Back
Top