[AccessD] Show only X number records at a time

I have heard of this being done sending multiple recordsets from an SQL 
Server SP
then using rs.nextrecordset to read them. Whether this what they do I dunno.


Joe Rojas wrote:

>I guess I would be interested in the web page way but I was really thinking
>about it from a SQL statement perspective.
>I was wondering if this functionality could be achieved solely using SQL.
>Other than calculating the page number of course.
>
>Thanks!
>JR
>
>-----Original Message-----
>From: Charlotte Foust [mailto:cfoust at infostatsystems.com]
>Sent: Friday, May 06, 2005 11:21 AM
>To: Access Developers discussion and problem solving
>Subject: RE: [AccessD] Show only X number records at a time
>
>Web pages work differently than Access forms, Joe.  What are *you*
>trying to achieve?
>
>Charlotte Foust
>
>
>-----Original Message-----
>From: Joe Rojas [mailto:JRojas at tnco-inc.com]
>Sent: Friday, May 06, 2005 7:44 AM
>To: 'Access Developers discussion and problem solving'
>Subject: [AccessD] Show only X number records at a time
>
>
>Hi All,
>
>How do sites like eBay show only X number of items at a time and allow
>users to jump to a page number or click next?
>
>Is there a SQL statement that allows you to select the 2nd
>(3rd,4th,5th,...)set of X number of records in a database?
>
>Thanks!
>JR
>
>
>
>
>This electronic transmission is strictly confidential to TNCO, Inc. and
>intended solely for the addressee. It may contain information which is
>covered by legal, professional, or other privileges. If you are not the
>intended addressee, or someone authorized by the intended addressee to
>receive transmissions on behalf of the addressee, you must not retain,
>disclose in any form, copy, or take any action in reliance on this
>transmission. If you have received this transmission in error, please
>notify the sender as soon as possible and destroy this message. While
>TNCO, Inc. uses virus protection, the recipient should check this email
>and any attachments for the presence of viruses. TNCO, Inc. accepts no
>liability for any damage caused by any virus transmitted by this email.
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
>
>This electronic transmission is strictly confidential to TNCO, Inc. and
>intended solely for the addressee. It may contain information which is
>covered by legal, professional, or other privileges. If you are not the
>intended addressee, or someone authorized by the intended addressee to
>receive transmissions on behalf of the addressee, you must not retain,
>disclose in any form, copy, or take any action in reliance on this
>transmission. If you have received this transmission in error, please notify
>the sender as soon as possible and destroy this message. While TNCO, Inc.
>uses virus protection, the recipient should check this email and any
>attachments for the presence of viruses. TNCO, Inc. accepts no liability for
>any damage caused by any virus transmitted by this email.
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada