Private Sub DataList1_Click()
Adodc2.RecordSource = "select * from qxsz where 用户='" & DataList1.BoundText & " ' "
Adodc2.Refresh出错行
If Adodc2.Recordset.RecordCount > 0 Then
For i = 0 To 4
If Adodc1.Recordset.Fields(i) = 0 Then check1(i).Value = 1 Else check1(i).Value = 0
Next i
Adodc2.Recordset.Update
End IfEnd Sub
请高手帮忙。谢谢
Adodc2.RecordSource = "select * from qxsz where 用户='" & DataList1.BoundText & " ' "
Adodc2.Refresh出错行
If Adodc2.Recordset.RecordCount > 0 Then
For i = 0 To 4
If Adodc1.Recordset.Fields(i) = 0 Then check1(i).Value = 1 Else check1(i).Value = 0
Next i
Adodc2.Recordset.Update
End IfEnd Sub
请高手帮忙。谢谢
解决方案 »
- 急:vb中新建文件夹的问题!
- 我想按Alt+Enter组合键来试窗口最大化,该怎么做??
- 关于ActiveX 控件的DragDrop事件
- 求助!!!一个最简单的问题!
- 紧急求救:VB与SQL Server 连接的问题
- 我是个初学者,我想问一下!!!在VB中我用DATA控件连ACESS怎么老是说数据库格式出错!
- 新手求助:如何在vb6中的PictureBox控件中实现单击鼠标右键弹出快捷菜单!(请给出代码)
- 如何使ListView的子项可编辑
- vb操作数据表中数据问题
- 一个对我来说较难的问题:在局域网中如何浏览网络中的其他机器?
- 在这儿问下WebBrowser1_StatusTextChange的三个初级问题:
- 求excel的宏基础教程
For i = 0 To 4
check1(i).Value = 1
Next iEnd SubPrivate Sub Command2_Click()
For i = 0 To 4
check1(i).Value = 0
Next i
End SubPrivate Sub Command3_Click()
If DataList1.SelectedItem Then
Adodc2.RecordSource = "select * from qxsz where 用户='" & DataList1.BoundText & " ' "
Adodc2.Refresh
If Adodc2.Recordset.RecordCount > 0 Then
For i = 0 To 4
If check1(i).Value = 1 Then Adodc2.Recordset.Fields(i) = 0 Else Adodc2.Recordset.Fields(i) = 1
Next i
Adodc2.Recordset.Update
End If
MsgBox "设置权限已完成!"
Else
MsgBox "请选择用户!"
End IfEnd SubPrivate Sub Command4_Click()
EndEnd SubPrivate Sub DataList1_Click()
Adodc2.RecordSource = "select * from qxsz where 用户='" & DataList1.BoundText & " ' "
'Adodc2.Refresh
Adodc2.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=jxcy;Data Source=127.0.0.1;Password="
If Adodc2.Recordset.RecordCount > 0 Then
For i = 0 To 4
If Adodc1.Recordset.Fields(i) = 0 Then check1(i).Value = 1 Else check1(i).Value = 0
Next i
Adodc2.Recordset.Update
End IfEnd SubPrivate Sub Form_Load()
For i = 0 To 4
check1(i).Value = 1
Next iEnd Sub
麻烦了,谢谢
For i = 0 To 4
check1(i).Value = 1
Next iEnd SubPrivate Sub Command2_Click()
For i = 0 To 4
check1(i).Value = 0
Next i
End SubPrivate Sub Command3_Click()
If DataList1.SelectedItem Then
Adodc2.RecordSource = "select * from qxsz where 用户='" & DataList1.BoundText & " ' "
Adodc2.Refresh
If Adodc2.Recordset.RecordCount > 0 Then
For i = 0 To 4
If check1(i).Value = 1 Then Adodc2.Recordset.Fields(i) = 0 Else Adodc2.Recordset.Fields(i) = 1
Next i
Adodc2.Recordset.Update
End If
MsgBox "设置权限已完成!"
Else
MsgBox "请选择用户!"
End IfEnd SubPrivate Sub Command4_Click()
EndEnd SubPrivate Sub DataList1_Click()
Adodc2.RecordSource = "select * from qxsz where 用户='" & DataList1.BoundText & " ' "
'Adodc2.Refresh
Adodc2.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=jxcy;Data Source=127.0.0.1;Password="
If Adodc2.Recordset.RecordCount > 0 Then
For i = 0 To 4
If Adodc1.Recordset.Fields(i) = 0 Then check1(i).Value = 1 Else check1(i).Value = 0
Next i
Adodc2.Recordset.Update
End IfEnd SubPrivate Sub Form_Load()
For i = 0 To 4
check1(i).Value = 1
Next iEnd Sub
麻烦了,谢谢
Adodc2.RecordSource = "select * from qxsz where 用户='" & DataList1.BoundText & " ' "
'Adodc2.Refresh
Adodc2.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=jxcy;Data Source=127.0.0.1;Password="我想顺序有问题,应该这样:
Adodc2.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=jxcy;Data Source=127.0.0.1;Password="
Adodc2.RecordSource = "select * from qxsz where 用户='" & DataList1.BoundText & " ' "
Adodc2.Refresh
放到form_load里面
实时错误'-2147217900(80040e14)':对象'Refresh'的方法'IAdodc'失败
错误行还是提示Adodc2.Refresh
For i = 0 To 4
check1(i).Value = 1
Next iEnd SubPrivate Sub Command2_Click()
For i = 0 To 4
check1(i).Value = 0
Next i
End SubPrivate Sub Command3_Click()
If DataList1.SelectedItem Then
Adodc2.RecordSource = "select * from qxsz where 用户='" & DataList1.BoundText & " ' "
Adodc2.Refresh
If Adodc2.Recordset.RecordCount > 0 Then
For i = 0 To 4
If check1(i).Value = 1 Then Adodc2.Recordset.Fields(i) = 0 Else Adodc2.Recordset.Fields(i) = 1
Next i
Adodc2.Recordset.Update
End If
MsgBox "设置权限已完成!"
Else
MsgBox "请选择用户!"
End IfEnd SubPrivate Sub Command4_Click()
EndEnd SubPrivate Sub DataList1_Click()
Adodc2.RecordSource = "select * from qxsz where 用户='" & Trim(DataList1.BoundText) & " ' "
Adodc2.Refresh出错行!!!出错提示同上If Adodc2.Recordset.RecordCount > 0 Then
For i = 0 To 4
If Adodc1.Recordset.Fields(i) = 0 Then check1(i).Value = 1 Else check1(i).Value = 0
Next i
Adodc2.Recordset.Update
End IfEnd SubPrivate Sub Form_Load()
For i = 0 To 4
check1(i).Value = 1
Next iEnd Sub
再发一遍,麻烦各位高手帮忙
RecordSource 也可以放到里面设置.用个实例测一下吧
楼主如果说是SQL语法的错误话,测试一下这个输出的SQL语句是啥?看看是否有语法错误?