Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB Databases Basics
|
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 1st, 2006, 04:25 PM
Registered User
 
Join Date: Aug 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default AbsolutePosition counting filtered records

I'm trying to run a search feature that will impose a filter onto an open recordset and display the filtered records. It works correctly, but when I try to display at the bottom of the page "Record # of ##", using the absolute position and record count properties, I'm getting the wrong data. To get the data, I have:
Code:
txtRecord = rsPerson.AbsolutePosition
txtTotal = rsPerson.RecordCount
Fairly simple, right? And the record count gives me the correct number of records, but the absolute position gives me where that record would be in the unfiltered recordset.

Which means I'm displaying thinsg like: Record 7 of 3, as the first returned record. What am I missing?
 
Old August 17th, 2006, 04:24 AM
Authorized User
 
Join Date: Sep 2003
Posts: 73
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to prabodh_mishra
Default

Try using "rsPerson.CursorLocation = adUseClient" if not using already...

Cheers
Prabodh





Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting Child Records BrianWren VB Databases Basics 1 June 2nd, 2008 04:32 PM
Counting records Jonas Access 4 August 4th, 2006 09:07 AM
Filtered Sharepoint list, not filtered in infopath wmrdude SharePoint Development 0 July 26th, 2006 05:09 AM
A Cursor counting records chubnut SQL Server 2000 12 July 8th, 2004 01:58 PM
Grouping and Counting records Con Access VBA 1 September 17th, 2003 11:31 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.