Click to See Complete Forum and Search --> : data1.recordset.findfirst causes GPF


Z.J. Da
March 24th, 1999, 03:33 PM
Hi all,


When I use


data1.recordset.FindFirst "[Date] = #3/24/99#"


to find a record in database and the table does contain a record matching it, a gpf occurs with error msg "read 0x0000:0000" (no gpf if no record matching it). However, if I use MoveFirst and MoveNext to go through the table, everything OK. Any idea?


Thank you in advance!


Da

Ahmed Saber
May 7th, 2002, 02:24 AM
Try
data1.recordset.FindFirst "format([Date],'dd-mmm-yyyy')= #24-Mar-1999#"