我用vb做的东西怎么一直出现“对象量或with块未设置”?帮看看Private Sub Form_Load()
Dim txtSQL As String
Dim MsgText As String
Dim mrc As ADODB.Recordset
txtSQL = "select distinct typename from roomtype"
Set mrc = ExecuteSQL(txtSQL, MsgText)
( If Not mrc.EOF Then)---------这提示错
Do While Not mrc.EOF
Combo1(0).AddItem mrc.Fields(0)
mrc.MoveNext
Loop
End If
mrc.Close
txtSQL = "select distinct price from roomtype"
Set mrc = ExecuteSQL(txtSQL, MsgText)
(If Not mrc.EOF Then)
Do While Not mrc.EOF
Combo1(1).AddItem mrc.Fields(0)
Combo1(2).AddItem mrc.Fields(0)
mrc.MoveNext
Loop
End If
mrc.Close
End Sub
想问是不是数据库没有连好出的问题?
Dim txtSQL As String
Dim MsgText As String
Dim mrc As ADODB.Recordset
txtSQL = "select distinct typename from roomtype"
Set mrc = ExecuteSQL(txtSQL, MsgText)
( If Not mrc.EOF Then)---------这提示错
Do While Not mrc.EOF
Combo1(0).AddItem mrc.Fields(0)
mrc.MoveNext
Loop
End If
mrc.Close
txtSQL = "select distinct price from roomtype"
Set mrc = ExecuteSQL(txtSQL, MsgText)
(If Not mrc.EOF Then)
Do While Not mrc.EOF
Combo1(1).AddItem mrc.Fields(0)
Combo1(2).AddItem mrc.Fields(0)
mrc.MoveNext
Loop
End If
mrc.Close
End Sub
想问是不是数据库没有连好出的问题?
解决方案 »
- textbox控件的keypress和keydown事件无法捕捉到tab键,怎么回事?
- 错误提示:word无法启动转换器mswrd632.wpc
- 求一段vb代码,望高手赐教!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- 各大高手,关于VB中一简单的问题!
- 求教一个SQL语句(存储过程能否实现?)
- 如何编写“另存为”二进制文件?
- 不显示删除回复显示所有回复显示星级回复显示得分回复 告诉大家:CSDN的漏洞远不止明文密码这么简单,漏洞多了去了
- COM+问题
- 100分征集PowerPoint组件的详细资料!急
- 50分的简单问题。。。。
- 如何拦截系统的输出操作
- 如何实现二进制的文件与中文之间的转换?紧急求助
--------------------------
改为: Dim mrc As New ADODB.Recordset