ole

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hi

I have a report that i wish to print off that contains a logo. I want to be
able to link to the logo rather than embed it as I have several logos that i
use and it is easier for me just to change the main logo. For example i
want to link to C:\nm\store\mylogo.jpg How can i do this? Also can i run
some logic on it so that it only uses the image if it isunder 4cm x3cm?

Thanks
 
Dave:

Rather than use an OLE object (unbound OLE frame) use and image control on
your report. Store the path to the image in a text field within the
database and add that field to the query output. Then in the On Print event
of the section that contains the Image control. Add code like:

Me!MyImageControlName.Picture = Me!MyInvisibleTextBoxWithPathToImage.
 
I made a table that contains 3 fields, ID, Description, OLEimage to store my
logos. Then link this table or add to underlying query of form and select
the logo I want to use for the record I am creating. I place the OLEimage
field as the main logo on the report and thats it. so each record can have
its choice of logos.
 
Back
Top