📄 frm_data_backup_second.frm
字号:
VERSION 5.00
Begin VB.Form Frm_Data_Backup_Second
BorderStyle = 1 'Fixed Single
Caption = "数据备份向导"
ClientHeight = 6360
ClientLeft = 5565
ClientTop = 4425
ClientWidth = 9420
Icon = "Frm_Data_Backup_Second.frx":0000
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 6360
ScaleWidth = 9420
Begin VB.CommandButton cmd_Cancel
Caption = "取消 (&Cancel)"
Height = 375
Left = 7320
TabIndex = 5
Top = 5880
Width = 1455
End
Begin VB.CommandButton cmd_Next
Caption = "下一步(&Next)>"
Height = 375
Left = 5280
TabIndex = 3
Top = 5880
Width = 1455
End
Begin VB.CommandButton cmd_Back
Caption = "< 上一步(&Back)"
Height = 375
Left = 3720
TabIndex = 4
Top = 5880
Width = 1455
End
Begin VB.DriveListBox drv_Driver
Height = 300
Left = 2130
TabIndex = 0
Top = 1080
Width = 6735
End
Begin VB.Frame Frame2
Height = 4215
Left = 563
TabIndex = 9
Top = 1440
Width = 8295
Begin VB.TextBox txt_FileName
Height = 300
Left = 1440
TabIndex = 2
Text = "Text2"
Top = 3720
Width = 6375
End
Begin VB.DirListBox dir_Directory
Height = 2400
Left = 1440
TabIndex = 1
Top = 600
Width = 6495
End
Begin VB.Line Line1
BorderColor = &H000080FF&
BorderStyle = 3 'Dot
X1 = 1080
X2 = 8160
Y1 = 3120
Y2 = 3120
End
Begin VB.Image Image2
Height = 480
Left = 240
Picture = "Frm_Data_Backup_Second.frx":0CCA
Top = 480
Width = 480
End
Begin VB.Label Label4
AutoSize = -1 'True
Caption = "2、给备份后的数据库文件起个名子(Name)..."
ForeColor = &H00FF0000&
Height = 180
Left = 1320
TabIndex = 11
Top = 3360
Width = 3600
End
Begin VB.Label Label3
AutoSize = -1 'True
Caption = "1、请选择数据备份路径(Path)...."
ForeColor = &H00FF0000&
Height = 180
Left = 1320
TabIndex = 10
Top = 240
Width = 2790
End
End
Begin VB.Frame Frame1
Appearance = 0 'Flat
BackColor = &H80000005&
BorderStyle = 0 'None
ForeColor = &H80000008&
Height = 855
Left = 0
TabIndex = 6
Top = 0
Width = 9495
Begin VB.Image Image1
Height = 480
Left = 8760
Picture = "Frm_Data_Backup_Second.frx":0FD4
Stretch = -1 'True
Top = 120
Width = 480
End
Begin VB.Label Label2
AutoSize = -1 'True
BackColor = &H00FFFFFF&
Caption = "你要将数据库复制到何处? 你将备份的数据库起个什么名子?"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 210
Left = 1200
TabIndex = 8
Top = 480
Width = 5565
End
Begin VB.Label Label1
AutoSize = -1 'True
BackColor = &H00FFFFFF&
Caption = "选择目的"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Left = 480
TabIndex = 7
Top = 120
Width = 1020
End
End
Begin VB.Image Image3
Height = 240
Left = 600
Picture = "Frm_Data_Backup_Second.frx":2C9E
Top = 1080
Width = 960
End
Begin VB.Line Line2
BorderColor = &H00808080&
X1 = 0
X2 = 9480
Y1 = 5760
Y2 = 5760
End
Begin VB.Label Label5
AutoSize = -1 'True
Caption = "目的"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 1560
TabIndex = 12
Top = 1125
Width = 450
End
End
Attribute VB_Name = "Frm_Data_Backup_Second"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmd_Back_Click()
On Error GoTo err
Unload Me
Load Frm_Data_Backup_frist
Frm_Data_Backup_frist.Show vbModal
Exit Sub
err:
MsgBox err.Description, vbCritical
End Sub
Private Sub cmd_Cancel_Click()
Unload Me
End Sub
Private Sub cmd_Next_Click()
On Error GoTo err
If str_Data_Path = "" Then
MsgBox "数据备份路径不能为空!" + Chr(13) + "请选择要备份的数据路径!", vbCritical
dir_Directory.SetFocus
Exit Sub
ElseIf str_Data_Path = "a:\" Or str_Data_Path = "b:\" Or str_Data_Path = "b:\" Or str_Data_Path = "c:\" Or str_Data_Path = "d:\" Or str_Data_Path = "e:\" Or str_Data_Path = "f:\" Or str_Data_Path = "g:\" Or str_Data_Path = "h:\" Or str_Data_Path = "i:\" Or str_Data_Path = "j:\" Or str_Data_Path = "k:\" Or str_Data_Path = "A:\" Or str_Data_Path = "B:\" Or str_Data_Path = "C:\" Or str_Data_Path = "D:\" Or str_Data_Path = "E:\" Or str_Data_Path = "F:\" Or str_Data_Path = "G:\" Or str_Data_Path = "H:\" Or str_Data_Path = "I:\" Or str_Data_Path = "J:\" Or str_Data_Path = "K:\" Then
MsgBox ("不能将数据备份到根本录下，请重新选择路径！")
dir_Directory.SetFocus
Exit Sub
ElseIf Left(str_File_Name, 1) <> "A" And Left(str_File_Name, 1) <> "B" And Left(str_File_Name, 1) <> "C" And Left(str_File_Name, 1) <> "D" And Left(str_File_Name, 1) <> "E" And Left(str_File_Name, 1) <> "F" And Left(str_File_Name, 1) <> "G" And Left(str_File_Name, 1) <> "H" And Left(str_File_Name, 1) <> "I" And Left(str_File_Name, 1) <> "J" _
And Left(str_File_Name, 1) <> "K" And Left(str_File_Name, 1) <> "L" And Left(str_File_Name, 1) <> "M" And Left(str_File_Name, 1) <> "N" And Left(str_File_Name, 1) <> "O" And Left(str_File_Name, 1) <> "P" _
And Left(str_File_Name, 1) <> "Q" And Left(str_File_Name, 1) <> "R" And Left(str_File_Name, 1) <> "S" And Left(str_File_Name, 1) <> "T" And Left(str_File_Name, 1) <> "U" And Left(str_File_Name, 1) <> "V" And Left(str_File_Name, 1) <> "W" And Left(str_File_Name, 1) <> "X" And Left(str_File_Name, 1) <> "Y" And Left(str_File_Name, 1) <> "Z" Then
MsgBox "文件名只能以字母开头,数字和下划线结尾!" + Chr(13) + "请认真检查并输入!", vbCritical
Me.txt_FileName.SetFocus
Exit Sub
Else
Unload Me
Load Frm_Data_Backup_Three
Frm_Data_Backup_Three.Show vbModal
End If
Exit Sub
err:
MsgBox err.Description, vbCritical
End Sub
Private Sub dir_Directory_Change()
On Error GoTo err
str_Data_Path = dir_Directory
Exit Sub
err:
MsgBox err.Description, vbCritical
End Sub
Private Sub dir_Directory_Click()
On Error GoTo err
str_Data_Path = dir_Directory
Exit Sub
err:
MsgBox err.Description, vbCritical
End Sub
Private Sub drv_Driver_Change()
On Error GoTo err
dir_Directory.Path = drv_Driver.Drive
Exit Sub
err:
MsgBox err.Description, vbCritical
End Sub
Private Sub Form_Load()
On Error GoTo err
' Me.Left = 5500
' Me.Top = 3300
' Me.Icon = LoadPicture(App.Path & "\icon\system.ico")
str_Data_Path = ""
Me.txt_FileName = ""
str_Data_Path = dir_Directory
Exit Sub
err:
MsgBox err.Description, vbCritical
End Sub
Private Sub txt_FileName_Change()
On Error GoTo err
Me.txt_FileName.text = UCase(Trim(Me.txt_FileName.text))
str_File_Name = Me.txt_FileName.text & ".bak"
SendKeys "{end}"
' SendKeys "{end}"
Exit Sub
err:
MsgBox err.Description, vbCritical
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -