من يه برنامه اي نوشتم كه بتونه جستجو كنه ولي نمي دونم چرا بعد از جستجو ديگه كار نميكنه !
[code:1]
Private Sub Command1_Click()
Dim search As Variant
sstr = Text5.Text
Form1.Data1.Recordset.FindFirst Name & "='" & sstr & "'" ' Look for the record that has a value "sstr"
If Trim(sstr) <> "" Then
If Form1.Data1.Recordset.NoMatch Then 'check if the record exist
MsgBox "Not Found"
Beep
Else
Form1.Data1.RecordSource = "SELECT * FROM TableName WHERE Name='" & sstr & "'" ' Display all the Records that has a Value of "sstr"
End If
End If
End Sub[/code:1]
مثلا بعد از جستجو يك فايل ديگه رو كه باز مي كنم باز نميكنه ! (*.mdb)
[code:1]
Private Sub Command1_Click()
Dim search As Variant
sstr = Text5.Text
Form1.Data1.Recordset.FindFirst Name & "='" & sstr & "'" ' Look for the record that has a value "sstr"
If Trim(sstr) <> "" Then
If Form1.Data1.Recordset.NoMatch Then 'check if the record exist
MsgBox "Not Found"
Beep
Else
Form1.Data1.RecordSource = "SELECT * FROM TableName WHERE Name='" & sstr & "'" ' Display all the Records that has a Value of "sstr"
End If
End If
End Sub[/code:1]
مثلا بعد از جستجو يك فايل ديگه رو كه باز مي كنم باز نميكنه ! (*.mdb)