Pagination on a Continuous Form

  • Thread starter Thread starter VWP1
  • Start date Start date
V

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).
 
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
 
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
Click to expand...

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
 
Back
Top