سلام
اینو هم تست کنید .
Private Sub Command1_Click()
Me.Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db1.mdb;Persist Security Info=False"
Me.Adodc1.RecordSource = "SELECT * FROM Table1 where Amount='0'"
Me.Adodc1.Refresh
MsgBox "RecordCount = " & Adodc1.Recordset.RecordCount
End Sub
Private Sub Command2_Click()
'Err.Description = Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Me.Adodc1.Recordset.Filter = "EntrID = '2' or EntrID = '9'"
'Err.Description = Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Me.Adodc1.Recordset.Filter = " EntrID = '2' and EntrID = '9'"
Me.Adodc1.Recordset.Filter = " EntrID = '2'"
'Me.Adodc1.Recordset.Requery
MsgBox "RecordCount = " & Adodc1.Recordset.RecordCount
End Sub