Re: Ole Objects

A couple of methods are available:


1) Add a hidden Image control to the form in question. Load your "default
Picture" into this control. Your statement is incorrect that the Image
control cannot contain an Image without a valid/existing path. In design
view, once you select an Image via the control's Picture property, it
remains embedded.
Now whenever you want to display the defaul pic simply do something like:
Me.ThisFormsImageControl.PictureData =
Forms!NameOFtheHiddenForm.ImageControl.PictureData


or


2) Load the default pic into an Image control.
Copy the control's PictureData property to a table containing a Long Binary
field
When you want to display the default pic simply copy the contents of the
field to the PictureData prop of the desired Image control.



--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Brian Graham" <GrahamB@xxxxxxxxxxxxx> wrote in message
news:Do-dnbK5r6Lpx3beRVn-og@xxxxxxxxxxx
I'm trying to put a logo on a report. If I embed the image, then every
time it changes, I have to modify the report. Not what I want. (Read 150+
reports..)

I don't want a linked image either. It has 2 problems. One is that a
change in the drive the app is run from would cause problems. Second is
that there is a bug in that if you import a report with a linked image in
it, no further changes to the design are possible.

I can always do a table join and return the image with each record, but
that isn't really appropriate where you have 100,000 records. I don't in
this DB but others I have do..

So, what I am trying to do is have an object on the report with a logo
pulled from a table. I haven't found out how to do this properly yet.

Anyone?
--
Brian


.

Relevant Pages

  • Re: Graphics in Report
    ... When I try to edit the Image by right-clicking the image control, ... identify a Picture to be printed in the pciture field. ... I read your initial reply to me and I was successful in creating a report ... each of the unique GIF files with the corresponding key field on the ...
    (microsoft.public.access.reports)
  • Re: Help Needed ASAP
    ... you can put an image control in the Detail section. ... Also put the field that holds the path to that record's image on the report. ... > see the picture on that form, we are just using the form to attach the ... >> <MS ACCESS MVP> ...
    (microsoft.public.access.forms)
  • Re: Memory for rendering a report page
    ... Use the Print event, NOT the Format event, to load your images into the ... When printing a Report, Access may run out of resources and be ... the Image control. ...
    (microsoft.public.access.reports)
  • RE: Access DB, linked images, memory problems
    ... or whatever part of the page you want the picture to occupy.. ... an Image control to a report in design view it will prompt you for a file. ... The above does assume that each record includes a path to an image file. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: No Matter What... Images wont show!
    ... The form likes to occasionally display one picture for all records, ... using Image Control insertion, OLE (although I'm trying to avoid using ... Picture property to the field in the Form_Current event. ... The record source table contains a text ...
    (microsoft.public.access.formscoding)