اینم کد
Private Sub Command4_Click()
Dim rs As New ADODB.Recordset
Dim cnn As New ADODB.Connection
cnn.ConnectionString = "provider=microsoft.jet.oledb.4.0;data source=d:\entesharat\entesharat.mdb"
cnn.Open
r = Text1.Text
rs.Open "select * from cd where code_cd='" + r + " '", cnn, adOpenDynamic
Text4.Text = rs("name_cd")
Text3.Text = rs("vertion")
Text2.Text = rs("tarikh")
Text5.Text = rs("tozihat")
DataCombo1.Text = rs.Fields("noe_cd")
Text1.Enabled = False
Text2.Enabled = True
Text3.Enabled = True
Text4.Enabled = True
Text5.Enabled = True
DataCombo1.Enabled = True
cnn.Close
End Sub
البته بعضی جاها هم این اررور رو میده
item cannot be found collection corresponding to the
request name or ordinal
Form15.Text1.Text = rs("code")
اینم کد اررور بالایی
Private Sub Command4_Click()
Dim rs As New ADODB.Recordset
Dim rx As New ADODB.Recordset
Dim rz As New ADODB.Recordset
Dim cnn As New ADODB.Connection
cnn.Open "provider=microsoft.jet.oledb.4.0;data source=d:\entesharat\entesharat.mdb"
If Text1.Text <> Empty Then
r = Text1.Text
rs.Open "select * from darkhast where code=" + r + "", cnn, adOpenKeyset, adLockPessimistic, adCmdText
Text3.Enabled = True
Text4.Enabled = True
Text5.Enabled = True
Text6.Enabled = True
Form15.Text2.Text = rs("code_cd")
Form15.Text3.Text = rs("family")
Form15.Text4.Text = rs("name_cd")
Form15.Text5.Text = rs("tarikh")
Form15.Text6.Text = rs("saat")
End If
If Text2.Text <> Empty Then
r = Text2.Text
rx.Open "select * from darkhast where code_cd='" + r + "'", cnn, adOpenKeyset, adLockPessimistic, adCmdText
Text3.Enabled = True
Text4.Enabled = True
Text5.Enabled = True
Text6.Enabled = True
Form15.Text1.Text = rs("code")
Form15.Text3.Text = rs("family")
Form15.Text4.Text = rs("name_cd")
Form15.Text5.Text = rs("tarikh")
Form15.Text6.Text = rs("saat")
End If
If Text1.Text <> Empty And Text2.Text <> Empty Then
r = Text1.Text
x = Text2.Text
rz.Open "select * from darkhast where code=" + r + " and code_cd='" + x + "'", cnn, adOpenKeyset, adLockPessimistic, adCmdText
Text3.Enabled = True
Text4.Enabled = True
Text5.Enabled = True
Text6.Enabled = True
Form15.Text2.Text = rs("code_cd")
Form15.Text3.Text = rs("family")
Form15.Text4.Text = rs("name_cd")
Form15.Text5.Text = rs("tarikh")
Form15.Text6.Text = rs("saat")
End If
cnn.Close
End Sub
نکته دیگه اینکه من این فیلد رو در جدولم دارم اما نمی دونم چرا می گه نمی تونه پیدا کنه !!!!
item cannot be found collection corresponding to the
request name or ordinal
و این اررور ها و مشکلات فقط در مورد رشته ها وجود داره و من توی عددها این اررورها رو ندارم و سرچ درست انجام می شه