mytfein
asked on
Access 2003: Report - Group Totals - a diff. approach - getting error
Hi EE,
Can group fields on the report be affected with vba logic?
I tried to total the credits during detail process by accumulating to a public variable.
If total > 0, print the student's academic standing field
If total = 0, print 'IN PROGRESS"
In the group's print event and even the format event tried this, and am getting an error:
Private Sub GroupFooter1_Print(Cancel As Integer, PrintCount As Integer)
Debug.Print pg_lngTotCredits
If pg_lngTotCredits = 0 Then
Me.txtTermStanding = "IN PROGRESS"
End If
pg_lngTotCredits = 0
End Sub
tx for your ideas and advice, sandra
Can group fields on the report be affected with vba logic?
I tried to total the credits during detail process by accumulating to a public variable.
If total > 0, print the student's academic standing field
If total = 0, print 'IN PROGRESS"
In the group's print event and even the format event tried this, and am getting an error:
Private Sub GroupFooter1_Print(Cancel As Integer, PrintCount As Integer)
Debug.Print pg_lngTotCredits
If pg_lngTotCredits = 0 Then
Me.txtTermStanding = "IN PROGRESS"
End If
pg_lngTotCredits = 0
End Sub
tx for your ideas and advice, sandra
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Jim,
i understand your ideas
however, when i go to subreport2 to add a hidden text field to the group footer
and then hit save, Access aborts....
uploaded mdb below ... is it possible for you to add your ideas please, i'm curious if you also get
an aborted situation or out of memory msg
tx, s
db2.zip
i understand your ideas
however, when i go to subreport2 to add a hidden text field to the group footer
and then hit save, Access aborts....
uploaded mdb below ... is it possible for you to add your ideas please, i'm curious if you also get
an aborted situation or out of memory msg
tx, s
db2.zip
No problem adding a text control to the footer here.
JimD.
ASKER
tx for checking Jim..... s
ASKER
ASKER
Hi Jim,
Just wondering if you would know why, if in the above example
there are 3 groups,
yet the group format event got triggered 5 times
i'm wondering if access first prints out the detail
and afterwards superimposes the group logic
( i come from a diff. era as a cobol pgmr where first we process the detail records, and when
there was a change in key, we executed group footer/control break logic)
the end result looks great, just wondering about the 2 extra breaks....
if you have any thoughts, pls advise, tx, s
Just wondering if you would know why, if in the above example
there are 3 groups,
yet the group format event got triggered 5 times
i'm wondering if access first prints out the detail
and afterwards superimposes the group logic
( i come from a diff. era as a cobol pgmr where first we process the detail records, and when
there was a change in key, we executed group footer/control break logic)
the end result looks great, just wondering about the 2 extra breaks....
if you have any thoughts, pls advise, tx, s
Sandra,
<<Just wondering if you would know why, if in the above example
there are 3 groups,
yet the group format event got triggered 5 times
>>
It's what I was refering to above in my first comment. Based on properties, like Keep together, the report engine may need to retreat up the page and reformat it again. This can happen several times in the course of trying to figure out the page layout honoring (if it can) all the properties that have been set.
This can happen for the detail as well as any of the grouping levels. That's why both OnFormat and OnPrint events have counts (FormatCount and PrintCount).
JimD.
<<Just wondering if you would know why, if in the above example
there are 3 groups,
yet the group format event got triggered 5 times
>>
It's what I was refering to above in my first comment. Based on properties, like Keep together, the report engine may need to retreat up the page and reformat it again. This can happen several times in the course of trying to figure out the page layout honoring (if it can) all the properties that have been set.
This can happen for the detail as well as any of the grouping levels. That's why both OnFormat and OnPrint events have counts (FormatCount and PrintCount).
JimD.
ASKER
Thx Jim,
a) i understand what you said earlier and above...
i guess i was not so clear in my question....
when the group even got triggered 5 times, the If formatCount =1 logic was true 5 times,
as well too.
so if the formatCount is equal to 1 5 times, when is formatCount = to another value
b) this report is a subreport that acts as column2
the preview screen above prints that way too
the curious thing, is that when i run the entire parent report that has a subreport1 to act as column1
on the col2 report, the 3rd grouping is sometimes not showing the horizontal line that i put in
the footer column when IT PRINTS, but the line shows in print preview....
i never noticed that before.... so i commented out the group footer logic, but the 3rd line separator
is still not showing
this should probably be a new post.... just venting... to see if you have any opinions on this matter,
tx, s
a) i understand what you said earlier and above...
i guess i was not so clear in my question....
when the group even got triggered 5 times, the If formatCount =1 logic was true 5 times,
as well too.
so if the formatCount is equal to 1 5 times, when is formatCount = to another value
b) this report is a subreport that acts as column2
the preview screen above prints that way too
the curious thing, is that when i run the entire parent report that has a subreport1 to act as column1
on the col2 report, the 3rd grouping is sometimes not showing the horizontal line that i put in
the footer column when IT PRINTS, but the line shows in print preview....
i never noticed that before.... so i commented out the group footer logic, but the 3rd line separator
is still not showing
this should probably be a new post.... just venting... to see if you have any opinions on this matter,
tx, s
ASKER
Hi Jim,
i even deleted col2's subreport, copies col1's subreport, and it still does not print the right side
3rd goup's separator line......
it would take a little time for me to create test data out of this real student and then i could upload
the mdb....
tx, s
i even deleted col2's subreport, copies col1's subreport, and it still does not print the right side
3rd goup's separator line......
it would take a little time for me to create test data out of this real student and then i could upload
the mdb....
tx, s
ASKER
Hi Jim,
i see the problem in this test mdb
i would think that the last group would end with a separator line that i drew in the footer
but is not showing for the last group
i will open a new post....
and write back with the link, tx, s
db2.zip
i see the problem in this test mdb
i would think that the last group would end with a separator line that i drew in the footer
but is not showing for the last group
i will open a new post....
and write back with the link, tx, s
db2.zip
ASKER
Hi Jim,
you don't have to spend time on the line issue....
an EE expert just explained it to me here....
https://www.experts-exchange.com/questions/26909493/Access-2003-Report-Group-Totals-separator-line-in-the-group-footer-is-not-always-printing.html
tx again, s
you don't have to spend time on the line issue....
an EE expert just explained it to me here....
https://www.experts-exchange.com/questions/26909493/Access-2003-Report-Group-Totals-separator-line-in-the-group-footer-is-not-always-printing.html
tx again, s
ASKER
tx for writing...
now i understand my error, i was trying to change a bound field
ok, let me get back to you ... tx, s