Report
in [Reports]
|
From: Per Erik on 29 Apr 2010 16:38 Like this: NR. NAVN KLUBB VEKT 1 Jim Bekken Raufjøringen 9510 gr. 2 Thomas Ødergård Gjøvik og Toten SFK 8105 gr. 3 Kenneth Ottosen Gjøvik og Toten SFK 5440 gr. 4 Jørgen Langerud Raufjøringen 5245 gr. 5 Ove Lauten Gjerdrum 4745 gr. **** 6 Per E. Hellerud Eidsvoll JFF 4625 gr. 7 Frank Hønsen Gjerdrum SFK 4525 gr. 8 Odd Henning Hansen Gjøvik og Toten SFK 4505 gr. 9 Johnny Ulsrudstuen Gjøvik og Toten SFK 4255 gr. 10 Anders Wold Oslo Sportsfiske 3780 gr. 11 Tom Pedersen Gjøvik og Toten SFK 3325 gr. 12 Eric Olstad Toten JFF Lodd 2 3040 gr. 13 Geir Lillejordet Gjøvik og Toten SFK 2735 gr. 14 Remi A. Olsen SFK Pimpel Sør 2540 gr. 15 Paal Runden Gjøvik og Toten SFK 2495 gr. "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 29 Apr 2010 23:29 It would help if you told us wasn't working. What are your results? If the controls are all visible, what do you see? My suggestion show have displayed the control named Mark every 1/3 of the record count. I think you need to change the code to: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3 End Sub -- Duane Hookom MS Access MVP "Per Erik" <PerErik(a)discussions.microsoft.com> wrote in message news:89E9A348-9496-4C22-A00F-61572952126E(a)microsoft.com... > Like this: > NR. NAVN KLUBB VEKT > 1 Jim Bekken Raufjøringen 9510 gr. > 2 Thomas Ødergård Gjøvik og Toten SFK 8105 gr. > 3 Kenneth Ottosen Gjøvik og Toten SFK 5440 gr. > 4 Jørgen Langerud Raufjøringen 5245 gr. > 5 Ove Lauten Gjerdrum 4745 gr. > **** > 6 Per E. Hellerud Eidsvoll JFF 4625 gr. > 7 Frank Hønsen Gjerdrum SFK 4525 gr. > 8 Odd Henning Hansen Gjøvik og Toten SFK 4505 gr. > 9 Johnny Ulsrudstuen Gjøvik og Toten SFK 4255 gr. > 10 Anders Wold Oslo Sportsfiske 3780 gr. > 11 Tom Pedersen Gjøvik og Toten SFK 3325 gr. > 12 Eric Olstad Toten JFF Lodd 2 3040 gr. > 13 Geir Lillejordet Gjøvik og Toten SFK 2735 gr. > 14 Remi A. Olsen SFK Pimpel Sør 2540 gr. > 15 Paal Runden Gjøvik og Toten SFK 2495 gr. > > "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 30 Apr 2010 10:20 The controls are visible in all the lines, not only in the 1/3. "Duane Hookom" wrote: > It would help if you told us wasn't working. What are your results? If the > controls are all visible, what do you see? > > My suggestion show have displayed the control named Mark every 1/3 of the > record count. I think you need to change the code to: > > > Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) > Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3 > End Sub > > -- > Duane Hookom > MS Access MVP > > > "Per Erik" <PerErik(a)discussions.microsoft.com> wrote in message > news:89E9A348-9496-4C22-A00F-61572952126E(a)microsoft.com... > > Like this: > > NR. NAVN KLUBB VEKT > > 1 Jim Bekken Raufjøringen 9510 gr. > > 2 Thomas Ødergård Gjøvik og Toten SFK 8105 gr. > > 3 Kenneth Ottosen Gjøvik og Toten SFK 5440 gr. > > 4 Jørgen Langerud Raufjøringen 5245 gr. > > 5 Ove Lauten Gjerdrum 4745 gr. > > **** > > 6 Per E. Hellerud Eidsvoll JFF 4625 gr. > > 7 Frank Hønsen Gjerdrum SFK 4525 gr. > > 8 Odd Henning Hansen Gjøvik og Toten SFK 4505 gr. > > 9 Johnny Ulsrudstuen Gjøvik og Toten SFK 4255 gr. > > 10 Anders Wold Oslo Sportsfiske 3780 gr. > > 11 Tom Pedersen Gjøvik og Toten SFK 3325 gr. > > 12 Eric Olstad Toten JFF Lodd 2 3040 gr. > > 13 Geir Lillejordet Gjøvik og Toten SFK 2735 gr. > > 14 Remi A. Olsen SFK Pimpel Sør 2540 gr. > > 15 Paal Runden Gjøvik og Toten SFK 2495 gr. > > > > "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 30 Apr 2010 23:52 Tell us how you have your report set up including the code that is run and which section. -- Duane Hookom MS Access MVP "Per Erik" <PerErik(a)discussions.microsoft.com> wrote in message news:D22CFF97-51D1-4D79-988C-DDCDD31E0C9E(a)microsoft.com... > The controls are visible in all the lines, not only in the 1/3. > > "Duane Hookom" wrote: > >> It would help if you told us wasn't working. What are your results? If >> the >> controls are all visible, what do you see? >> >> My suggestion show have displayed the control named Mark every 1/3 of the >> record count. I think you need to change the code to: >> >> >> Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) >> Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3 >> End Sub >> >> -- >> Duane Hookom >> MS Access MVP >> >> >> "Per Erik" <PerErik(a)discussions.microsoft.com> wrote in message >> news:89E9A348-9496-4C22-A00F-61572952126E(a)microsoft.com... >> > Like this: >> > NR. NAVN KLUBB VEKT >> > 1 Jim Bekken Raufjøringen 9510 gr. >> > 2 Thomas Ødergård Gjøvik og Toten SFK 8105 gr. >> > 3 Kenneth Ottosen Gjøvik og Toten SFK 5440 gr. >> > 4 Jørgen Langerud Raufjøringen 5245 gr. >> > 5 Ove Lauten Gjerdrum 4745 gr. >> > **** >> > 6 Per E. Hellerud Eidsvoll JFF 4625 gr. >> > 7 Frank Hønsen Gjerdrum SFK 4525 gr. >> > 8 Odd Henning Hansen Gjøvik og Toten SFK 4505 gr. >> > 9 Johnny Ulsrudstuen Gjøvik og Toten SFK 4255 gr. >> > 10 Anders Wold Oslo Sportsfiske 3780 gr. >> > 11 Tom Pedersen Gjøvik og Toten SFK 3325 gr. >> > 12 Eric Olstad Toten JFF Lodd 2 3040 gr. >> > 13 Geir Lillejordet Gjøvik og Toten SFK 2735 gr. >> > 14 Remi A. Olsen SFK Pimpel Sør 2540 gr. >> > 15 Paal Runden Gjøvik og Toten SFK 2495 gr. >> > >> > "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 1 May 2010 06:17 Is it possible to send the entire database, so you can see how it is made. I'm an amateur at Access, so it could væe much "strange" that makes this not work! "Duane Hookom" wrote: > Tell us how you have your report set up including the code that is run and > which section. > > -- > Duane Hookom > MS Access MVP > > > "Per Erik" <PerErik(a)discussions.microsoft.com> wrote in message > news:D22CFF97-51D1-4D79-988C-DDCDD31E0C9E(a)microsoft.com... > > The controls are visible in all the lines, not only in the 1/3. > > > > "Duane Hookom" wrote: > > > >> It would help if you told us wasn't working. What are your results? If > >> the > >> controls are all visible, what do you see? > >> > >> My suggestion show have displayed the control named Mark every 1/3 of the > >> record count. I think you need to change the code to: > >> > >> > >> Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) > >> Me.Mark.Visible = (Me.txtRunCount = Me.txtCountAll \ 3 > >> End Sub > >> > >> -- > >> Duane Hookom > >> MS Access MVP > >> > >> > >> "Per Erik" <PerErik(a)discussions.microsoft.com> wrote in message > >> news:89E9A348-9496-4C22-A00F-61572952126E(a)microsoft.com... > >> > Like this: > >> > NR. NAVN KLUBB VEKT > >> > 1 Jim Bekken Raufjøringen 9510 gr. > >> > 2 Thomas Ødergård Gjøvik og Toten SFK 8105 gr. > >> > 3 Kenneth Ottosen Gjøvik og Toten SFK 5440 gr. > >> > 4 Jørgen Langerud Raufjøringen 5245 gr. > >> > 5 Ove Lauten Gjerdrum 4745 gr. > >> > **** > >> > 6 Per E. Hellerud Eidsvoll JFF 4625 gr. > >> > 7 Frank Hønsen Gjerdrum SFK 4525 gr. > >> > 8 Odd Henning Hansen Gjøvik og Toten SFK 4505 gr. > >> > 9 Johnny Ulsrudstuen Gjøvik og Toten SFK 4255 gr. > >> > 10 Anders Wold Oslo Sportsfiske 3780 gr. > >> > 11 Tom Pedersen Gjøvik og Toten SFK 3325 gr. > >> > 12 Eric Olstad Toten JFF Lodd 2 3040 gr. > >> > 13 Geir Lillejordet Gjøvik og Toten SFK 2735 gr. > >> > 14 Remi A. Olsen SFK Pimpel Sør 2540 gr. > >> > 15 Paal Runden Gjøvik og Toten SFK 2495 gr. > >> > > >> > "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! > >>
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 4 Prev: Detect when detail section pushes to 2nd page Next: Report Grand Total Miscalculating Overtime |