Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    Visual Basic




Adodc2.Recordset.Find Sample


I am attempting to locate some sample code that used the FIND command. My project is using ADO data access with a Adodc object. I want to move the record pointer to a specific record so that I can edit the record. When I open a form I pass the record ID to the form through a global variable. If I use an SQL query it works find but limites the record set to that one record. I want the entire record set but just move the record pointer to that specific record. Any help would be apprecated. The method I am trying to do is as follows;

Adodc2.Recordset.Find (sRecordID) & " = '" & gsRecordID & "'", 1, adSearchForward

But this fails. However, you can get the idea. the sRecordID is the field name in the table and the gsRecordID is the global variable with the record ID that is passed to the form when it opens.




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Sample Application Ado Find Record
Hi

Can anyone send me a sample application in VB6 ( with MS access database, ADO data control )which will use ado's seek or find method for searching recordset.
User will force to put value in input box or will select item from combo list and will press search button.Than particular recordset will be displayed in relevant textboxes or data grid control..

Please send it to my personal email id i.e email@removed

Thanks in Advance
Santosh

Recordset.Find Doesn't Find Very First Record In Recordset
Hi,


I am trying to find a record in a recordset using the code below. If the record is not there, the user is informed. This works fine for all records in the recordset except when I am looking for  the very first record. In this case, I am always informed that it is not there and I know that it definitely is.

here's the code


'Check to see if employee is still with company.

CurrentEmpl = "SELECT * FROM Employee WHERE Leaving_Date Is Null;"

Set RS = cn.Execute(CurrentEmpl)
RS.MoveFirst
RS.Find "emp_id =" & txtemp_id.Text, adSearchForward

If RS.EOF = True Then
    MsgBox (" This person has left the company.")
Else
    'more code
End If

All ideas welcome


Code Sample For A Find/Replace In Textbox
Does Anyone Know How to do a Find and Replace in a Text box Using Visual Basic 6

Macro To Search Thru Sheets And Find Sample ID Numbers
Hi,
I'm a little familar with VB but not enough. I'm trying to write a macro that will use a list of sample numbers (ID's) and search a series of worksheets for these numbers. Once the number has been found I want a new column to be inserted or at least the values from that related column copied to a new worksheet.

These are the steps I'm trying to do (Step One is my huddle at this point):
1)Find sample ID’s using “Find” on a list of samples; whether grouped together or separated into their distinct areas.
2)Insert column (“Mass of Chemicals”) next to Qualifiers column.
3)Calc mass of chemical removed by multiplying Mass of Soil by Conc of Chem.
4)Repeat Step 2 for all chemicals, return blank for missing values.
5)Stop at bottom of list of chemicals (row 186?).
6)Find next sample ID (ie repeat Step 1) till all samples in list have been found

Here's the code I recorded and started modifying.
' Copy Cell
Range("C2").Select
Selection.Copy
' Select Workbook
Windows("exca-macro-test.xls").Activate
Sheets("sead4soillt043100").Select
Rows("4:4").Select
Range("V4").Activate
Selection.Find(What:="43039", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False).Activate

' Next sheet
Sheets("sead4soilgt043100").Select
Rows("4:4").Select
Selection.FindNext(After:=ActiveCell).Activate
Range("F36").Select
' Next Sheet
Sheets("sead-4-soil-2in-deeper").Select
Rows("4:4").Select
Range("AE4").Activate

End Sub

I want the Find command to ge a variable so it takes it value for the list of sample numbers.

Any help would be greatly appriciated.

Hey! I Was Wondering If Anyone Knew Where I Can Find Sample Labs Or Somthing To Help!
Hello, i have 2 visual basic books but they both arn't helping much becuase i read it, over and over again but they have no part of the book that says here is what we want, so make it from the information you just read in this chapter, if it had that it would help me learn alot better! do you know any websites that have those kinda labs? like little projects but not ones that stray off into stuff you don't even know, thats what both the books do as well, they would be writing a code for a calculator(a tax) and then they use a function like CInt() and they never told you what any of this **** is! heh very confusing, and i have read the 1 book once alraedy and i'm reading it again to get more out of it. But anyways, if yuou know any web sites that have projects to do, send them on over! thanks for listening!

Send A Sample Heirarchical FlexiGrid Sample With Dynamic Data
hi

