+ -
当前位置:首页 → 问答吧 → 为什么5个记录集中,有一个打不开?

为什么5个记录集中,有一个打不开?

时间:2011-08-02

来源:互联网

Dim CUSTEMER As New ADODB.Recordset
Dim MAC As New ADODB.Recordset
Dim DATEO As New ADODB.Recordset
Dim DATEP As New ADODB.Recordset
Dim TYPES As New ADODB.Recordset

Private Sub Form_Load()
j = "结帐日期 is null"
'初始化各个组合框
querydata "select distinct(客户) from sell where " & j, CUSTEMER
querydata "select distinct(适合机型) from sell where " & j, MAC
querydata "select distinct(订货日期) from sell where " & j, DATEO
querydata "select distinct(型号) from sell where " & j, TYPES
querydata "select distinct(结帐日期) from sell " & j, DATEP
Set DataCombo1.RowSource = CUSTEMER
DataCombo1.ListField = "客户"
Set DataCombo2.RowSource = MAC
DataCombo2.ListField = "适合机型"
Set DataCombo3.RowSource = DATEO
DataCombo3.ListField = "订货日期"
Set DataCombo4.RowSource = TYPES
DataCombo4.ListField = "型号"
Set DataCombo5.RowSource = DATEP
DataCombo5.ListField = "结帐日期"
End Sub

前面4个记录集合都打开了,惟独DATEP没打开 请大家帮以下忙,鄙人多谢啦!

作者: blackeagleX   发布时间: 2011-08-02

querydata "select distinct(结帐日期) from sell " & j, DATEP 
改成
querydata "select distinct(结帐日期) from sell where " & j, DATEP

作者: djmake   发布时间: 2011-08-02

热门下载

更多