ole

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 27 Mar 2005 20:35 GMT

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

Reply to this Message

SA - 27 Mar 2005 22:15 GMT

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.

Signature

Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

> Hi
>
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

Ed - 28 Mar 2005 01:14 GMT

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.

> Hi
>
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message