Re: Message for Marshall Barton

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Noel (anonymous_at_discussions.microsoft.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 02:33:33 -0700

Thanks for this Marsh. Ill have a look at the link youve
suggested and if I dont have any success, Ill have to
give up and take the Count facility off this report.
Thanks again for the help, Noel
>-----Original Message-----
>Noel wrote:
>
>>Hi again Marsh. You remember you were helping me with
an
>>earlier post re a Strange Count Problem in a Report? I
>>posted this on the other thread earlier today -
reposted
>>here also to hopefully catch your eye.
>>
>>Well, your suggestions didnt bear fruit Im afraid but
>>something I just tried may throw some light on things,
>>although it seems just as improbable. For some reason
I
>>decided to set Visible = True in the txtCountofSchools
>>text box which is in the SchoolID Header area and now,
>>when I specify that same odd School name,
>>txtCountofSchools correctly shows 1 and the text box in
>>the report footer, whose Control Source is set to =
>>[txtCountofSchools] shows 2. I changed the name of
>>txtCountofSchools and the Control Source of the footer
>>text box to make sure I hadnt got some hidden text box
>>somewhere and this confirmed that theyre linked OK. I
>>then set up a completely new text box in the SchoolID
>>header, called it txtCount, set control source to =1
and
>>Running sum = Over All and added a second txt box in
the
>>footer set to control source =[txtCount]. Same result.
I
>>then moved one of the footer text boxes into the
SchoolID
>>area and it correctly shows 1. But if I move it back to
>>either the report or page footer, it shows 2. Am I
going
>>mad? - surely if the footer text boxes control source
is
>>the txt box in the Header, it has to show the same
value,
>>no matter where its postioned. Any further ideas??? By
>>the way, Ive proved that the count is accurate in many,
>>if not all, other instances - even when I specify a
>>criteria for the report that allows this particular
>>school to be included (e.g by specifying a particular
>>Type of School or County). I would be interested in any
>>further views or tests you might have. Perhaps I need
an
>>exorcist. Cheers, Noel
>
>
>An exorcist may provide more useful results than I can
come
>up with here ;-\
>
>I have never seen and can not imagine a situation that
>causes what I think you're describing. I'm just plain
out
>of ideas here ;-(
>
>If you want to grasp at a pretty thin straw, try blaming
it
>on some kind of corruption. See Tony's FAQ at:
>
> http://www.granite.ab.ca/access/corruptmdbs.htm
>--
>Marsh
>MVP [MS Access]
>.
>

Relevant Pages

  • Tackling the dropout problem
    ... Unesco's 2007 report highlights Malaysia's efforts to reduce the dropout rate. ... primary school education, writes HARIATI AZIZAN. ... primary school enrolment in the rest of the world has grown by leaps ...
    (soc.culture.malaysia)
  • Re: Hun Sen also singled out higher education institutions as deficient, calling masters and doctora
    ... Report faults school quality ... IN a wide-ranging assessment of the Kingdom's education system, ... At the primary school level, the net enrolment ratio increased by 1.2 ...
    (soc.culture.cambodia)
  • Once again the Godless media attacks
    ... Taunton officials dispute reports on Jesus sketch ... elementary school suspended a second-grader and required the boy to ... The boy’s father showed reporters a report indicating his son ...
    (rec.sport.pro-wrestling)
  • Family Tree Connection Update for 18 Nov 2007
    ... Passaic Dept. of Education 1910-11 Report ... Year Book of the Quaker Club, Tuscaloosa, Alabama, 1904 - 1905. ... The Cobbonian, Annual Publication of the Morristown High School, Morristown, New Jersey. ... King School 1912-1913 Souvenir ...
    (soc.genealogy.marketplace)
  • Family Tree Connection Update for 13 Apr 2008
    ... Ithaca High School 1931 Commencement ... Pennsylvania Institution for the Blind 1841 Report ... Eighth Annual Report of the Managers of the Pennsylvania Institution for the Instruction of the Blind, Presented to the Corporators, At their Annual Meeting, March 1, 1841. ...
    (soc.genealogy.marketplace)