.NET Framework 版本:4.0.30319.1
Foxtable 版本:2024.10.20.1
错误所在事件:
详细错误信息:
日期的语法错误 在查询表达式 '质量判定= '不合格'And [工艺内容].完成加工日期 >= ## And [工艺内容]
.........
jb.Filter = "质量判定= '不合格'And {工艺内容}.完成加工日期 >= #" & ymd1.value & "# And {工艺内容}.完成加工日期 <= #" & ymd2.value & "#"
If jb.Filter <> Nothing Then 如何判断 jb.Filter结果不为空?
jb.Build()
Dim Book As New XLS.Book(ProjectPath & "Attachments\差错事故日报表.xls")
Dim fl As String = "Y:\wjzl\" & "表单" & "\" & "差错事故日报表\" & Date.Today & ".xls"
Dim Sheet As XLS.Sheet = Book.Sheets(0)
Book.Build() '生成报表
Book.Save(fl)
Dim Proc As New Process
Proc.File = fl
Proc.Start()
End If