Find / Find next routine using ADO 
Author Message
 Find / Find next routine using ADO

Does anyone have a Find / Find Next routine that can be used with ADO as Im
having a problem working out the logic.

Some things im looking for:
Return to original row if not found
Find first occurence from 1st row
Move to next matching record

Not a big deal but my head hurts.

Regards
Don Grover



Mon, 18 Aug 2003 08:02:57 GMT  
 Find / Find next routine using ADO
Donald,

No routine,

Syntax
Find (Criteria, [SkipRows], [SearchDirection], [Start])

rsData.MoveFirst
Do While rsData.EOF = False
    rsData.Find Field.Value = something, 1, adSearchForward
    display data
Loop

Bruce H


Quote:
> Does anyone have a Find / Find Next routine that can be used with ADO as
Im
> having a problem working out the logic.

> Some things im looking for:
> Return to original row if not found
> Find first occurence from 1st row
> Move to next matching record

> Not a big deal but my head hurts.

> Regards
> Don Grover




Mon, 18 Aug 2003 12:10:19 GMT  
 Find / Find next routine using ADO
Don,

"> > Some things im looking for:

Quote:
> > Return to original row if not found

If your rec set supports it - set a bookmark - you can return to that.
Quote:
> > Don Grover




Mon, 18 Aug 2003 22:08:48 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Find/Find Next Overflow Problem with Rich Text Box

2. Finding next record in an ADO data-aware class

3. ADO.Find - and the next record...

4. Help! Code using Find{Next,Previous} in RecordsetClone

5. Finding the Factorial using For/Next Loop

6. Finding date field using LIKE operator using ADO

7. Using Find and Replace to find Section Breaks

8. Find multiple words Using MS Word Find

9. Writing Find and Replace Dialogs using RichTextBox.Find Function

10. Problem find a DATE (TIME) field using ADO

11. Find a date field using LIKE and ADO

12. How to find a record in a file by using ADO

 

 
Powered by phpBB® Forum Software