D
DS
I'm running this code and I'm getting an ISAM error. 3170
Set RS = CurrentDb.OpenRecordset("SELECT Count(*) FROM " & _
"[MSAccess;Database=\\Backoffice\C$\Warehouse\History.mdb].tblDiscountDetails
" & _
"WHERE (CDBizDay BETWEEN " & Format(Forms!frmReportDates!TxtStart,
"\#yyyy\-mm\-dd\#") & " AND " & Format(Forms!frmReportDates!TxtEnd,
"\#yyyy\-mm\-dd\#") & ") AND CDDiscountManID = " & Me.EmployeeID,
dbOpenSnapshot)
Me.TxtDiscounts = Nz(RS(0), 0)
RS.Close
I'm using XP Pro 2002 Service Pack 2
And Access 2002 Service Pack 3
Thanks
DS
Set RS = CurrentDb.OpenRecordset("SELECT Count(*) FROM " & _
"[MSAccess;Database=\\Backoffice\C$\Warehouse\History.mdb].tblDiscountDetails
" & _
"WHERE (CDBizDay BETWEEN " & Format(Forms!frmReportDates!TxtStart,
"\#yyyy\-mm\-dd\#") & " AND " & Format(Forms!frmReportDates!TxtEnd,
"\#yyyy\-mm\-dd\#") & ") AND CDDiscountManID = " & Me.EmployeeID,
dbOpenSnapshot)
Me.TxtDiscounts = Nz(RS(0), 0)
RS.Close
I'm using XP Pro 2002 Service Pack 2
And Access 2002 Service Pack 3
Thanks
DS