MS SQL Server ODBC - show the next 30 records in a limited path-through query

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

show the next 30 records in a limited path-through query

Sam

2005-06-03, 3:23 am

my access application links to sqlserver odbc
the form RecordSource is an path-through query limited to max 30 records

1. how can i show the next 30 records?
2. how can i find a spesific record placed out of the shown records?

thanks
sam

Sue Hoegemeier

2005-06-06, 7:23 am

1. You can find examples of how to page through a recordset
at:
http://www.aspfaq.com/show.asp?id=2120
2. Write another query that finds a record based on criteria
you specify

-Sue

On Fri, 3 Jun 2005 11:01:49 +0200, "Sam"
<focus10@zahav.net.il> wrote:

>my access application links to sqlserver odbc
>the form RecordSource is an path-through query limited to max 30 records
>
>1. how can i show the next 30 records?
>2. how can i find a spesific record placed out of the shown records?
>
>thanks
>sam
>

Sponsored Links