Company logo in all reports

I would like to insert a company logo in all the reports of an access
database. This logo however must change when the database is used by
different customers.
To solve this problem with other company details I have a form with all
company details which I fill up for each customer. The headings of all
reports are referenced to these company information. Can I do somthing
similar with the logo?
What I mean is to insert the logo in the company details form and then from
each report to regference to that image.

Insert an image object in your reports, set its Picture Type property to
Linked, and its Picture property to None; in your company details table,
store the path and filename of the stored company logo; use an
appropriate event (such as the report open, or the report header format
if in the header) to assign the file path and name to the image's
Picture property, with something like:

Dim sPicture As String
sPicture = DLookup("LogoFile","tblCompanyDetails","some condition?")
Me.Image17.Picture = sPicture

HTH,
Nikos

Thanks Nikos
I will just try to do that.

"Michalis J." wrote:

I would like to insert a company logo in all the reports of an access
database. This logo however must change when the database is used by
different customers.
To solve this problem with other company details I have a form with all
company details which I fill up for each customer. The headings of all
reports are referenced to these company information. Can I do somthing
similar with the logo?
What I mean is to insert the logo in the company details form and then from
each report to regference to that image.

Do I need to load any references.
When I type "Me.Image17. " , "Picture" is not available and the picture is
not loaded

"Michalis J." wrote:

Thanks Nikos
I will just try to do that.

"Michalis J." wrote:

I would like to insert a company logo in all the reports of an access
database. This logo however must change when the database is used by
different customers.
To solve this problem with other company details I have a form with all
company details which I fill up for each customer. The headings of all
reports are referenced to these company information. Can I do somthing
similar with the logo?
What I mean is to insert the logo in the company details form and then from
each report to regference to that image.

It wasn't available for me either, I just typed it. Didn't have to add
any reference, but check for the OLE Automation one anyway. It worked
for me in A2K3, don't know if it's a version thing.

Nikos

The Ole Automation is on, and I use Access2003 too but still the picture
doesn't come up. I have to look at it more carefully. Thanks a lot anyway.

Michalis

"Nikos Yannacopoulos" wrote:

It wasn't available for me either, I just typed it. Didn't have to add
any reference, but check for the OLE Automation one anyway. It worked
for me in A2K3, don't know if it's a version thing.

Nikos

By the way, you did substitute my hypothetical table, field and control
noames with the actual ones, right? Didi you debug to check that
sPicture is assigned the excpected path nad filename correctly?

Nikos