I am trying to put all records between two dates into a recordset.
However, with the following piece of code, Visual Basic 4.0 (Enterprise)
screams "Error 13 - Type Mismatch" when it gets to the line to open the
Temp is never defined. Text1 through Text6 should contain numeric values.
The database object (DataNarf) does work... it works everywhere else in
---- BEGIN CODE ----
temp = text1.Text & "/" & Text2.Text & "/" & Text3.Text
StartDate = CDate(temp)
temp = Text4.Text & "/" & Text5.Text & "/" & Text6.Text
EndDate = CDate(temp)
SQL$ = "Select * from Server_Callinfo Where CallTime BETWEEN '" &
StartDate & "' AND '" & EndDate & "'"
Set RecordZort = DataNarf.OpenRecordset(SQL$, dbOpenDynaset)
---- END CODE ----
If you can figure out what I'm doing wrong, please email me. I've got a
deadline breathing down my neck... :/