why Recordset not working

[Wahab]

Hi everybody
I'v created rst but its not working please let me know where I m doing wrong:

Set rst = CurrentDb.OpenRecordset("SELECT * FROM [Overtime Data] WHERE
CardNo = " & CardNo & " and OTMonth = # " & Format(OTMonth, "mm/dd/yy") & "#")
If rst.EOF Then
NormalOT = rst!Nor: NormalAmt = rst!NorAmt
else
end if
rst.close
end if
my idea is to have all Overtime data in one table after paying the overtime,
but beofre paying may be I will call back for editing. OTMonth Im entering
end months dates, hence in a table CardNo and OtMonth is PrimeryKey.

Thanks

 

[Wolfgang Kais]

Hello Wahab.

Hi everybody
I'v created rst but its not working please let me know where I'm
doing wrong:

Set rst = CurrentDb.OpenRecordset("SELECT * FROM [Overtime Data]" & _
" WHERE CardNo=" & CardNo & " and" & _
" OTMonth=# " & Format(OTMonth, "mm/dd/yy") & "#")
If rst.EOF Then
NormalOT = rst!Nor
NormalAmt = rst!NorAmt
End If
rst.close

my idea is to have all Overtime data in one table after paying
the overtime, but beofre paying may be I will call back for editing.
OTMonth Im entering end months dates, hence in a table CardNo and
OtMonth is PrimeryKey.

Thanks

Do you have regional settings other than english?
Especially a date separator?
Try Format(OTMonth, "mm\/dd\/yy") instead.

 

[Wahab]

Thanks Wolfganf
I fixed it , problem was not in the recordset but i wasnot updating the
recordset, now its working fine.
Regards
Wahab

Hello Wahab.

Hi everybody
I'v created rst but its not working please let me know where I'm
doing wrong:

Set rst = CurrentDb.OpenRecordset("SELECT * FROM [Overtime Data]" & _
" WHERE CardNo=" & CardNo & " and" & _
" OTMonth=# " & Format(OTMonth, "mm/dd/yy") & "#")
If rst.EOF Then
NormalOT = rst!Nor
NormalAmt = rst!NorAmt
End If
rst.close

my idea is to have all Overtime data in one table after paying
the overtime, but beofre paying may be I will call back for editing.
OTMonth Im entering end months dates, hence in a table CardNo and
OtMonth is PrimeryKey.

Thanks

Do you have regional settings other than english?
Especially a date separator?
Try Format(OTMonth, "mm\/dd\/yy") instead.