Displaying records on multiple pages

[lovejaeeun]

Hi,

I have a MS Access 2000 backend and want to show the result of a query on multiple pages (if necessary). To my knowledge, the PageCount and PageSize properties don't work so it looks like i have to hand code it?

Can someone point me in the right direction? I would like the code to be as efficient as possible.

Thanks!

 

[pgferro]

search 'paging', lots of threads....

 

[ChrisHirst]

also to get page count to work will need the cursor set to client side.





Chris.

Indifference will be the downfall of mankind, but who cares?

 

[lovejaeeun]

ChrisHirst,

Are you saying that MS Access supports PageCount, PageSize properties? - but I just have to set the cursor to client side?

lovejaeeun

 

[DreXor]

this would be a good starting point:

http://www.15seconds.com/Issue/010308.htm

 

[lovejaeeun]

Thanks, the links have been very helpful.

However, one of the methods involves using a local/client-side cursor. I can't seem to get this to work:

Is this property supported by MS Access?

Thanks.

 

[ChrisHirst]

If the property is objRS.cursorlocation, yes it is supported.


Chris.

Indifference will be the downfall of mankind, but who cares?