Private Sub Form_Load()
Dim rst As ADODB.Recordset
Dim strItem As String
'If Index = 0 Then
sqlstr = " select 院代码. 院名称 from 院信息表 order by 院代码"
Set rst = selectsql(sqlstr)
If rst.RecordCount > 0 Then
Do While Not rst.EOF
strItem = rst.Fields(0) & "" & rst.Fields(1)
CboQuery.AddItem (strItem)
rst.MoveNext
Loop
rst.Close
CboQuery.ListIndex = 0
Else
MsgBox ("请先键入院信息")
Frame1.Enabled = False
Frame2.Enabled = False
Exit Sub
End If
Call loaddata
'For Index = 0 To 6
' TxtItem(Index).Enabled = False
' Next Index
'Call loaddata
If rs.RecordCount > 0 Then
Call showdata
Else
For Index = 0 To 3
CmdMove(Index).Enabled = False
Next Index
End If
End Sub
Dim rst As ADODB.Recordset
Dim strItem As String
'If Index = 0 Then
sqlstr = " select 院代码. 院名称 from 院信息表 order by 院代码"
Set rst = selectsql(sqlstr)
If rst.RecordCount > 0 Then
Do While Not rst.EOF
strItem = rst.Fields(0) & "" & rst.Fields(1)
CboQuery.AddItem (strItem)
rst.MoveNext
Loop
rst.Close
CboQuery.ListIndex = 0
Else
MsgBox ("请先键入院信息")
Frame1.Enabled = False
Frame2.Enabled = False
Exit Sub
End If
Call loaddata
'For Index = 0 To 6
' TxtItem(Index).Enabled = False
' Next Index
'Call loaddata
If rs.RecordCount > 0 Then
Call showdata
Else
For Index = 0 To 3
CmdMove(Index).Enabled = False
Next Index
End If
End Sub
Dim rst As NEW ADODB.Recordset
用完记着rst.close
set rs=nothing
已经引进来啦··是在部件里的ADODB嘛··可是,每次都说“对象变量或者块未定义”。。无语啊··呵呵