form_userinsert.frm

一个用VB开发的家庭理财助手。较为实用。

VERSION 5.00
Begin VB.Form Form_UserInsert 
   Caption         =   "添加用户"
   ClientHeight    =   2985
   ClientLeft      =   3990
   ClientTop       =   2535
   ClientWidth     =   4680
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   ScaleHeight     =   2985
   ScaleWidth      =   4680
   Begin VB.CommandButton Command_UserInsert_Cancel 
      Caption         =   "取消"
      Height          =   495
      Left            =   3360
      TabIndex        =   7
      Top             =   2280
      Width           =   855
   End
   Begin VB.CommandButton Command_UserInsert_OK 
      Caption         =   "确定"
      Height          =   495
      Left            =   2160
      TabIndex        =   6
      Top             =   2280
      Width           =   855
   End
   Begin VB.ComboBox Combo_UserInsertType 
      Height          =   315
      ItemData        =   "Form_UserInsert.frx":0000
      Left            =   1920
      List            =   "Form_UserInsert.frx":000A
      Style           =   2  'Dropdown List
      TabIndex        =   4
      Top             =   1680
      Width           =   1575
   End
   Begin VB.TextBox Text_UserInsert_Pwd 
      Height          =   495
      Left            =   1920
      TabIndex        =   2
      Top             =   960
      Width           =   1575
   End
   Begin VB.TextBox Text_UserInsert_Name 
      Height          =   495
      Left            =   1920
      TabIndex        =   0
      Top             =   240
      Width           =   1575
   End
   Begin VB.Label Label3 
      Caption         =   "权限: "
      Height          =   375
      Left            =   480
      TabIndex        =   5
      Top             =   1680
      Width           =   975
   End
   Begin VB.Label Label2 
      Caption         =   "密码: "
      Height          =   375
      Left            =   480
      TabIndex        =   3
      Top             =   1080
      Width           =   975
   End
   Begin VB.Label Label1 
      Caption         =   "用户姓名: "
      Height          =   495
      Left            =   480
      TabIndex        =   1
      Top             =   360
      Width           =   1095
   End
End
Attribute VB_Name = "Form_UserInsert"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command_UserInsert_Cancel_Click()
Unload Me
End Sub

Private Sub Command_UserInsert_OK_Click()
Dim sqlstr As String
If Me.Text_UserInsert_Name.Text = "" Or Me.Text_UserInsert_Pwd.Text = "" _
Or Me.Combo_UserInsertType.Text = "" Then
    MsgBox "不能为空白！"
    Exit Sub
End If
On Error Resume Next
'添加一个用户到数据库
sqlstr = "insert into Family" & "(FamilyName,FamilyPwd,FamilyType)" & _
        "values(" & "'" & Me.Text_UserInsert_Name.Text & "'," & _
                  "'" & Me.Text_UserInsert_Pwd.Text & "'," & _
                 Val(Me.Combo_UserInsertType.Text) & ");"
RemoteCnn.Execute sqlstr
MsgBox "添加成功！"
Unload Me   '卸载本窗体
End Sub