Dim dbconn As New ADODB.Connection
Dim mrc As New ADODB.Recordset
Dim testdesrst As New ADODB.Recordset
Dim connstr As String
Dim Acc As BooleanPrivate Sub Command2_Click()
If testdesrst.RecordCount = 0 Then Exit Sub testdesrst.MovePrevious '<------------实时错误 '3219' 在此环境中不允许操作。 If testdesrst.BOF = True Then
MsgBox "已经是第一道试题了!", vbOKOnly + vbExclamation, "浏览试题"
mrc.MoveFirst
End If
Call FieldtoControl(testdesrst, Me)
End SubPrivate Sub Command3_Click()
If testdesrst.RecordCount = 0 Then Exit Sub
testdesrst.MoveNext
If testdesrst.EOF = True Then
MsgBox "已经是最后道试题了!", vbOKOnly + vbExclamation, "浏览试题"
testdesrst.MoveLast '<-----------实时错误 '-2147217884 (80040e24)' 行集不支持反响提取
End If
Call FieldtoControl(testdesrst, Me)
End SubPrivate Sub Command4_Click()
If testdesrst.RecordCount = 0 Then Exit Sub
testdesrst.MoveLast '<----------------------实时错误 '-2147217884 (80040e24)' 行集不支持反响提取
Call FieldtoControl(testdesrst, Me)
End Sub
Private Sub Command8_Click()
If testdesrst.RecordCount = 0 Then Exit Sub
testdesrst.MoveFirst
Call FieldtoControl(testdesrst, Me)
End SubSub FieldtoControl(rss As ADODB.Recordset, frm As Form)
frm.Text1.Text = Trim(rss!code)
frm.Text2.Text = Trim(rss!stdes)
frm.Text3.Text = Trim(rss!stanswer)
frm.Text4.Text = Trim(rss!stmemo)
'********************************************
'frm.Combo1.Text = Trim(rss!itemid) Combobox怎么在textbox里显示。代码怎么写。
'frm.Combo2.Text = Trim(rss!lecode)
'frm.Combo3.Text = Trim(rss!sttype)
'********************************************
End SubPrivate Sub Form_Load()
Dim mrc As ADODB.Recordset
'Set mrc = New Recordset
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=E:\testpaper\DB\testpaper.mdb"
' dbconn.Open connstr
txtsql = "select * from testdes"
Set testdesrst = dbconn.Execute(txtsql)
If testdesrst.RecordCount <> 0 Then
testdesrst.MoveFirst
Call FieldtoControl(testdesrst, Me)
End If
解决方案 »
- VB工程有主函数的没?
- 急!!!!连接数据库对txt文档进行操作。
- 浏览器插件的开发
- 怎么把listview的水平工具条移到最后!!!在线等!!
- 读写文件的小问题
- 在VB里用App.PrevInstance可知已有程序运行,怎样把已运行的程序调到前台呢?
- 问高手!防止多次启动的问题:previnstance探测到这个程序已经启动的时候,如何自动地show出已经运行的这个previnstance的form?
- 如何向注册表中读取/写入长度>4的DWORD值
- 请问各位,我想让ComboBox只拥有选取功能,不要让用户自己输入数据,即只可选,不可输,我该怎么办呢?
- 求助:之前运行没有问题,后来重装系统重装office就报错:应用程序定义或对象定义错误1004
- 本来用C#的,可电脑太烂,想用VB学会了,再考虑换电脑,问下VB做网页可以吗?
- 高手请进,请帮我看看这个换行打印,为什么老是多一点东西,
Dim mrc As ADODB.Recordset
'Set mrc = New Recordset
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=E:\testpaper\DB\testpaper.mdb"
' dbconn.Open connstr
txtsql = "select * from testdes"
Set testdesrst = dbconn.Execute(txtsql)
If testdesrst.RecordCount <> 0 Then
testdesrst.MoveFirst
Call FieldtoControl(testdesrst, Me)
End If
改一下:
Private Sub Form_Load()
Dim mrc As ADODB.Recordset
'Set mrc = New Recordset
connstr.CursorLocation = adUseClient connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=E:\testpaper\DB\testpaper.mdb"
' dbconn.Open connstr
txtsql = "select * from testdes"
' Set testdesrst = dbconn.Execute(txtsql)
testdesrst.Open sql, cn, 3, 3 If testdesrst.RecordCount <> 0 Then
testdesrst.MoveFirst
Call FieldtoControl(testdesrst, Me)
End If