Re: Graphics in Report

Tech-Archive recommends: Fix windows errors by optimizing your registry

Larry,

Perhaps if I explain in a different way. I have the Image control
(Image220) in the details section. I want the image to change to a different
picture whenever a text1 field change occurs, and to load the filename
indicated in the text1 field. My report is working perfectly except that I
cannot find a way to tell the application I want to change the pciture.

When I try to edit the Image by right-clicking the image control, I can
identify a Picture to be printed in the pciture field. To test the
application out, this is how I loaded the page to ensure I could get a
graphic to print. Next, I wanted to be able to change the picture as the
Text1 fieldname changed. The Text1 field name is also in the details
section. This did not work!

I read your initial reply to me and I was successful in creating a report
event for "On_Format" as follows

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Image220.???? = "c:\Test\ECP0412.gif"
End Sub


I would have expected to have identified the control, image220.picture, as
the receiver of the filepath and filename, but Picture was not an available
choice to me.


I know i am 2 keystrokes away from the answer I need but I have invested
several hours already trying to figure this out. Can you tell me if I am
following a fruitful path or do I need to regroup and try a different
approach?

Thanks

Dan


"Larry Linson" wrote:

If you click on the properties and assign a GIF file to an Image Control,
and never change it, it is working properly to show that picture every time
the Image control is displayed. What did you think it was supposed to do?

If, however, the Image control is in the Detail Section, so that each of the
"5 unique 'Pages'" in the Report is actually a Detail Section, you could, in
the OnPrint or OnFormat event, set the Picture property of that Image
Control to the appropriate image file location (path and filename) to show
the picture that applies to the particular record.

Larry Linson
Microsoft Office Access MVP


"DanRoy" <DanRoy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E97347DC-31B1-43B7-B917-FC7270AB54A5@xxxxxxxxxxxxxxxx
I am designing a report which contains an Image Control. Within the
application, I have a table, "ECP Schedule Picture",which is linked to the
key sort field for the report and a second field containing the filepath
"[ECP Picture link]" and name of the 5 GIF corresponding to the 5 unique
"Pages" in the report. Clicking on the Image Control, I edited the
properties to identify one of the GIF files directly, ie
C:\test\ECP0412.gif.
If I run the report with a defined GIF entered in the ImageControl.Picture
field, I see the same GIF for all 5 pages of the report. I want to
display
each of the unique GIF files with the corresponding key field on the five
pages of the report.

I Have tried loading the picture field with [ECP Schedule Picture]![ECP
Picture link] with no success. I have tried loading the hyperlink fields
in
properties, also with no success. I do have some VB code in my
application.
How would I relate a section of VB code to control what is displayed in an
Image Control as each page of the report is prepared?





.

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: Graphics in Report
    ... If you click on the properties and assign a GIF file to an Image Control, ... set the Picture property of that Image ... key sort field for the report and a second field containing the filepath ... each of the unique GIF files with the corresponding key field on the five ...
    (microsoft.public.access.reports)
  • Re: issue with adding picture using image control
    ... I added one picture type CC to a document titled "LogoImageCC" ... Dim oCC As Word.ContentControl ... and the Image control is only one of them -- and probably ... In the template for your report document, ...
    (microsoft.public.word.vba.general)
  • Re: Simplest way to put bound picture in a report.
    ... And then, when trying to preview the report, it immediately returns the ... Place an Image control in the detail ... section of your report to display the picture. ... you need to modify some registry keys. ...
    (microsoft.public.access.reports)