📄 frmbackup.frm
字号:
VERSION 5.00
Begin VB.Form frmBackUp
BorderStyle = 1 'Fixed Single
Caption = "备份数据"
ClientHeight = 6060
ClientLeft = 45
ClientTop = 330
ClientWidth = 6645
ForeColor = &H00800000&
Icon = "frmBackUp.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 6060
ScaleWidth = 6645
ShowInTaskbar = 0 'False
StartUpPosition = 2 '屏幕中心
Begin VB.Frame frameCurrBackUp
BackColor = &H00C0C0C0&
Caption = "请选择备份路径"
BeginProperty Font
Name = "新宋体"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 2775
Left = 120
TabIndex = 9
Top = 2880
Width = 6375
Begin VB.FileListBox File1
Height = 630
Left = 120
TabIndex = 12
Top = 1320
Visible = 0 'False
Width = 495
End
Begin VB.CommandButton cmdCancel
BackColor = &H00FFFFFF&
Caption = "取消"
Height = 735
Left = 3960
Picture = "frmBackUp.frx":0442
Style = 1 'Graphical
TabIndex = 3
Top = 1680
Width = 2175
End
Begin VB.CommandButton cmdSave
BackColor = &H00FFFFFF&
Caption = "备份"
Height = 735
Left = 3960
Picture = "frmBackUp.frx":07C3
Style = 1 'Graphical
TabIndex = 2
Top = 600
Width = 2175
End
Begin VB.DirListBox Dir1
Height = 1665
Left = 480
TabIndex = 1
Top = 960
Width = 3015
End
Begin VB.DriveListBox Drive1
Height = 315
Left = 480
TabIndex = 0
Top = 480
Width = 3015
End
End
Begin VB.Frame frameBackup
Caption = "备份路径"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 2415
Left = 120
TabIndex = 4
Top = 120
Width = 6375
Begin VB.Label lblLastTime
Caption = "上次记录"
BeginProperty Font
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF8080&
Height = 255
Left = 1200
TabIndex = 11
Top = 1800
Width = 3855
End
Begin VB.Label lblLastDate
Caption = "上次记录"
BeginProperty Font
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF8080&
Height = 255
Left = 1200
TabIndex = 10
Top = 1200
Width = 3375
End
Begin VB.Label Time
Caption = "时间"
BeginProperty Font
Name = "宋体"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00800000&
Height = 375
Left = 120
TabIndex = 8
Top = 1800
Width = 975
End
Begin VB.Label lblDate
Caption = "日期"
BeginProperty Font
Name = "宋体"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00800000&
Height = 375
Left = 120
TabIndex = 7
Top = 1200
Width = 975
End
Begin VB.Label lblPath
Caption = "路径"
BeginProperty Font
Name = "宋体"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00800000&
Height = 375
Left = 120
TabIndex = 6
Top = 480
Width = 975
End
Begin VB.Label lblLastPath
Caption = "上次记录"
BeginProperty Font
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF8080&
Height = 615
Left = 1200
TabIndex = 5
Top = 480
Width = 4935
End
End
End
Attribute VB_Name = "frmBackUp"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim Fsys As New FileSystemObject
Dim bckupFile As File
'记录上次备份细节
Private Sub Form_Load()
Dim lastPath As String
Dim lastDate As String
Dim lastTime As String
'读取上次记录
lastPath = GetSetting(App.Title, "Settings", "BackupPath")
lastDate = GetSetting(App.Title, "Settings", "BackupDate")
lastTime = GetSetting(App.Title, "Settings", "BackupTime")
If lastPath = "" Then
lblLastPath.Caption = "无上次记录！"
lblLastDate.Caption = " "
lblLastTime.Caption = " "
Else
lblLastPath.Caption = lastPath
lblLastDate.Caption = lastDate & " (yy-mm-dd)"
lblLastTime.Caption = lastTime
End If
End Sub
Private Sub cmdCancel_Click()
Unload Me
End Sub
Private Sub cmdsave_click()
On Error Resume Next
cmdSave.Enabled = False
Label1.Caption = "正在备份，请稍候..."
Label1.BackColor = vbGreen
Label1.ForeColor = vbYellow
Dim destination As String
Dim Source As String
Dim currDate, currTime As String
currDate = Format$(Now, "yy - mm - dd")
currTime = Format$(Now, "hh:mm:ss AM/PM")
destination = File1.Path & "\" & "Library.mdb"
Source = App.Path & "\Library.mdb"
Set bckupFile = Fsys.GetFile(finalpath)
bckupFile.Attributes = Compressed
Fsys.CopyFile Source, destination, True
'保存当前记录
SaveSetting App.Title, "Settings", "BackupPath", destination
SaveSetting App.Title, "Settings", "BackupDate", currDate
SaveSetting App.Title, "Settings", "BackupTime", currTime
Label1.BackColor = vbYellow
Label1.ForeColor = vbBlue
cmdSave.Enabled = True
MsgBox "备份完成！", vbInformation, "备份"
Unload Me
End Sub
Private Sub Drive1_Change()
Dir1.Path = Drive1.Drive
End Sub
Private Sub Dir1_Change()
File1.Path = Dir1.Path
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -