Re: Help with logo image on report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 10:12:22 +0800

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 

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Derek" <dakalahar@netzero.com> wrote in message
news:jBLYb.19$LH3.8230@news.uswest.net...
> 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
>
> "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
> news:402d949c$0$1741$5a62ac22@freenews.iinet.net.au...
> > "Derek" <dakalahar@netzero.com> wrote in message
> > news:tVbXb.444$dq2.78039@news.uswest.net...
> > >
> > > 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?
> >
> >
> > Stephen Lebans knows:
> >     http://www.lebans.com/loadjpeggif.htm

Relevant Pages

  • Re: DLookup for OLE object
    ... the best way to do this is to NOT put the images in an OLE field in the ... > In the company information I have a place to add the logo. ... but for some reason DLookup will not work in the report. ...
    (microsoft.public.access.reports)
  • Re: Help with logo image on report
    ... "Derek" wrote in message ... > I want to change the logo that appears on my report based on the value in ... > logo is a jpg file on a network drive and. ... Tips for Access users - http://allenbrowne.com/tips.html ...
    (microsoft.public.access.reports)
  • code to insert OLE object
    ... I have created an OLE field that allows the database to ... store a graphic that will then display as a logo in ... reports. ... commands and want to create a command in VB code that ...
    (microsoft.public.access.formscoding)