Prev: Access user
Next: Basic INSERT question
From: VWP1 on 5 Mar 2010 14:23
I would like to have one continuous form hold a list of 30 records per page,
and be able to see the page numbers (and use them) at the top and/or bottom
of the form, such that a total of a couple hundred records (or more) can be
displayed in groups of 30 at the request of clicking the page number (similar
to that of a webpage, but only an MS Access Form).
From: Tom van Stiphout on 6 Mar 2010 04:48
On Fri, 5 Mar 2010 11:23:01 -0800, VWP1
<VWP1(a)discussions.microsoft.com> wrote:

You'll have to do all the work yourself, because such interface is not
natively supported. Would be an interesting project though.

-Tom.
Microsoft Access MVP


>I would like to have one continuous form hold a list of 30 records per page,
>and be able to see the page numbers (and use them) at the top and/or bottom
>of the form, such that a total of a couple hundred records (or more) can be
>displayed in groups of 30 at the request of clicking the page number (similar
>to that of a webpage, but only an MS Access Form).
From: Mike Painter on 6 Mar 2010 14:32
Tom van Stiphout wrote:
> On Fri, 5 Mar 2010 11:23:01 -0800, VWP1
> <VWP1(a)discussions.microsoft.com> wrote:

Sure it is. It's called a "report" in preview mode ;)

> You'll have to do all the work yourself, because such interface is not
> natively supported. Would be an interesting project though.
>
> -Tom.
> Microsoft Access MVP
>
>
>> I would like to have one continuous form hold a list of 30 records
>> per page, and be able to see the page numbers (and use them) at the
>> top and/or bottom of the form, such that a total of a couple hundred
>> records (or more) can be displayed in groups of 30 at the request of
>> clicking the page number (similar to that of a webpage, but only an
>> MS Access Form).

This should be a simple task.
Adjust the form for 30 records optionally remove the scroll bar, and use
sendkeys to page up and down.

Global Const VK_PRIOR = &H21 ' PGUP
Global Const VK_NEXT = &H22 ' PGDN
More at http://support.microsoft.com/kb/113547


 | 
Pages: 1
Prev: Access user
Next: Basic INSERT question