Can any one send me a Heirarchical FlexiGrid Sample program with dynamic data or else with run time database connection and loading the data

Recordset.Find
I am trying to use the Find method and cant seem to get it right.
I get a run time error # 3001

"Arguments are the wrong type, are out of range, or are in conflict with one another."

Not sure what that all means, or what to try next

Here is my code:
Private Sub cmdEdit_Click()
X = DataGrid1.Columns(1).Value
frmProd.Show
frmProd.Adodc1.Recordset.Sort = "prod_Id"
frmProd.cmdSwitch.Caption = "&Vendor"
frmProd.DataGrid1.Refresh
frmProd.dbVenProd.Recordset.Filter = "pro_id = '" & Format(frmProd.txtProdID.Text, "0000") & "'"
With frmProd.Adodc1.Recordset
.MoveFirst
.Find "pro_id like = '" & X & "'"
End With
frmProd.txtProdID.Text = X
End Sub

I get a value for "X", but that is about all I get

Dale S

Can't Find Recordset!
Hallo Hi..
Is there anybody can give me idea to solve I think a very simple problem but I still cannot solve so far. Here is my code:

Private Sub cmdFind_Click()
Dim strDate As String, strSQL As String

strDate = Text1.Text
strSQL = "select * From myTable where date = #" & CDate(strDate) & "#"
Set rs1 = db.OpenRecordset(strSQL)

rs1.FindFirst "Date = #" & strDate & "#"
If rs1.NoMatch Then
MsgBox ("Not Found")
Else
MsgBox ("Found " & rs1!Date)
End If

End Sub

There are four records in myTable. In the field Date ( 01/01/01,02/01/01,03/01/01 and 04/01/01). When I search the date 01/01/01 through my text box, it found. But when I search the date 02/01/01 or 03/01/01 it cannot found. That mean only the first record int the table can be found, the others cannot be found.
Thank you...

Find Recordset Using SQL
Hallo Hi...
I'm having problem to find record using SQL statement. Below is my code. The problem happen when I replaced with the variable (strDate) because I want the user to key in the value through the text box.

Private Sub cmdFind_Click()
Dim strDate As String

strDate = Text1.Text

strSQL = "SELECT * FROM myTable where Date = '" & strDate & "'" ' problem in this line
Set rs1 = db.OpenRecordset(strSQL)

' display the date in the list box

Do While Not rs1.EOF
List1.AddItem rs1!Date
rs1.MoveNext
Loop

End Sub

thank you...

Help With Recordset.find
*EDIT* nevermind, i got it.

Recordset FIND
Hi everybody, A question: I have an ADODC in a form, and I have to find a value: I always used something like this:

Adodc1.Recordset.Find ("code_id=" & IdCode)

But if I need to find two values ... I tried with:

Adodc1.Recordset.Find ("code_id=" & IdCode & "AND code2_id=" & IDCode2) don't works.

Does anybody knows how can I do this? Thanks

Recordset.find Help....
vb6, ado, jet(access)

please help me with my code... i don't know the exact syntax... i'm trying to compare the data in my textbox with my DB.. if there is a match, then it would be displayed in the data grid... please help me with the code... also, i want that if i enter a single character, it would display all the entries starting with the character being inputted.... what's the syntax?...

lastly, what is the best grid to use?...

[vb code]
Private Sub cmdFindRecord_Click()

rsFindRecord.Open "SELECT * FROM Stude_Rec", dbConnect, adOpenKeyset, adLockOptimistic, adCmdText
If Not txtIDNo.Text = "" Then
rsFindRecord.MoveFirst
rsFindRecord.Find "IDNo='" & txtIDNo.Text & "'"

Set DataGrid1.DataSource = rsFindRecord
End If

End Sub
[/vb code]

Recordset.Find
Hi,
Can anyone give me an example for:

rs As New ADODB.Recordset
rs.find

and if Found Msgbox"Match Found"

Recordset.find
Hi everyone,

I want to move backwards through a record in my ado recordset to the first records where two field conditions are met.

Here's my code:


Code:
rstNbrSharesData.Find "(Code2='" & Code & "') AND ([Date]<=#" & Format(CalcDate, "dd/mm/yyyy") & "#)", , adSearchBackward
I get the following error:

"Run time Error '3001'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another."

