Report
in [Reports]
|
From: Per Erik on 19 Apr 2010 12:17 Hey! First, sorry my bad English! I have created a results page of a report in Access 2007. I want to make a mark AFTER the first third of the report. So if there are 33 participants, I would like it to be characterized by the eleventh. Is this possible in a report? Hope someone can help me with this!
From: Duane Hookom on 19 Apr 2010 13:14 Assuming you have a control named "Mark" that you want to make visible.... Add a text box to the Report Header section: Name: txtCountAll Control Source: =Count(*) Add a text box to the detail section: Name: txtRunCount Control Source: =1 Running Sum: Over All Visible: No Add code to the On Format of the detail section: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.Mark.Visible = (Me.txtRunCount Mod Me.txtCountAll \ 3 = 0) End Sub -- Duane Hookom Microsoft Access MVP "Per Erik" wrote: > Hey! First, sorry my bad English! > I have created a results page of a report in Access 2007. > I want to make a mark AFTER the first third of the report. So if there are > 33 participants, I would like it to be characterized by the eleventh. Is this > possible in a report? > Hope someone can help me with this!
From: Per Erik on 26 Apr 2010 13:52 > > I have created a results page of a report in Access 2007. > > I want to make a "sign" - like: **** - AFTER the first third of the report. So if there are > > 33 participants, I would like it to be characterized by the eleventh. Is this > > possible in a report? > > Hope someone can help me with this! "Duane Hookom" wrote: > Assuming you have a control named "Mark" that you want to make visible.... > > Add a text box to the Report Header section: > Name: txtCountAll > Control Source: =Count(*) > Add a text box to the detail section: > Name: txtRunCount > Control Source: =1 > Running Sum: Over All > Visible: No > Add code to the On Format of the detail section: > Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) > Me.Mark.Visible = (Me.txtRunCount Mod Me.txtCountAll \ 3 = 0) > End Sub > > -- > Duane Hookom > Microsoft Access MVP > > > "Per Erik" wrote: > > > Hey! First, sorry my bad English! > > I have created a results page of a report in Access 2007. > > I want to make a mark AFTER the first third of the report. So if there are > > 33 participants, I would like it to be characterized by the eleventh. Is this > > possible in a report? > > Hope someone can help me with this!
From: Duane Hookom on 26 Apr 2010 21:58 Is there still a question here? -- Duane Hookom MS Access MVP "Per Erik" <PerErik(a)discussions.microsoft.com> wrote in message news:834127EA-B433-43C0-A64F-050CB4F39E30(a)microsoft.com... >> > I have created a results page of a report in Access 2007. >> > I want to make a "sign" - like: **** - AFTER the first third of the >> > report. So if there are >> > 33 participants, I would like it to be characterized by the eleventh. >> > Is this >> > possible in a report? >> > Hope someone can help me with this! > > "Duane Hookom" wrote: > >> Assuming you have a control named "Mark" that you want to make >> visible.... >> >> Add a text box to the Report Header section: >> Name: txtCountAll >> Control Source: =Count(*) >> Add a text box to the detail section: >> Name: txtRunCount >> Control Source: =1 >> Running Sum: Over All >> Visible: No >> Add code to the On Format of the detail section: >> Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) >> Me.Mark.Visible = (Me.txtRunCount Mod Me.txtCountAll \ 3 = 0) >> End Sub >> >> -- >> Duane Hookom >> Microsoft Access MVP >> >> >> "Per Erik" wrote: >> >> > Hey! First, sorry my bad English! >> > I have created a results page of a report in Access 2007. >> > I want to make a mark AFTER the first third of the report. So if there >> > are >> > 33 participants, I would like it to be characterized by the eleventh. >> > Is this >> > possible in a report? >> > Hope someone can help me with this!
From: Per Erik on 29 Apr 2010 15:30 Yes, I did not get it to work. So I have tried to elaborate on what I want. I apologize for language difficulties, and appreciate that you are trying to help me! >>> I have Created a results page of a report in Access 2007. >>> I want to make a "sign" or a new line - like: **** - AFTER the first third of the >>> Report. So if there are 33 participants, I Would like it to Be characterized after the eleventh. Per Erik "Duane Hookom" wrote: > Is there still a question here? > > -- > Duane Hookom > MS Access MVP > > > "Per Erik" <PerErik(a)discussions.microsoft.com> wrote in message > news:834127EA-B433-43C0-A64F-050CB4F39E30(a)microsoft.com... > >> > I have created a results page of a report in Access 2007. > >> > I want to make a "sign" - like: **** - AFTER the first third of the > >> > report. So if there are > >> > 33 participants, I would like it to be characterized by the eleventh. > >> > Is this > >> > possible in a report? > >> > Hope someone can help me with this! > > > > "Duane Hookom" wrote: > > > >> Assuming you have a control named "Mark" that you want to make > >> visible.... > >> > >> Add a text box to the Report Header section: > >> Name: txtCountAll > >> Control Source: =Count(*) > >> Add a text box to the detail section: > >> Name: txtRunCount > >> Control Source: =1 > >> Running Sum: Over All > >> Visible: No > >> Add code to the On Format of the detail section: > >> Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) > >> Me.Mark.Visible = (Me.txtRunCount Mod Me.txtCountAll \ 3 = 0) > >> End Sub > >> > >> -- > >> Duane Hookom > >> Microsoft Access MVP > >> > >> > >> "Per Erik" wrote: > >> > >> > Hey! First, sorry my bad English! > >> > I have created a results page of a report in Access 2007. > >> > I want to make a mark AFTER the first third of the report. So if there > >> > are > >> > 33 participants, I would like it to be characterized by the eleventh. > >> > Is this > >> > possible in a report? > >> > Hope someone can help me with this! >
|
Next
|
Last
Pages: 1 2 3 4 Prev: Detect when detail section pushes to 2nd page Next: Report Grand Total Miscalculating Overtime |