Picture from table OLE Object field to report

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
 
A

Adam Milligan

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
 
I

Ivan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top