frmmain.frm

vb与access数据库的操作实例

VERSION 5.00
Begin VB.Form FrmMain 
   Caption         =   "设备管理系统"
   ClientHeight    =   8310
   ClientLeft      =   60
   ClientTop       =   480
   ClientWidth     =   11880
   LinkTopic       =   "Form1"
   ScaleHeight     =   8310
   ScaleWidth      =   11880
   StartUpPosition =   2  '屏幕中心
   Begin VB.Menu mn_1 
      Caption         =   "基本信息管理"
      Begin VB.Menu mn_Types 
         Caption         =   "分类管理"
      End
      Begin VB.Menu mn_Dept 
         Caption         =   "部门管理"
      End
      Begin VB.Menu mn_Exit 
         Caption         =   "退出系统"
      End
   End
   Begin VB.Menu mn_2 
      Caption         =   "设备信息管理"
      Begin VB.Menu mn_Device 
         Caption         =   "设备台帐管理"
      End
      Begin VB.Menu mn_Accessory 
         Caption         =   "设备配件管理"
      End
   End
   Begin VB.Menu mn_3 
      Caption         =   "设备运作管理"
      Begin VB.Menu mn_Distribute 
         Caption         =   "设备分配管理"
      End
      Begin VB.Menu mn_Mntenance 
         Caption         =   "设备维护管理"
      End
      Begin VB.Menu mn_Discard 
         Caption         =   "报废申请管理"
      End
      Begin VB.Menu mn_Approve 
         Caption         =   "报废审批管理"
      End
   End
   Begin VB.Menu mn_4 
      Caption         =   "系统用户管理"
      Begin VB.Menu mn_Users 
         Caption         =   "用户管理"
      End
      Begin VB.Menu mn_ChangePwd 
         Caption         =   "修改密码"
      End
   End
   Begin VB.Menu mn_5 
      Caption         =   "数据库操作"
   End
End
Attribute VB_Name = "FrmMain"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Private Sub Form_Load()
  '载入图片信息
  Dim PicPath As String                  '图片路径
  PicPath = App.Path + "\Img\device.jpg" '图片存放路径
  Picture = LoadPicture(PicPath)         '载入图片
  '设置连接字符串
  Conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\" + DBName + ";Persist Security Info=False"
  '登录界面
  FrmLogin.Show 1
End Sub

Private Sub mn_5_Click()
  FrmDataBase.Show 1
End Sub

Private Sub mn_Accessory_Click()
  '配件管理
  FrmAccessory.Show 1
End Sub

Private Sub mn_Approve_Click()
  '设备报废审批管理
  FrmDiscardApproval.Show 1
End Sub
'修改密码
Private Sub mn_ChangePwd_Click()
  FrmUserPwdEdit.txtUserName = Trim(CurUser.UserName)   '用户名
  FrmUserPwdEdit.txtUserName.Enabled = False            '不允许修改用户名
  FrmUserPwdEdit.Show 1
End Sub

Private Sub mn_Dept_Click()
  '部门管理
  FrmDept.Show 1
End Sub

Private Sub mn_Device_Click()
  '设备台帐管理
  FrmDevice.Show 1
End Sub

Private Sub mn_Discard_Click()
  '设备报废申请管理
  FrmDiscard.Show 1
End Sub

Private Sub mn_Distribute_Click()
  '设备分配管理
  FrmDistribute.Show 1
End Sub

Private Sub mn_Exit_Click()
  '退出系统
  DBapi_Disconnect
  End
End Sub

Private Sub mn_Mntenance_Click()
  '设备维护管理
  FrmMntenance.Show 1
End Sub

Private Sub mn_Types_Click()
  '设备分类管理
  FrmType.Show 1
End Sub

Private Sub mn_Users_Click()
  '如果当前用户类型为管理员，则打开用户管理窗体
  If CurUser.UserType = 1 Then
    FrmUserMan.Show 1
  Else
    MsgBox "没有权限"
  End If
End Sub