Help with logo image on report

  • Thread starter Thread starter Derek
  • Start date Start date
D

Derek

Hope this is any easy one:

I want to change the logo that appears on my report based on the value in a
combo box. There are several different logo's the user can select from. Each
logo is a jpg file on a network drive and.

I've fooled around with both image and ole objects but haven't gotten a
solution.

Anyone know how to do this?

Thanks,
Derek

--
 
Derek said:
I want to change the logo that appears on my report based on the value in a
combo box. There are several different logo's the user can select from. Each
logo is a jpg file on a network drive and.

I've fooled around with both image and ole objects but haven't gotten a
solution.

Anyone know how to do this?
Click to expand...


Stephen Lebans knows:
http://www.lebans.com/loadjpeggif.htm
 
This appears to solve a different problem.

I am not having any trouble getting the image on the report. My problem is
that I want a user to be able to
select a logo based on the brandname in a combo box. So if the user selects
wheaties there is a wheaties logo at the bottom. If the user selects
cheerios there is a cheerios logo at the bottom.

I think there should be simple code to change the image but I don't know how
to write code for reports.

Thanks,
Derek
 
Derek, do you have an OLE field in your table that contains the image? There
is an example of this in the Employees table in the Northwind sample
database.

For a table of any size, the OLE field is unusable, as it bloats the
database impossibly. You therefore have to link the pics dynamically.
Stephen probably has the code to do that, or there is a very old examle on
this page:
http://allenbrowne.com/ser-10.html
 
Back
Top