注册 登录
编程论坛 VB6论坛

求助那位帮忙看看。。

wbzjacky 发布于 2012-12-06 16:18, 358 次点击
运行时提示
实时错误‘91’
对象变量或with快变量为设置


Dim mybookmark As Variant  
Dim mcclean As Boolean
Dim rsd1 As ADODB.Recordset
Dim rsd11 As ADODB.Recordset

Public Sub viewdata()
txtid.Text = Trim(rsd1.Fields(0))  错误处
txtname.Text = Trim(rsd1.Fields(1))
txtbirthdate.Text = Trim(rsd1.Fields(2))
txtrxdate.Text = Trim(rsd1.Fields(3))
txtaddress = Trim(rsd1.Fields(4))
txtprofession = Trim(rsd1.Fields(5))
combosex = Trim(rsd1.Fields(6))
comboclassno = Trim(rsd1.Fields(7))

End Sub


应该设置在那里啊 是不是变量设置的位置不对。。初学望多包涵
6 回复
#2
Artless2012-12-06 19:36
txtid.Text = Trim(vstr(rsd1.Fields(0)))试试
#3
wbzjacky2012-12-07 08:56
以下是引用Artless在2012-12-6 19:36:32的发言:

txtid.Text = Trim(vstr(rsd1.Fields(0)))试试
加了提示  编译错误
          子程序或函数为定义

Public Sub viewdata()
txtid.Text = Trim(vstr(rsd1.Fields(0)))
txtname.Text = Trim(rsd1.Fields(1))
txtbirthdate.Text = Trim(rsd1.Fields(2))
txtrxdate.Text = Trim(rsd1.Fields(3))
txtaddress = Trim(rsd1.Fields(4))
txtprofession = Trim(rsd1.Fields(5))
combosex = Trim(rsd1.Fields(6))
comboclassno = Trim(rsd1.Fields(7))

End Sub

#4
Artless2012-12-07 13:34
cstr不是vstr打错了
#5
wbzjacky2012-12-08 10:27
以下是引用Artless在2012-12-7 13:34:20的发言:

cstr不是vstr打错了
实时错误‘91’
对象变量或with快变量为设置

txtid.Text = Trim(cstr(rsd1.Fields(0)))
还是提示这个错误
#6
Artless2012-12-08 13:23
rsd1打开了吗?
#7
lyfz11232012-12-09 11:04
Shishi:
txtid.Text = Trim(vstr(rsd1.Fields(0)))&""
1