Pagination on a Continuous Form

[VWP1]

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).

 

[Tom van Stiphout]

On Fri, 5 Mar 2010 11:23:01 -0800, VWP1

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

 

[Mike Painter]

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

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