all,
I am getting a syntax error on the findfirst line here:
Code:
dim sDate as Date
sDate = "5/5/2005"
'OPEN TABLE
rs.MoveLast
rs.MoveFirst
i = 0
'LOCATE STARTING POINT
rs.FindFirst "[orderdate] => " & sDate
I'm not fond of using dates in anything. I have no idea how to get rid of the error. The syntax error is missing operator. The formats for the date variable I've tried are:
#5/5/2005#
I have also tried variations of the findfirst line:
rs.FindFirst "[orderdate] => #" & sDate & "#" (when variable is in quotes)
rs.FindFirst "[orderdate] => #5/5/2005#"
I have not tried the findfirst line with (). Can I get suggestion here as to what to try next? I have tried the importing routine to check for corruption. That did not correct the problem. thanks!
(I think access might be evaluating the data variable "/" signs as arithmetic operators. that would make sense with the warning messages. that doesn't shed any more light for me though!).