Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sorting and Filtering ADO Recordsets

Status
Not open for further replies.
ViolinTim

ViolinTim

Technical User
Aug 5, 2002
3
GB

I have a very strange problem.

I have an ADO recordset that holds names and addresses and has 2225 rows. I filter this on "S" and the rows reduce to 177. If I then sort in alphabetical order only 100 rows are displayed. If I do not sort 177 rows are shown.

In essence 177 rows are shown in the recordset recordcount, but in the form that the recordset is the source for only 100 are shown.

Any ideas?
 
Sort by date Sort by votes
Check out thread 705-964612. I had the same problem and this thread has the advise I was given. Didn't help me, but might you.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Open filtered for and set cursor at particular record
Replies
1
Views
684
Moss100
Moss100
Moss100
  • Locked
  • Question
Find unique rent amount and date this was first charged
Replies
4
Views
895
dhookom
dhookom
Moss100
  • Locked
  • Question
Open New Access Database and Maximise the Application Window
Replies
0
Views
538
Moss100
Moss100
Moss100
  • Locked
  • Question
Adodo problem
Replies
7
Views
577
dhookom
dhookom
lameid
  • Locked
  • Question
ADO UpdateBatch SQL Server Example?
Replies
2
Views
514
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top