searching for a specific record

[schatsi]

hi there

im a vb developer - battling with access :) - 2002
i need to search for a specific record within a table in my current db

this is what i tried

Dim rst As Recordset
Dim imported As String
Set rst = CurrentDb.OpenRecordset("SELECT ImportChecker.DateOfImport, ImportChecker.ImportedAlready, ImportChecker.File FROM ImportChecker WHERE (((ImportChecker.DateOfImport)='" & Format(Now, "dd/MM/yyyy") & "') AND ((ImportChecker.File)='" & fileName & "'))"


Please HELP !!!

[JConsulting]

hi there

im a vb developer - battling with access :) - 2002
i need to search for a specific record within a table in my current db

this is what i tried

Dim rst As Recordset
Dim imported As String
Set rst = CurrentDb.OpenRecordset("SELECT ImportChecker.DateOfImport, ImportChecker.ImportedAlready, ImportChecker.File FROM ImportChecker WHERE (((ImportChecker.DateOfImport)='" & Format(Now, "dd/MM/yyyy") & "') AND ((ImportChecker.File)='" & fileName & "'))"


Please HELP !!!

Dim rst As DAO.Recordset
Dim imported As String
Dim strSQL As String
' Where is FileName coming from? the form?
strSQL = "SELECT ImportChecker.DateOfImport, ImportChecker.ImportedAlready, ImportChecker.File FROM ImportChecker" & _
" WHERE ImportChecker.DateOfImport=#" & Format(Now, "dd/MM/yyyy") & "# AND ImportChecker.File='" & FileName & "';"
Set rst = CurrentDb.OpenRecordset(strSQL)
 

see comments in the code
J