Any ideas as to what I'm doing wrong?

Thanks
GJ

Recordset.Find
Could someone please tell me what's wrong with this?


VB Code:
rsFCL_M_Topics.Find ("TopicName = #" & CurrentTopic & "#, -1")


Many thanks,
Paul

Recordset Help (.Find)
If I use a .find to look for a record, what happens if VB finds multiple matches?

Can I loop through and sort these matches as if they were yet another recordset?

How To Use Find With A RecordSet?
Hi,

I created a RecordSet with all the records of a table:

Set Rst = New ADODB.Recordset
wSQL = "Select * from CUSTOMERS Order by CustName"
Rst.Open wSQL, Conn, adOpenDynamic, adLockOptimistic

My question is:
How can I find a specific record inside this RecordSet and delete it?

I'm trying this code, but it always returns EOF:

Dim wSearch As String
wSearch = "CustName=" & " '" & wName & "'"

Rst.Find (wSearch)
If not Rst.EOF Then
....
....
endif


Thanks in advance...

Michel Jr.

Recordset.find
I have a recordset that calls rs1.
How can I use with "find" method in order to find numeric data.
for example: I want to get data when "title-id" field is 12
I means to code the criterion well.
Thank you

Using Find With ADO Recordset
Hello everyone!

I am working with VB6 & ADO 2.0 and I have the following problem: when I try
to make a Find in my ADO recordset and I use a criteria with two fields
(example:
Field1 = 10 And Field2 = '00') I get the following error message:
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
If I run the Find separatly then I get the results correctly (that is, the
fields are of correct type and
within the range). I look into Find for ADO recordset and It seems to admit
only
one field, but I failed to find further information. Can anyone tell me if
that is the
way the Find work in ADO? Is it there another ADO version that admit
multiple
fields in the Find criteria?

Any help would be appreciated.
Thanks
Roberto

Recordset Find
I'm having a time with trying to find a specific record using a recordset.  What is the magic?

With rsRecorset
.find ?
End with





How To Find A Row From Recordset
hello ,
            if i have a table and 100 row with 5 field,....
define a recordset like "objADORsSrc"
.....
objADORsSrc.Open (CommonDialog1.FileName), objADOConnSrc
                                  (xyz.xml)

i want read or data in a flex grid where row number 56 or any number how it is possible.?

For j = 0 To objADORsSrc.Fields.Count - 2
' vsFlexDeduped.TextMatrix(k, j + 1) = objADORsSrc.Fields(j).Value
next j


thanks in advance

Anuj

