show records in a group of 10

[ashish sharma]

hi Everyone!
i have a pb. in my project(vb and access).The database i'm having (Ms-Access is used as database)contains a large no of records(55000 items).i need to display the items in the listbox but when i query the databse to bring records using orderby and loop thru the recordset listbox contents seems to swing while populating.

can it be possible to display records in a group of 10/20 .is there any query for this..if i try select top 10 (or %) ,1st ten will be displayed but what about remaining? how an i solve this.i have next and prev button at the top of list
for disp records in a group but couldn't implement it.Pl. send code if anyone has.

help me

ashish sharma

[Bombdrop]

Quick reply take a look at the Pagesize property of the recordset object this should be what you need.!!


Hope this helps!!!

[ashish sharma]

Quick reply take a look at the Pagesize property of the recordset object this should be what you need.!!


Hope this helps!!!

but how to use it. i dont know.pl give me code

[Hack]

Welcome to the forums.

AbsolutePage And PageSize