frmdb.frm

一个学生宿舍加扣分的管理系统！内含添加宿舍...宿舍的加分建分..各宿舍的查询..兼数据库的备份与恢复

VERSION 5.00
Begin VB.Form frmdb 
   BackColor       =   &H00FFC0C0&
   Caption         =   "数据库管理---数据恢复"
   ClientHeight    =   6885
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   11010
   Icon            =   "frmdb.frx":0000
   LinkTopic       =   "Form5"
   MaxButton       =   0   'False
   ScaleHeight     =   6885
   ScaleWidth      =   11010
   StartUpPosition =   3  '窗口缺省
   Begin VB.TextBox Text1 
      Height          =   495
      Left            =   8280
      TabIndex        =   5
      Text            =   "Text1"
      Top             =   2520
      Visible         =   0   'False
      Width           =   2055
   End
   Begin VB.CommandButton Command2 
      BackColor       =   &H00FFC0C0&
      Caption         =   "取消"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   8280
      Style           =   1  'Graphical
      TabIndex        =   2
      Top             =   3480
      Width           =   2175
   End
   Begin VB.CommandButton Command1 
      BackColor       =   &H00FFC0C0&
      Caption         =   "数据恢复"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   8280
      Style           =   1  'Graphical
      TabIndex        =   1
      Top             =   1920
      Width           =   2055
   End
   Begin VB.FileListBox File1 
      Height          =   4770
      Left            =   3600
      Pattern         =   "*.mdb"
      TabIndex        =   4
      Top             =   1680
      Width           =   3495
   End
   Begin VB.DriveListBox Drive1 
      Height          =   300
      Left            =   240
      TabIndex        =   3
      Top             =   6000
      Width           =   3135
   End
   Begin VB.DirListBox Dir1 
      Height          =   4080
      Left            =   240
      TabIndex        =   0
      Top             =   1680
      Width           =   3135
   End
   Begin VB.Line Line1 
      X1              =   7680
      X2              =   7680
      Y1              =   0
      Y2              =   6840
   End
   Begin VB.Label Label1 
      BackColor       =   &H00FFC0C0&
      Caption         =   "请选择要恢复的数据库所在的位置："
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00404040&
      Height          =   615
      Left            =   120
      TabIndex        =   6
      Top             =   840
      Width           =   4095
   End
End
Attribute VB_Name = "frmdb"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
'恢复到指定的路径下的数据库
Dim z As Integer
If Text1.Text = "" Then
MsgBox "请指定要恢复的数据库"
Else

Me.MousePointer = 11
FileCopy Dir1.Path & "\" & File1.FileName, App.Path & "\" & "bedroom.mdb"
Me.MousePointer = 0
z = MsgBox("数据恢复已完成！！！", vbOKOnly + vbExclamation, "警告")
If z Then
Unload Me
frmdefault.Show
End If
End If
End Sub

Private Sub Command2_Click()
Text1.Text = ""
Unload Me
frmdefault.Show
End Sub

Private Sub Dir1_Change()
File1.Path = Dir1.Path
End Sub

Private Sub Drive1_Change()
Dir1.Path = Drive1.Drive
End Sub

Private Sub File1_Click()
Command1.Enabled = True
Text1.Text = Dir1.Path & "\" & File1.FileName
End Sub

Private Sub Form_Load()
Command1.Enabled = False
End Sub