Graphics in Report
in [Reports]
|
From: DanRoy on 20 Jun 2008 18:29 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?
From: Larry Linson on 21 Jun 2008 19:20 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(a)discussions.microsoft.com> wrote in message news:E97347DC-31B1-43B7-B917-FC7270AB54A5(a)microsoft.com... >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? > >
From: DanRoy on 23 Jun 2008 13:04 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(a)discussions.microsoft.com> wrote in message > news:E97347DC-31B1-43B7-B917-FC7270AB54A5(a)microsoft.com... > >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? > > > > > > >
From: OMS on 23 Jun 2008 16:26 Hi, Embed your image then set "Visible" in Properties to "No". Then you might try a Case statement like this: Select Case Trim(Me.text1) Case "Image220" Me.Image220.Visible = True Case "Image221" Me.Image221.Visible = True End Select I'm sure there's a way without embedding but I haven't tried that. Good Luck,OMS "DanRoy" <DanRoy(a)discussions.microsoft.com> wrote in message news:D26884DE-4345-4451-AE72-2E3A0D65369E(a)microsoft.com... > 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(a)discussions.microsoft.com> wrote in message >> news:E97347DC-31B1-43B7-B917-FC7270AB54A5(a)microsoft.com... >> >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? >> > >> > >> >> >>
From: Larry Linson on 23 Jun 2008 17:20 "DanRoy" <DanRoy(a)discussions.microsoft.com> wrote > Larry, > 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! This is not what you showed in code. And "did not work" is not very specific. I hope what you wrote actually translates to "change the picture when the value displayed in the Text1 Control changes" and in a Report, that will only change when a new Record is displayed. "Text1 fieldname changed" just does not make any sense, assuming as I do, that "Text1" is a Text Box in your Report. No, I did not need additional explanation. I am convinced that I understood, and that I gave you the correct answer. I rarely go back and review my "archives" to determine detail such as "Picture will not show as a property in Intellisense, but you can just type it in and it works just fine". Now I did go back and review, to make sure I had not overlooked something else. For my purposes, I do not refer to Controls without prefixing them with either the "Me" shorthand to represent the current Form or Report, or a reference to a particular Form in the Forms collection. It is always difficult to guess in what areas the Access team may decide to be "stricter" in interpreting code statements. And, for my own and others' convenience, I use the Reddick VBA Naming Convention (usually at the simplest level), described in detail at http://grr.xoc.net. > 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. Whatever you expect or see in Intellisense, Picture is a property of the Image control. In a sample database, the following works for me, even though when I enter character-by-character, the same line of code immediately below it, Picture does not show up in the list of Properties for Intellisense in Access 2003. Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) Me!imgImage.Picture = Me.txtImagePathAndFile End Sub Bug? Probably. Worth worrying about? No, type in the value and see if it works... You are not limited to "choosing" a value. And, this is not the only property that doesn't show up in Intellisense in Access. In my case, I wanted to display a different picture for each record, and the Control "txtImagePathAndFile" is bound to the Field containing the path and filename of the picture for that record. I note that once I put the Image control on the Report, I went back and deleted the original value from the Picture property, so that Property in design view shows (none). Good luck with your Report, Larry Linson Microsoft Office Access MVP
|
Next
|
Last
Pages: 1 2 Prev: Are linked table based subreport in Access possible? Next: Display text based on date query |