|
问题1 strWhere 这里是条件字符串
等值于 DateDiff('d', Date(), 付款日期)<= " & Me.签约时间开始 & " and DateDiff('d', Date(), 付款日期)>=0
也就是
Me.b.Form.RecordSource = "select * from b where " & strWhere
等值与
Me.b.Form.RecordSource = "select * from b where DateDiff('d', Date(), 付款日期)<= " & Me.签约时间开始 & " and DateDiff('d', Date(), 付款日期)>=0"
问题2,3,4 在帮助上都写得很清楚,请按f1查看
问题5 倒数第二列的索引===rs.Fields.Count - 2
那么就是
Replace(rs.Fields(rs.Fields.Count - 2), ".", "-")
[ 本帖最后由 Henry D. Sy 于 2008-12-16 11:45 编辑 ] |
|