How to assign a "picture" from table to report object

[Stephane]

I'd like to be able to allow changes of logo by creating a
"configuration" table including a picture field

when running the report, I'd like by code to salvage the
picture and dump it into the report image object so that
the desired logo is part of the header

can't really use a bound object since the picture is not
part of the query use to run the report with, and don't
want to do it because it would slow down the report

just want to read from table and dump it into object on
the report header

don't want to read a file either

anyone done that?

Thx
Stephane

 

[Larry Linson]

Use a DLookup domain aggregate function in code to retrieve the full path
and filename of the image from your Configuration Table and set it into the
Picture property of an Image Control that you've placed in the Report.

I'm not sure what you mean by "picture field". A picture can be stored _as_
an OLE Object, or as a Binary Large Object in an OLE Field, or you can store
the full path and filename in text of the Image on disk.

The sample databases at http://accdevel.tripod.com don't do exactly what you
want, but they do illustrate all three of those methods of storing and using
a picture.

Larry Linson
Microsoft Access MVP


Larry Linson
Microsoft Access MVP