show records in a group of 10

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

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


Hope this helps!!!
:wave: :thumb: :wave:

Quote:

---

Originally Posted by Bombdrop

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


Hope this helps!!!
:wave: :thumb: :wave:

---

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

Welcome to the forums. :wave:

AbsolutePage And PageSize