Greetings,

 

     I was just wondering if anyone knows how to get the page where a 

record is located in a recordset. Coz' I have this list of records in the 

right frame and clicking on a record would show that record in the left 

frame. But in addition to the record list I also have navigation in the 

left frame (first|prev|next|last) using recordset paging. 



     To display the record that was clicked, I use the AutoNumber/UniqueID 

of that record in a select statement but then I would loose the paging 

since I would only be retrieving a single record.



     In other words, I need a way to zero-in on the record chosen while 

still having the ability to do "first|prev|next|last" navigation in the 

recordset. Hhhhmm, maybe I'm doing it the wrong way, eh?



     I would appreciate it immensly if anyone has any bright ideas.

   

     Thanx =o)

Maybe apply the filter property to the recordset to display the one record,

and then unapply the filter before further navigation.



-- Z







----- Original Message -----

From: "Devlin de Falco" <webmaster@o...>

To: "Access ASP" <access_asp@p...>

Sent: Saturday, December 01, 2001 2:29 AM

Subject: [access_asp] Determine the page of a given a recordID in a

recordset.





> Greetings,

>

>      I was just wondering if anyone knows how to get the page where a

> record is located in a recordset. Coz' I have this list of records in the

> right frame and clicking on a record would show that record in the left

> frame. But in addition to the record list I also have navigation in the

> left frame (first|prev|next|last) using recordset paging.

>

>      To display the record that was clicked, I use the AutoNumber/UniqueID

> of that record in a select statement but then I would loose the paging

> since I would only be retrieving a single record.

>

>      In other words, I need a way to zero-in on the record chosen while

> still having the ability to do "first|prev|next|last" navigation in the

> recordset. Hhhhmm, maybe I'm doing it the wrong way, eh?

>

>      I would appreciate it immensly if anyone has any bright ideas.

>

>      Thanx =o)




>

> Read the future with ebooks at B&N

>

http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid

=rn_ebooks

Just pass the query criteria as well as the record number from the

right-hand frame to the left hand frame.



When the user clicks on any of the Navigation links, recreate the recordset

and move to the appropriate record.



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Devlin de Falco" <webmaster@o...>

Subject: [access_asp] Determine the page of a given a recordID in a

recordset.





: Greetings,

:

:      I was just wondering if anyone knows how to get the page where a

: record is located in a recordset. Coz' I have this list of records in the

: right frame and clicking on a record would show that record in the left

: frame. But in addition to the record list I also have navigation in the

: left frame (first|prev|next|last) using recordset paging.

:

:      To display the record that was clicked, I use the AutoNumber/UniqueID

: of that record in a select statement but then I would loose the paging

: since I would only be retrieving a single record.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~