PrivateSubCmdCancel_Click()
UnloadMe
EndSub
PrivateSubCmdOK_Click()
IfTxtAccount.Text\"\"Then
DimBAsBoolean
AdoAccountAdd.Recordset.MoveFirst
DoWhileAdoAccountAdd.Recordset.EOF=False
IfTxtAccount.Text=AdoAccountAdd.Recordset(0).ValueThen
B=True
ExitDo
EndIf
AdoAccountAdd.Recordset.MoveNext
Loop
IfB=FalseThen
IfTxtPassword.Text=TxtPasswordAgain.TextThen
AdoAccountAdd.Recordset.AddNew
AdoAccountAdd.Recordset(0).Value=TxtAccount.Text
AdoAccountAdd.Recordset(1).Value=TxtPassword.Text
AdoAccountAdd.Recordset.Update
MsgBox\"帐户“\"TxtPasswordAgain.TextThen
MsgBox\"两次输入的密码不相同,请重新输入。\",vbExclamation,\"密码\"
TxtPassword.Text=\"\"
TxtPasswordAgain.Text=\"\"
TxtPassword.SetFocus
EndIf
ElseIfB=TrueThen
MsgBox\"此帐户已经存在,请重新选择帐户。\",vbExclamation,\"新帐户\"
EndIf
ElseIfTxtAccount.Text=\"\"Then
MsgBox\"请输入新帐户。\",vbExclamation,\"新帐户\"
TxtAccount.SetFocus
EndIf
EndSub
PrivateSubForm_Load()
AdoAccountAdd.ConnectionString=\"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=\"PersistSecurityInfo=False;JetOLEDB:DataBasePassword=172693620\"
AdoAccountAdd.RecordSource=\"Select*From帐户\"
AdoAccountAdd.Refresh
EndSub
|