userform.frm

这个是VB环境开发的,我也是转载的把原来的Access数据库改成了SQl Server数据库.希望大家可以借鉴

VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Begin VB.Form UserForm 
   Appearance      =   0  'Flat
   BackColor       =   &H00FFFFFF&
   Caption         =   "创  建  新  用 户 "
   ClientHeight    =   3570
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   5865
   ClipControls    =   0   'False
   ControlBox      =   0   'False
   BeginProperty Font 
      Name            =   "宋体"
      Size            =   10.5
      Charset         =   134
      Weight          =   400
      Underline       =   0   'False
      Italic          =   0   'False
      Strikethrough   =   0   'False
   EndProperty
   LinkTopic       =   "Form1"
   Moveable        =   0   'False
   ScaleHeight     =   3570
   ScaleWidth      =   5865
   StartUpPosition =   2  '屏幕中心
   Begin VB.CommandButton cmdpwdedit 
      Appearance      =   0  'Flat
      Caption         =   "修 改 密 码"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   372
      Left            =   1080
      TabIndex        =   20
      Top             =   2640
      Width           =   1932
   End
   Begin VB.CommandButton CmdExit 
      Caption         =   "退 出"
      Height          =   375
      Left            =   4320
      TabIndex        =   13
      Top             =   2760
      Width           =   975
   End
   Begin VB.CommandButton CmdDelete 
      Caption         =   "删 除"
      Enabled         =   0   'False
      Height          =   375
      Left            =   2040
      TabIndex        =   12
      Top             =   2280
      Width           =   975
   End
   Begin VB.CommandButton CmdCancel 
      Caption         =   "取 消"
      Enabled         =   0   'False
      Height          =   375
      Left            =   1080
      TabIndex        =   11
      Top             =   2280
      Width           =   975
   End
   Begin VB.CommandButton CmdOk 
      Caption         =   "确 定"
      Enabled         =   0   'False
      Height          =   375
      Left            =   2040
      TabIndex        =   10
      Top             =   1920
      Width           =   975
   End
   Begin VB.CommandButton CmdAdd 
      Caption         =   "增 加"
      Height          =   375
      Left            =   1080
      TabIndex        =   0
      Top             =   1920
      Width           =   975
   End
   Begin MSFlexGridLib.MSFlexGrid MSF 
      Height          =   2295
      Left            =   4200
      TabIndex        =   14
      TabStop         =   0   'False
      Top             =   120
      Width           =   1270
      _ExtentX        =   2249
      _ExtentY        =   4048
      _Version        =   393216
      Cols            =   1
      FixedCols       =   0
      BackColor       =   12640511
      BackColorFixed  =   12648384
      BackColorBkg    =   12648447
      Appearance      =   0
      FormatString    =   "用 户 名 称"
   End
   Begin VB.OptionButton Opt 
      Appearance      =   0  'Flat
      BackColor       =   &H00FFFFFF&
      Caption         =   "仓库2"
      ForeColor       =   &H80000008&
      Height          =   210
      Index           =   5
      Left            =   2880
      TabIndex        =   9
      Top             =   6000
      Visible         =   0   'False
      Width           =   975
   End
   Begin VB.OptionButton Opt 
      Appearance      =   0  'Flat
      BackColor       =   &H00FFFFFF&
      Caption         =   "仓库1"
      ForeColor       =   &H80000008&
      Height          =   210
      Index           =   4
      Left            =   1440
      TabIndex        =   8
      Top             =   6000
      Visible         =   0   'False
      Width           =   975
   End
   Begin VB.OptionButton Opt 
      Appearance      =   0  'Flat
      BackColor       =   &H00FFFFFF&
      Caption         =   "采购部"
      ForeColor       =   &H80000008&
      Height          =   210
      Index           =   3
      Left            =   2880
      TabIndex        =   7
      Top             =   5640
      Visible         =   0   'False
      Width           =   975
   End
   Begin VB.OptionButton Opt 
      Appearance      =   0  'Flat
      BackColor       =   &H00FFFFFF&
      Caption         =   "生产部"
      ForeColor       =   &H80000008&
      Height          =   210
      Index           =   2
      Left            =   1440
      TabIndex        =   6
      Top             =   5640
      Visible         =   0   'False
      Width           =   975
   End
   Begin VB.OptionButton Opt 
      Appearance      =   0  'Flat
      BackColor       =   &H00FFFFFF&
      Caption         =   "副经理"
      ForeColor       =   &H80000008&
      Height          =   210
      Index           =   1
      Left            =   2880
      TabIndex        =   5
      Top             =   5280
      Visible         =   0   'False
      Width           =   975
   End
   Begin VB.OptionButton Opt 
      Appearance      =   0  'Flat
      BackColor       =   &H00FFFFFF&
      Caption         =   "总经理"
      ForeColor       =   &H80000008&
      Height          =   210
      Index           =   0
      Left            =   1440
      TabIndex        =   4
      Top             =   5280
      Value           =   -1  'True
      Visible         =   0   'False
      Width           =   975
   End
   Begin VB.TextBox Txt 
      Appearance      =   0  'Flat
      BackColor       =   &H00FFFFFF&
      ForeColor       =   &H00000000&
      Height          =   315
      IMEMode         =   3  'DISABLE
      Index           =   2
      Left            =   1320
      MaxLength       =   10
      PasswordChar    =   "*"
      TabIndex        =   3
      Top             =   1080
      Width           =   2655
   End
   Begin VB.TextBox Txt 
      Appearance      =   0  'Flat
      BackColor       =   &H00FFFFFF&
      ForeColor       =   &H00000000&
      Height          =   315
      IMEMode         =   3  'DISABLE
      Index           =   1
      Left            =   1320
      MaxLength       =   10
      PasswordChar    =   "*"
      TabIndex        =   2
      Top             =   600
      Width           =   2655
   End
   Begin VB.TextBox Txt 
      Appearance      =   0  'Flat
      BackColor       =   &H00FFFFFF&
      Enabled         =   0   'False
      Height          =   315
      Index           =   0
      Left            =   1320
      MaxLength       =   10
      TabIndex        =   1
      Top             =   120
      Width           =   2655
   End
   Begin VB.Frame Frame1 
      BackColor       =   &H80000009&
      Height          =   1692
      Left            =   360
      TabIndex        =   19
      Top             =   1560
      Width           =   3615
   End
   Begin VB.Label Label1 
      Appearance      =   0  'Flat
      AutoSize        =   -1  'True
      BackColor       =   &H80000005&
      BackStyle       =   0  'Transparent
      Caption         =   "所在部门:"
      ForeColor       =   &H80000008&
      Height          =   210
      Index           =   3
      Left            =   240
      TabIndex        =   18
      Top             =   5280
      Visible         =   0   'False
      Width           =   945
   End
   Begin VB.Label Label1 
      Appearance      =   0  'Flat
      AutoSize        =   -1  'True
      BackColor       =   &H80000005&
      BackStyle       =   0  'Transparent
      Caption         =   "确认口令:"
      ForeColor       =   &H80000008&
      Height          =   210
      Index           =   2
      Left            =   240
      TabIndex        =   17
      Top             =   1080
      Width           =   945
   End
   Begin VB.Label Label1 
      Appearance      =   0  'Flat
      AutoSize        =   -1  'True
      BackColor       =   &H80000005&
      BackStyle       =   0  'Transparent
      Caption         =   "用户口令:"