Private Sub ComboBox7_Enter() On Error GoTo ren If TextBox3.Text = "" Then Exit Sub Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset ComboBox7.Clear cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & TextBox3.Text & ";Jet OLEDB:Database Password=" & TextBox4.Text Set rst = cnn.OpenSchema(adSchemaTables) Do Until rst.EOF If rst!TABLE_TYPE = "TABLE" Then ComboBox7.AddItem rst!TABLE_NAME End If rst.MoveNext Loop rst.Close cnn.Close Set rst = Nothing Set cnn = Nothing ren: End Sub 换了一种写法,不知是否可行。
[此贴子已经被作者于2007-9-13 19:29:53编辑过] |