B
bandwood1
From within the report_detail event, how can I tell if I'm processing
the last record for the report?
the last record for the report?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Report Detail Event - How can I tell (from within VBA) that I'm onthe last record.
A
Alex Dybenko
Hi,
perhaps you can get latest record ID and then compare current Id with it.
You can also consider using ReportFooter event, which will run after last
detail section
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
perhaps you can get latest record ID and then compare current Id with it.
You can also consider using ReportFooter event, which will run after last
detail section
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
J
John Spencer
Add a control to the detail section
Control Source: =1
Running Sum: OverAll
Visible: No
Name: tLineCounter
Add a control to the report's header
Control Source: = Count(*)
Visible: No
Name: tRecordCount
In the format event of the detail section add
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If me.tLineCounter = me.tRecordCount Then
'Printing last record, so do something
end If
End Sub
By the way, you really needed to post this just to one group -
microsoft.public.access.reports
Posting it to several is overkill and is generally a waste of others time.
Someone else may give you the same response in one of the other groups.
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
Control Source: =1
Running Sum: OverAll
Visible: No
Name: tLineCounter
Add a control to the report's header
Control Source: = Count(*)
Visible: No
Name: tRecordCount
In the format event of the detail section add
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If me.tLineCounter = me.tRecordCount Then
'Printing last record, so do something
end If
End Sub
By the way, you really needed to post this just to one group -
microsoft.public.access.reports
Posting it to several is overkill and is generally a waste of others time.
Someone else may give you the same response in one of the other groups.
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
B
bandwood1
Add a control to the detail section
Control Source: =1
Running Sum: OverAll
Visible: No
Name: tLineCounter
Add a control to the report's header
Control Source: = Count(*)
Visible: No
Name: tRecordCount
In the format event of the detail section add
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If me.tLineCounter = me.tRecordCount Then
'Printing last record, so do something
end If
End Sub
By the way, you really needed to post this just to one group -
microsoft.public.access.reports
Posting it to several is overkill and is generally a waste of others time..
Someone else may give you the same response in one of the other groups.
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
- Show quoted text -
Thanks tis works, but I was hoping for something a little more
intrinsic (ie a property or attibute of the report_detail object or
something.