Pictures in the reports

[Boris Nogoodnik]

I am trying to make a report with pictures. It's Access DB and
the pictures are linked and NOT embedded. I did it similar to
what they have in the Employee form in Northwind example and as
explained in help under "picture". In forms there are no
problems. Help suggests to use "On Current" event for both
forms and reports. But there is NO "On Current" event in
reports!!! The only events that do something are "On Activate"
and "On Page".

So what I am getting is the same image for all records on the
page. Image is taken from the first record on the page if I use
"On Page" Event. If I use only "On Activate", then it takes
first image and uses it for the entire report.

Any way to get around this problem?
Please help!

........

It's Access 2002. And I tried to follow the procedure as
described in help:

=========
Create the following event procedure. Substitute the name of the
image control on your form or report for ImageControlName and
the name of the control containing the path for ImagePath.
Private Sub Form_Current()On Error Resume
NextMe![ImageControlName].Picture = Me![ImagePath]End SubNote
that if you are adding the event procedure in a report, the
first line of the procedure will be the following:

Private Sub Report_Current()==========

 

[MacDermott]

If you want a different picture in each detail section of the report, put
the code in the
Detail_Format
event.

HTH
- Turtle

 

[Boris Nogoodnik]

Thanks - it worked!

If you want a different picture in each detail section of the report, put
the code in the
Detail_Format
event.

HTH
- Turtle

I am trying to make a report with pictures. It's Access DB and
the pictures are linked and NOT embedded. I did it similar to
what they have in the Employee form in Northwind example and as
explained in help under "picture". In forms there are no
problems. Help suggests to use "On Current" event for both
forms and reports. But there is NO "On Current" event in
reports!!! The only events that do something are "On Activate"
and "On Page".

So what I am getting is the same image for all records on the
page. Image is taken from the first record on the page if I use
"On Page" Event. If I use only "On Activate", then it takes
first image and uses it for the entire report.

Any way to get around this problem?
Please help!

.......

It's Access 2002. And I tried to follow the procedure as
described in help:

=========
Create the following event procedure. Substitute the name of the
image control on your form or report for ImageControlName and
the name of the control containing the path for ImagePath.
Private Sub Form_Current()On Error Resume
NextMe![ImageControlName].Picture = Me![ImagePath]End SubNote
that if you are adding the event procedure in a report, the
first line of the procedure will be the following:

Private Sub Report_Current()==========