d1 = New Date(Year, Month, 1) '取得该月的第一天
d2 = new Date(Year, Month, Date.DaysInMonth(Year,Month)) '取得该月的最后一天
Filter = "ymyfjjad >= '" & d1 & "' And ymyfjjad <= '" & d2 & "' and rbww = '" & k & "'"
Case 2
d1 = New Date(Year, Month, 1) '取得该月的第一天
d2 = new Date(Year, Month, Date.DaysInMonth(Year,Month)) '取得该月的最后一天
Filter = "ymyfjjad >= '" & d1 & "' And ymyfjjad <= '" & d2 & "' And ffikgn = '" & ffikgn & "' and rbww = '" & k & "'"
End Select
'End If
End If
End If
With Data Tables("qrymyf")
.LoadFilter = Filter '设置加载条件
.LoadPage = 0 '加载第一页
Dim frm = e.Form.baseform
.LoadTop = 100 '每页5行
.Load()
e.Form.Controls("wvdm").Value = 1 & "/" & .TotalPages
End With
Tab les("我的设计”)Filter = Filter
Data Tables("我的设计”).LoadFil ter = Filter
Data Tables("我的设计”).Load()
e.Form.ResumeRedraw
谢谢老师!!!