一段代码,用于查询日期数据,执行后会出现“编译错误,子程序或者函数没有定义”,而其它查询都可以。这是为什么??求救!Private Sub cmdDate_Click()
Dim sql As String
Dim date1 As String
Dim date2 As String
If Trim(txtYear(0).Text) = "" Or Trim(txtYear(1).Text) = "" Then
MsgBox " 请填写年份!"
Exit Sub
End If
If Trim(Combo1(0).Text) = "" Or Trim(Combo1(1).Text) = "" Then
MsgBox "请填写月份!"
Exit Sub
End If
If Trim(Combo2(0).Text) = "" Or Trim(Combo2(1).Text) = "" Then
MsgBox "请填写日期!"
Exit Sub
End If
date1 = Trim(txtYear(0).Text) & "-" & Trim(Combo1(0).Text) & "-" & Trim(Combo2(0).Text)
date2 = Trim(txtYear(1).Text) & "-" & Trim(Combo1(1).Text) & "-" & Trim(Combo2(1).Text)
sql = "select * from bill where regdate<'" & date2 & "' and regdate>'" & date1 & "' order by -noid"
Adodc1.RecordSource = sql
Adodc1.Refresh
End Sub
Dim sql As String
Dim date1 As String
Dim date2 As String
If Trim(txtYear(0).Text) = "" Or Trim(txtYear(1).Text) = "" Then
MsgBox " 请填写年份!"
Exit Sub
End If
If Trim(Combo1(0).Text) = "" Or Trim(Combo1(1).Text) = "" Then
MsgBox "请填写月份!"
Exit Sub
End If
If Trim(Combo2(0).Text) = "" Or Trim(Combo2(1).Text) = "" Then
MsgBox "请填写日期!"
Exit Sub
End If
date1 = Trim(txtYear(0).Text) & "-" & Trim(Combo1(0).Text) & "-" & Trim(Combo2(0).Text)
date2 = Trim(txtYear(1).Text) & "-" & Trim(Combo1(1).Text) & "-" & Trim(Combo2(1).Text)
sql = "select * from bill where regdate<'" & date2 & "' and regdate>'" & date1 & "' order by -noid"
Adodc1.RecordSource = sql
Adodc1.Refresh
End Sub
解决方案 »
- 请教一个有关VB中用HTTP自动上传文件到WEB服务器的问题
- 弟弟(小学)的数学题,用VB搞不定
- 安装vb后,在保存一个工程或窗体文件名敲入正确但在显示时却是乱码。
- www.programfan.com 这里不错哦!
- sql如何插入图片?
- 请高手赐教?帮帮我呀!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- 用VB写的DLL(已生成),可不可以转换成有原码的制作DLL过程??
- VB6.0有没有像C++中虚函数的东西吗
- 关于读取文件的一个问题
- 很急:我在ActirveReport的pageheader和detail中用line划线作表格,为什么每行的线是断开的。我该怎样做表格报表。切切,先谢了!
- 用VB开发纸牌游戏!
- 还是关于datagrid,请看~
sql = "select * from bill where regdate<#" & cdate(date2) & "# and regdate>#" & cdate(date1) & "# order by -noid"