Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


I need help with adodc.recordset.find

I need help with adodc.recordset.find

I need help with adodc.recordset.find

Please, can someone explain the meaning and syntax of the find function

adodc1.recordset.find(arguments explanation with example)

.Thank you

RE: I need help with adodc.recordset.find

        Dim objConn As New ADODB.Connection
        Dim objRS As New ADODB.Recordset
Dim objCmd As New ADODB.Command
Dim tblName1 As String

objConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\ACCESS\CostCtr.mdb;Persist Security Info=False")
        'objRS.CursorType = adOpenDynamic
objRS.LockType = ADODB.LockTypeEnum.adLockOptimistic
objRS.CursorType = ADODB.CursorTypeEnum.adOpenDynamic

'setting the Active Connection for the command object

tblName1 = "COST_WORK_TABLE"
objRS.Open(tblName1, objConn, , , ADODB.CommandTypeEnum.adCmdTable)

objRS.Find("KEY = '" & strKey & "'")

In the table the recordset has a field called Key which contains the employee ID.  This is doing a search of the contents of Key and finding a match to strKey.  StrKey is a string field that contains the employee's ID.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close