<Edit> Lankymart - Locked due to double post (view topic #141011) </Edit>





Edited by - lankymart on 2/12/2007 4:17:18 AM

How To Find A Row From Recordset
hello ,
            if i have a table and 100 row with 5 field,....
define a recordset like "objADORsSrc"
.....
objADORsSrc.Open (CommonDialog1.FileName), objADOConnSrc
                                  (xyz.xml)

i want read or data in a flex grid where row number 56 or any number how it is possible.?

For j = 0 To objADORsSrc.Fields.Count - 2
' vsFlexDeduped.TextMatrix(k, j + 1) = objADORsSrc.Fields(j).Value
next j


thanks in advance

Anuj

Recordset.find Help....
vb6, ado, jet(access)

please help me with my code... i don't know the exact syntax... i'm trying to compare the data in my textbox with my DB.. if there is a match, then it would be displayed in the data grid... please help me with the code... also, i want that if i enter a single character, it would display all the entries starting with the character being inputted.... what's the syntax?...

lastly, what is the best grid to use?...

[vb code]
Private Sub cmdFindRecord_Click()

rsFindRecord.Open "SELECT * FROM Stude_Rec", dbConnect, adOpenKeyset, adLockOptimistic, adCmdText
If Not txtIDNo.Text = "" Then
rsFindRecord.MoveFirst
rsFindRecord.Find "IDNo='" & txtIDNo.Text & "'"

Set DataGrid1.DataSource = rsFindRecord
End If

End Sub
[/vb code]

Recordset.Find
Here is my question:
I am connecting to a database using a adodc, and want to create a input box to search the recordset to find the criteria set by the user here is a short section of my code:
Private Sub cmdFindaFoundation_Click()

Dim strFoundation As String
Dim vntBookmark As Variant

strFoundation = InputBox("Enter Foundation Name", "Find Foundation Name")
If strFoundation = "" Then
MsgBox "You didn't enter a Song Title."
Else
Adodc1.Refresh
vntBookmark = Adodc1.Recordset.Bookmark
'*******This is where it gets stuck***********************
Adodc1.Recordset.Find ("Like strFoundation*")
If Adodc1.Recordset.EOF Then
Adodc1.Recordset.Bookmark = vntBookmark
MsgBox "Foundation Name not found."
End If

End If

End Sub
Thank you so much in advance for ANY help at all I have stuck for a few days on this!

ADO Recordset And Find
Hi
I´m using a Datalist which recives an ADO recordset. I want to make a kind of serach function with a textbox. I want it to work like for example "the help in VB using Indexsearch". That is when I press key it will automatically scroll to that letter/letters. But when I use recordset.find the criteria must contain "like %" and it means that this command returns a recordset and places the cursor on EOF. How can I move the cursor to the first hit so I can scroll my listbox?
I would be greatful for help.
Jenny

Find Function In Recordset
dim Z2 as integer

rsIncidents.Find "IncidentID = " & Z2


IncidentID is an Autoincrement value created when the record is created. when i look for the particular record, it always fails even tho it DOES exist.

Nothing i do will fix it, it is as tho it does not exist, but in fact it does exist.

any ideas????

Problem With Recordset.find
Hi to all,

I use ADO with Access and have a table with 2 fields: a number (book_id) and a string (id).
When trying to use the Recordset.Find method, I get the 3001 runtime error (Image file is attached).

I'm using this line:

Lends.Recordset.Find ("id='18454846' and book_id=557")

Please help me ...

Can't I use two different field type?

Thanks,

Guy.

ADO Recordset.find Error
New to VB6 (apologies if it is obvious)
How do I find data using a string variable. I am probably using the wrong syntax and I get the error - run time error 3001 - Arguments of wrong type, out of range or conflicy with another.
The code is:

Set con = New ADODB.Connection
con.ConnectionString = "File Name=c:datalinkmdb_lib.udl"

Set rssearch = New ADODB.Recordset
rssearch.CursorLocation = adUseClient
rssearch.Open _
"select ref_code from doc_main", con, adOpenStatic, adLockOptimistic

No problems listing recordset but I then use a variable with the contents of a text control
dim lcFind as string
lcFind = txtFind.text

rssearch.find "ref_code = " & lcFind '??????

Is the version of ADO relevant ?

Thanks for any help (the learning can be painful at times !)

Find Method In Recordset
Hi,

I am trying to find a record in an access databse. here is my code:


'open connection to find/query sample ID
Set cnworkorderdatabase2 = New ADODB.Connection
Set rsrecords2 = New ADODB.Recordset

With cnworkorderdatabase2
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "User ID = sa;Password=;" & _
"Persist Security Info=False; data source =" & _
"initial catalog =dsnWorkOrder"
.Open "C:WorkOrderDatabasedsnWorkOrder.mdb"
End With

'Open the recordset
rsrecords2.Open "dsnWorkOrder", cnworkorderdatabase2, adOpenDynamic, adLockOptimistic, _
adCmdTable


Dim tempstring
tempstring = txtSample.Text
MsgBox tempstring

rsrecords2.Find "SampleID = '55555555555555' "
If rsrecords2.RecordCount > 0 Then
MsgBox "record set exists"
txtY.Text = rsRecords!Y

Else
MsgBox "empty record set"
cmdAddWorkOrder.Enabled = True
End If


' rsRecords2.Close
' cnworkorderdatabase.Close



To further illustrate my question, I am writing a function that looks into the DB for records that have SampleID = 55555555555555. How do I say in VB if my find failed?

Also I'm not quite sure if the method, recordcount on the open connection, cnworkorderdatabase2 will return the total number of records in the DB or the number of records resulting from the find method. Any pointers is appreciated.

Thanks!

Recordset.Find Problem
Hi all.. i'm new to VB language and the following is a problem i'm having.. please help...

i wanted to search through a Access database based on a text input keyed in by the user. i tried to use recordset.find method in this way:

Dim inputFromUser As String

inputFromUser = textbox1.text
adotest1.recordset.find inputFromUser

i don't think i have coded it correctly, can someone kindly tell how to code it? thanks!

Find Records With The Same Name In A Recordset
Hello,
I have a recordset where I need to search for a specific name, and the code I have for that is this:
.Find "M_Nome LIKE '%" & Procura & "%'"

But this only retrieves the first record with that name, but exists more names like that in the recordset.
How can I display all the records with that name or else make something like the F3 to find the next record?

Thanks in advance.

Recordset Find/seek
Is there any way to know what position a certain record in a recordset is?

For example say I had a recordset with 10 records in it. and I did a find for "A = 'ABC'" and it went to the third record in the recordset.
How would I find the position its in?
I know recordsets are base 0 so I know it would be 2 but I'm wondering how I would programaticly find the position.

Find The Length Of The Recordset???
How to find the length of the recordset??? plz if any body can guide me???

ADO Recordset.Find For 2 Fields
I have two fields to find a recordset. But unfortunately it doesn't work at all. Can anyone help in this regard?

Query:
SELECT FIELD1, FIELD2 FROM TABLE

The following works fine
RS.FIND "FIELD2 = '" & VALUE & "'"

But I want something like this
RS.FIND "FIELD1 = '" & VALUE1 & "' AND FIELD2 = '" & VALUE2 & "'"

Thanks

Recordset.find Query
when i give code for
rec.find "id=1"
how can i know the return value
when using recordcount it is giving total number of records

Find Method Of ADO RecordSet
Hi Friends,

Can anybody tell me is that necessary to Move the Recordset Pointer to the First Rec using 'Rs.MoveFirst' before invoking the Find method of a RecordSet.

Any Suggestions are appreciatable.

Thanks,
Jai.

Recordset .Find Help Needed.
I have a disconnected recordset with 3 fields. SymbolA, SymbolB, and Value

When I want to find a record with SymbolA I do the following:

Dim SymbolA As String
SymbolA = "IBM"
Dim FindString As String
FindString = "SymbolA like '" & SymbolA & "'"
rsStocks.Find FindString, , , adBookmarkFirst

This works fine.

However, I cannot figure out how to search for a record that matches both SymbolA _and_ SymbolB. Ie: SymbolA = "IBM" and SymbolB = "GE"

I tried just putting an AND in the middle of 'SymbolA Like.." , "SymbolB like...", but that didn't work.

Help!

To Find Whether A Recordset Is Open Or Not
i want to check whether a record set is open or not if open i want to close the same
and set the variable for the same as nothing[font=arial][color=darkblue]

ADO Recordset Find Method Help!
Please help,

the following code works however although I have clientID's starting from 1 and finishing on 139, this code gives new_problem = 1 when you enter 1!!?? and doesn't for clientID 140....?


Code:

clinum = Val(frmPurchase1.txtClinum.Text)
new_problem = 0

Set rstClientcheck = New ADODB.Recordset
strSQLClientcheck = "SELECT tbl_clientID FROM tbl_Client"
rstClientcheck.Open strSQLClientcheck, conn, adOpenStatic, adLockReadOnly, adCmdText
rstClientcheck.Find "tbl_clientID LIKE " & clinum
If rstClientcheck.EOF Then
new_problem = 1
End If
rstClientcheck.Close

If new_problem > 0 Then
MsgBox ("The client number provided is invalid")



If anyone can help I'd really appreciate it.

D

Problem With Recordset.Find ???
Hi,

I'm new to Visual Basic and was wondering if anyone could help?

I have an Access 2000 database which l'm trying to find a record in which is
a text field. I have set the Option Compare Text and using the following
code

Dim varSurname As String
mrsCustomer.MoveFirst
varSurname = txtSurname.Text
mrsCustomer.Find "Surname LIKE 'varSurname'", , adSearchForward

which cant find the record that l know is in the database

Michael

Error Using Find With Ado Recordset
Hi all,

I'm trying to search for employees in an Access database using the find function with an ADO recordset. The table I'm searching consists of 3 colums:
1 EmployeeNumber
2 EmployeeName
3 SickDate

EmployeeNumber and Sickdate form the combined key of the table.

I'm searching the database using find with either the employee number or the employee name. Searching using the employee number goes fine, however when I'm trying to search using the employee name, I get an error which clearly comes from Access (as it is in Dutch, I'm using VB english version and access dutch version). The error is (translated from dutch):

Run time error 3001: The application uses arguments that or out of the allowed range or arguments that are in conflict with each other.

my code:

rsEmployees.MoveFirst
If txtEmployeNumber.Text <> Empty Then
    rsEmployees.Find ("EmployeeNumner  "                    & txtPersNummer.Text)
   If rsMedewerkers.EOF = True Then 'no numner found
    MsgBox "Specified employee not found in database!" _
                , vbExclamation, "Opgelet!"
   Else
      Showdate
   End If
Else
   rsEmployees.Find ("EmployeeName = " &  txtEmployeeName.Text)
   If rsMedewerkers.EOF = True Then 'no naam found
      MsgBox "Specified Employee name not found in database!", vbExclamation, "Opgelet!"
   Else
      ShowData
   End If
end if

I can't believe that the EmployeeName column is in conflict with a name entered in a textbox. Also the first part (searching using the employeenumber) works fine!.

Hope somebody can help me out with this.

Find Data In A Recordset
Hello all.

This is the n th post of my problem. Sorry from the ones who observe all
ngs.

I have an ADO connection with an Access 2000 .mdb file (One Index column and
20 columns conatining Text data) I need to present a find method similar to
Find command of Access (scroll through each record of the recordset and
highlight the findings). I use DataEnvironment to connect to the base, and
as far as i know, Bookmarks are supported.

'CODE

With de

..rsCommand1.MoveFirst
iRecCount = .rsCommand1.RecordCount

For i = 1 To iRecCount

varBookmark = .rsCommand1.Bookmark

For j = 1 To 20

'ADO ERROR 3001 OCCURES... (wrong type, out of bounds or arguments
error)
.rsCommand1.Bookmark = varBookmark

strFind = "Song" & j & " Like '*" & Text1.Text & "*'"

.rsCommand1.Find strFind

'For testing purposes only. It shows which field containes
valid data. Afterwards i will filter it
MsgBox "Index Nr. is " & .rsCommand1(0).Value _
& " Column Nr. is " & j

Next j

..rsCommand1.MoveNext
j = 1

Next i

End With

Find A Record // ADO Recordset
I made a sample project to view content of table with DataCombo1 component
it's give return value as in DataCombo1.Text the record doest not point to rs!anotherField

like DataCombo1 content name field
want to display another field as phone no.

Rishi Acharya

How To Find The Fields In The Recordset
hello friend,
                  im using sql server as a backend &VB6 as designer.i have 2 database in which i have same field names in the database.In the 1st database name stats & 2nd database name statsdcn.

1.i want to compare the two database
2.i want to get the fields from the database2 which contain all the fields by matching the data from the database1.
eg dcn is the field in database2,.iwant to fetch all the field detailswhich has same field(dcn) from database1.
3.i want to automate the query without entering field.


 

ADO RECORDSET FIND FUNCTION
I need to know how to use the "FIND" command on searching a field using wildcard characters

Thanks

Find With ADODB Recordset
I need to find a record in a recordset with ADODB. this is my search string

strQuery = "BankNo = '" & (strBankNo) & "'" & "And TransNo = '" & (strTransitNo) & "'"

rstrans.find strquery

but I am getting an error that it is not right.


any help

ADO Recordset - Rs.find Criteria
Hi,

How can I search a row with 2 keys :
Example:

cAuthor = "Simon"
cBookname = "VB6"
rs.find author = cAuthor AND bookname = cBookname
if rs.eof then
....
end if



But rs.find is not support for 2 conditions, how can I do that ?

Thank you

Simonkwan

Find Function In ADO Recordset
dim Z2 as integer

rsIncidents.Find "IncidentID = " & Z2


IncidentID is an Autoincrement value created when the record is created. when i look for the particular record, it always fails even tho it DOES exist.

Nothing i do will fix it, it is as tho it does not exist, but in fact it does exist.

any ideas????

ADO Recordset Find Method With (')
ADODB recordset Find Method

How can I excuse find method like this:

Dim sTr as String
ADORecordset as AODDB.Recordset

sTr = "Smith's"
ADORecordset.Find "Name ='" & sTr & "'"

The above command results an error.
Please tell me

Copyright © 2005-08 www.BigResource.com, All rights reserved