Dim dbconn As New ADODB.Connection
Dim mrc As New ADODB.Recordset
Dim connstr As String
Dim Acc As Boolean
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 mrc = dbconn.Execute(txtsql)
mrc.Open txtsql, adOpenKeyset, adLockOptimistic, adCmdText
FillText
TextEnable
If Combo1.Text = "1-判断题" Then
Text(2).Visible = False
Else
Option1.Visible = True
Option2.Visible = True
End If
If Combo1.Text = "2-单选题,3-多选题,4-填空题,5-简答题,6-论述题,7-综合题" Then
Text(2).Visible = True
Else
Option1.Visible = False
Option2.Visible = False
End If
Acc = False
End Sub
-----------------------------------------------------------------------------------------
mrc.Open txtsql, adOpenKeyset, adLockOptimistic, adCmdText这句话提示出来的错误~~~
-----------------------------------------------------------------------------------------
各位大大帮忙看看
Dim mrc As New ADODB.Recordset
Dim connstr As String
Dim Acc As Boolean
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 mrc = dbconn.Execute(txtsql)
mrc.Open txtsql, adOpenKeyset, adLockOptimistic, adCmdText
FillText
TextEnable
If Combo1.Text = "1-判断题" Then
Text(2).Visible = False
Else
Option1.Visible = True
Option2.Visible = True
End If
If Combo1.Text = "2-单选题,3-多选题,4-填空题,5-简答题,6-论述题,7-综合题" Then
Text(2).Visible = True
Else
Option1.Visible = False
Option2.Visible = False
End If
Acc = False
End Sub
-----------------------------------------------------------------------------------------
mrc.Open txtsql, adOpenKeyset, adLockOptimistic, adCmdText这句话提示出来的错误~~~
-----------------------------------------------------------------------------------------
各位大大帮忙看看
mrc.open ...
还是这句话提示的
----------------------------------------------------------------------------------------- mrc.Open txtsql, adOpenKeyset, adLockOptimistic, adCmdText -----------------------------------------------------------------------------------------
你为什么还要写这么一句话呢?
删了试试~~~~~~~
关注!
Dim mrc As New ADODB.Recordset
Dim connstr As String
Dim Acc As Boolean
Set mrc = New Recordset
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=E:\testpaper\DB\testpaper.mdb"
Set dbconn = New adodb.Connection
dbconn .CursorLocation = adUseClient
dbconn.Open connstr
txtsql = "select * from testdes"
'Set mrc = dbconn.Execute(txtsql)
mrc.Open txtsql,dbconn,adOpenKeyset, adLockOptimistic, adCmdText
FillText
TextEnable
If Combo1.Text = "1-判断题" Then
Text(2).Visible = False
Else
Option1.Visible = True
Option2.Visible = True
End If
If Combo1.Text = "2-单选题,3-多选题,4-填空题,5-简答题,6-论述题,7-综合题" Then
Text(2).Visible = True
Else
Option1.Visible = False
Option2.Visible = False
End If
Acc = False
End Sub
mrc.Open txtsql,dbconn,adOpenKeyset, adLockOptimistic, adCmdText
重复了