?? frmback.frm
字號:
VERSION 5.00
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "COMDLG32.OCX"
Begin VB.Form frmBackup
AutoRedraw = -1 'True
BackColor = &H00CCCCCC&
BorderStyle = 0 'None
Caption = "frmBackup"
ClientHeight = 2985
ClientLeft = 4500
ClientTop = 4005
ClientWidth = 5565
LinkTopic = "Form1"
ScaleHeight = 2985
ScaleWidth = 5565
ShowInTaskbar = 0 'False
StartUpPosition = 2 'CenterScreen
Begin VB.PictureBox BoxContainer
BackColor = &H00C0C0C0&
BorderStyle = 0 'None
FillColor = &H00C0C0C0&
Height = 2890
Left = 40
ScaleHeight = 2895
ScaleWidth = 5460
TabIndex = 0
Top = 40
Width = 5460
Begin MSComDlg.CommonDialog Dialog
Left = 480
Top = 1800
_ExtentX = 847
_ExtentY = 847
_Version = 393216
End
Begin VB.PictureBox cmdRestore
Appearance = 0 'Flat
AutoRedraw = -1 'True
BackColor = &H00CCCCCC&
BorderStyle = 0 'None
ForeColor = &H80000008&
Height = 450
Left = 1560
MouseIcon = "frmBack.frx":0000
MousePointer = 99 'Custom
ScaleHeight = 450
ScaleWidth = 2355
TabIndex = 4
TabStop = 0 'False
Top = 1320
Width = 2355
End
Begin VB.PictureBox cmdBackup
Appearance = 0 'Flat
AutoRedraw = -1 'True
BackColor = &H00CCCCCC&
BorderStyle = 0 'None
ForeColor = &H80000008&
Height = 450
Left = 1560
MouseIcon = "frmBack.frx":030A
MousePointer = 99 'Custom
ScaleHeight = 450
ScaleWidth = 2355
TabIndex = 3
TabStop = 0 'False
Top = 720
Width = 2355
End
Begin VB.PictureBox cmdOk
Appearance = 0 'Flat
AutoRedraw = -1 'True
BackColor = &H00C0C0C0&
BorderStyle = 0 'None
ForeColor = &H80000008&
Height = 570
Left = 2160
MouseIcon = "frmBack.frx":0614
MousePointer = 99 'Custom
ScaleHeight = 570
ScaleWidth = 1095
TabIndex = 1
Top = 2040
Width = 1100
End
Begin VB.PictureBox titleBar
BorderStyle = 0 'None
Height = 375
Left = 120
ScaleHeight = 375
ScaleWidth = 5205
TabIndex = 2
Top = 90
Width = 5200
End
End
Begin VB.Shape Shape1
BorderColor = &H00FFFFFF&
BorderWidth = 2
Height = 2950
Left = 15
Top = 15
Width = 5520
End
End
Attribute VB_Name = "frmBackup"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdBackup_Click()
On Error Resume Next
Call MacButton(" Backup Database", frmBackup.cmdBackup, 0, 0, 170, 30, frmLogin.Source, 182, 30, 2)
Dialog.filename = ""
Dialog.Filter = "Backup files (*.bck) |*.bck|"
Dialog.ShowSave
If Dialog.filename <> "" Then
If FileLen(App.Path & "\DATABASE\POS.MDB") > 1210000 And Mid(Dialog.filename, 1, 1) = "P" Then
Call MessageBox("frmBackup", "空間不夠", 0)
frmMessageBox.Show
Else
myDB.Close
FileCopy (App.Path & "\DATABASE\POS.MDB "), Dialog.filename
Call MessageBox("frmBackup", "備份完成!!!", 0)
myDB.Open
End If
End If
Call MacButton(" 備份數(shù)據(jù)", frmBackup.cmdBackup, 0, 0, 170, 30, frmLogin.Source, 147, 0, 2)
End Sub
Private Sub cmdRestore_Click()
On Error Resume Next
Call MacButton(" 恢復(fù)數(shù)據(jù)庫", frmBackup.cmdRestore, 0, 0, 170, 30, frmLogin.Source, 182, 30, 2)
Dialog.ShowOpen
If Dialog.filename <> "" Then
Call MessageBox("frmBackup", "你想要恢復(fù)數(shù)據(jù)嘛?", 1)
End If
Call MacButton(" 恢復(fù)數(shù)據(jù)", frmBackup.cmdRestore, 0, 0, 170, 30, frmLogin.Source, 147, 0, 2)
End Sub
Public Sub Restore_Database()
On Error Resume Next
myDB.Close
FileCopy Dialog.filename, "POS.MDB"
Call MessageBox("frmBackup", "數(shù)據(jù)已經(jīng)被恢復(fù)!!", 0)
myDB.Open
frmMessageBox.Show
End Sub
Private Sub cmdOk_Click()
Call MessageValidation
End Sub
Private Sub cmdOk_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Call MacButton(" Ok", cmdOk, 0, 0, 73, 50, frmLogin.Source, 74, 0, 1)
End Sub
Private Sub cmdOk_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
Call MacButton(" Ok", cmdOk, 0, 0, 73, 50, frmLogin.Source, 0, 0, 1)
End Sub
Private Sub Form_Load()
Call CreateMacOSTitleBar(titleBar, " 備份/恢復(fù)數(shù)據(jù) ")
Call MacButton(" Ok", cmdOk, 0, 0, 73, 50, frmLogin.Source, 0, 0, 1)
Call ColForm(BoxContainer, 217, 211, 213, 125)
Call MacButton(" 備份數(shù)據(jù)", frmBackup.cmdBackup, 0, 0, 170, 30, frmLogin.Source, 147, 0, 2)
Call MacButton(" 恢復(fù)數(shù)據(jù)", frmBackup.cmdRestore, 0, 0, 170, 30, frmLogin.Source, 147, 0, 2)
KeyPreview = True
End Sub
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode
Case vbKeyReturn:
Call MessageValidation
End Select
End Sub
Private Sub titleBar_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Call DragForm(Me)
End Sub
Function MessageValidation()
On Error Resume Next
If CmdType = "frmLogin" Then
frmLogin.txtUserName.SetFocus
ElseIf CmdType = "frmProduct" Then
frmProduct.txtField(1).SetFocus
ElseIf CmdType = "frmSupplier" Then
frmSupplier.txtField(0).SetFocus
ElseIf CmdType = "frmCategory" Then
frmCategory.txtField(0).SetFocus
ElseIf CmdType = "frmSelling" Then
frmSelling.txtField(0).SetFocus
ElseIf CmdType = "frmPassword" Then
frmPassword.txtField(0).SetFocus
ElseIf CmdType = "frmCodeFile" Then
frmCodeFile.txtField(0).SetFocus
End If
Unload Me
End Function
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -