Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Limit Records Per Page Access 2000

1 view
Skip to first unread message

Denise Hurd

unread,
Apr 24, 2003, 6:54:54 PM4/24/03
to
Need to limit the number of records printing on a report to a specific
number.

i.e. 100 records - "10 per page". Report would be 10 pages long.

Thanks.
--
D Hurd
dh...@ctechs.com


David Mitchell

unread,
Apr 25, 2003, 9:24:24 AM4/25/03
to
"Denise Hurd" <dh...@ctechs.com> wrote in message news:<vagqn4a...@corp.supernews.com>...

> Need to limit the number of records printing on a report to a specific
> number.
>
> i.e. 100 records - "10 per page". Report would be 10 pages long.
>
> Thanks.

Denise,

In the underlying query, look for "top values" in properties and
select 100. If you are working from the same data each time you will
always get the same report. Post some details of what the report is
for and the query setup if you require more feedback

Regards

David

TR

unread,
Apr 25, 2003, 10:30:33 AM4/25/03
to
To limit the number of records per page to 10, place a textbox in the
detail section. Name it txtCountRecords. Set its control source to =1 and
set its runningsum property to Over All.
Set the detail section on format event to the following:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.txtCountRecords Mod 10 = 0 Then
Me.Section(acDetail).ForceNewPage = 2
Else
Me.Section(acDetail).ForceNewPage = 0
End If
End Sub

Denise Hurd

unread,
Apr 25, 2003, 12:05:36 PM4/25/03
to
TR

Thanks.

That will work. I've even used it before and had forgotten.


Denise Hurd

0 new messages