7,765
社区成员
发帖
与我相关
我的任务
分享
Private Sub Combo1_Change()
??????????
End Sub
Private Sub form_load()
Dim xt_gl As New ADODB.Recordset
Dim sql As String
sql = "select * from 系统管理"
xt_gl.Open sql, conn, adOpenKeyset, adLockPessimistic
xt_gl.MoveFirst
If Not xt_gl.EOF Then
Do While Not xt_gl.EOF
Combo1.AddItem xt_gl.Fields(0)
xt_gl.MoveNext
Loop
Combo1.ListIndex = 0
End If
Text1.Text=?????
Text2.Text=?????
Text3.Text=?????
xt_gl.Close
End Sub
Private Sub Combo1_Change()
Dim xt_gl As New ADODB.Recordset
Dim sql As String
sql = "select * from 系统管理 where 用户名 = '" & Combo1.Text & "'"
xt_gl.Open sql, conn, adOpenKeyset, adLockPessimistic
if xt_gl.recordcount>=0 then
Text1.Text = xt_gl("权限")
Text2.Text = xt_gl("时间1")
Text3.Text = xt_gl("时间2")
end if
xt_gl.Close
End Sub
Private Sub Combo1_Change()
Dim xt_gl As New ADODB.Recordset
Dim sql As String
sql = "select * from 系统管理"
xt_gl.Open sql, conn, adOpenKeyset, adLockPessimistic
xt_gl.Find "用户名='" & Combo1.Text & "'"
Text1.Text = xt_gl(2)
Text2.Text = xt_gl(3)
Text3.Text = xt_gl(4)
xt_gl.Close
End Sub
Private Sub form_load()
Dim xt_gl As New ADODB.Recordset
Dim sql As String
sql = "select * from 系统管理"
xt_gl.Open sql, conn, adOpenKeyset, adLockPessimistic
xt_gl.MoveFirst
If Not xt_gl.EOF Then
Do While Not xt_gl.EOF
Combo1.AddItem xt_gl.Fields(0)
xt_gl.MoveNext
Loop
Combo1.ListIndex = 0
End If
Text1.Text = xt_gl(2)
Text2.Text = xt_gl(3)
Text3.Text = xt_gl(4)
xt_gl.Close
End Sub