我想让combo2随着combo1的选择而变化,写了一段代码,可总报“with块变量未设置”的错,不知怎么回事,请大家帮我看看!代码如下:Private Sub Combo15_Click(Index As Integer)
Dim i As String
Dim rst As ADODB.Recordset
SQL = "select typemc from rjtypelx where syrjid ='"
SQL = SQL & (Trim(Combo15(0).Text)) & "'"
Set rst = SelectSQL(SQL, Msg)
Combo15(1).Clear
If rst.RecordCount > 0 Then
Do While Not rst.EOF
i = rst.Fields(0)
Combo15(1).AddItem (i)
rst.MoveNext
Loop
rst.Close
Combo15(1).ListIndex = 0
Else
MsgBox "bb"
Exit Sub
End If
End Sub请大家帮帮忙!
Dim i As String
Dim rst As ADODB.Recordset
SQL = "select typemc from rjtypelx where syrjid ='"
SQL = SQL & (Trim(Combo15(0).Text)) & "'"
Set rst = SelectSQL(SQL, Msg)
Combo15(1).Clear
If rst.RecordCount > 0 Then
Do While Not rst.EOF
i = rst.Fields(0)
Combo15(1).AddItem (i)
rst.MoveNext
Loop
rst.Close
Combo15(1).ListIndex = 0
Else
MsgBox "bb"
Exit Sub
End If
End Sub请大家帮帮忙!
解决方案 »
- MSHFlexGrid的背景色如何永久保存
- 急问?如何实现点一个按钮打开ie并访问一个指定的地址?
- 程序运行后,如何使窗口全屏?
- "select * from student where " & str1(List1.ListIndex) & " >= " & date1 & " and " & str1(List1.ListIndex) & " <= " & date2 错在
- (简单问题!)VB调用Excel文件,需要添加那些引用或组件?
- VB 对 ACCESS 查询的问题
- 如何将picturebox里的经处理得来的图片保存下来
- 如何控制DrawText或DrawTextEx输出文字的行间距?
- 『下载』Ms Visual Studio .NET Beta2(正式Beta2版,非Pre-Beta)4 CDs
- 在有的局域网(如网吧里)上WINSOCK控件的LOCALIP属性会显示为0。0。0。0这肯定不是真实的IP地址。这个问题怎样解决?
- 请教高手如何实现这个功能?
- 打印报表的问题
'引用 Microsoft ADO Ext 2.5 for ddl and security
'引用 Microsoft ActiveX Data Objects 2.5 Library
'添加 Combo1 Combo2'代码说明:
'Combo1 玫举本数据库中的所有表名
'点击Combo1中的任何其中一个表, Combo2里面的数据同步更新,载入此表的所有数据Option Explicit
Dim i%, strSQL$
Dim Conn As Connection
Dim rs As New ADODB.Recordset
Private Sub Form_Load()
Set Conn = New Connection
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & "c:\bwscale.mdb;Persist Security Info=False"
'******************** Combo1 添加此库的所有表名
Dim cat As New ADOX.Catalog
Set cat.ActiveConnection = Conn
For i = 0 To cat.Tables.Count - 1
If Left(cat.Tables(i).Name, 4) <> "MSys" Then Combo1.AddItem cat.Tables(i).Name
Next i
If Combo1.ListCount > 0 Then
Combo1.Text = Combo1.List(0)
strSQL = "select * from " & Combo1.Text
rs.Open strSQL, Conn, adOpenStatic, adLockOptimistic
'******************** Combo2 添加Combo1中第一个表的所有数据
If rs.RecordCount > 0 Then
rs.MoveFirst
For i = 0 To rs.RecordCount - 1
Combo2.AddItem rs.Fields(1)
rs.MoveNext
Next i
Combo2.Text = Combo2.List(0)
End If
End If
End SubPrivate Sub Form_Unload(Cancel As Integer)
rs.Close
Conn.Close
Set rs = Nothing
Set Conn = Nothing
End
End SubPrivate Sub Combo1_Click()
rs.Close
strSQL = "select * from " & Combo1.Text
rs.Open strSQL, Conn, adOpenStatic, adLockOptimistic
If rs.RecordCount > 0 Then
rs.MoveFirst
Combo2.Clear
For i = 0 To rs.RecordCount - 1
Combo2.AddItem rs.Fields(1)
rs.MoveNext
Next i
Combo2.Text = Combo2.List(0)
End If
End Sub
Set rst = SelectSQL(SQL, Msg)
Private Sub Combo15_Click(Index As Integer)
Dim i As Integer
Dim rst As ADODB.Recordset
Set rst = New ADODB.RecordsetSQL = "select typemc from rjtypelx where syrjmc ='"
SQL = SQL & (Trim(Combo15(0).Text)) & "'"
Set rst = SelectSQL(SQL, Msg)
Combo15(1).ClearFor i = 1 To rst.RecordCount
Combo15(1).AddItem Trim(rst(0) & "")
rst.MoveNext
Next irst.CloseEnd Sub请各位指点!谢谢!
Combo15(1).AddItem Trim(rst(0) & "")
rst.MoveNext
Next i 改为rst.movefirst
For i = 0 To rst.RecordCount - 1 '不是 1 To rst.RecordCount
Combo15(1).AddItem Trim(rst.Fields(0) & "") '你少了Fields, 前面有了Trim 里面加"" 有什么意义?
rst.MoveNext
Next i