📄 frm_main.frm
字号:
VERSION 5.00
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "COMDLG32.OCX"
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Begin VB.Form frm_main
BackColor = &H8000000C&
Caption = "家庭理财管理系统"
ClientHeight = 6375
ClientLeft = 165
ClientTop = 435
ClientWidth = 11355
Icon = "frm_main.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
ScaleHeight = 6375
ScaleWidth = 11355
StartUpPosition = 2 '屏幕中心
WindowState = 2 'Maximized
Begin MSComDlg.CommonDialog CommonDialog1
Left = 4080
Top = 600
_ExtentX = 847
_ExtentY = 847
_Version = 393216
DefaultExt = "mdb"
Filter = "mdb"
End
Begin MSComctlLib.ImageList ImageList1
Left = 4680
Top = 600
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 16
ImageHeight = 16
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 13
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frm_main.frx":030A
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frm_main.frx":06A6
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frm_main.frx":0F82
Key = ""
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frm_main.frx":131E
Key = ""
EndProperty
BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frm_main.frx":16BA
Key = ""
EndProperty
BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frm_main.frx":1A56
Key = ""
EndProperty
BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frm_main.frx":1DF2
Key = ""
EndProperty
BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frm_main.frx":218E
Key = ""
EndProperty
BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frm_main.frx":252A
Key = ""
EndProperty
BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frm_main.frx":28C6
Key = ""
EndProperty
BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frm_main.frx":2C62
Key = ""
EndProperty
BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frm_main.frx":2FFE
Key = ""
EndProperty
BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frm_main.frx":38DA
Key = ""
EndProperty
EndProperty
End
Begin MSComctlLib.Toolbar Toolbar1
Align = 1 'Align Top
Height = 420
Left = 0
TabIndex = 0
Top = 0
Width = 11355
_ExtentX = 20029
_ExtentY = 741
ButtonWidth = 609
ButtonHeight = 582
Appearance = 1
ImageList = "ImageList1"
_Version = 393216
BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
NumButtons = 15
BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
Key = "收支项目管理"
Object.ToolTipText = "收支项目管理"
ImageIndex = 1
EndProperty
BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
Key = "添加家庭成员"
Object.ToolTipText = "添加家庭成员"
ImageIndex = 2
EndProperty
BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
Key = "修改密码"
Object.ToolTipText = "修改密码"
ImageIndex = 3
EndProperty
BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628}
Key = "导出数据库"
Object.ToolTipText = "导出数据库"
ImageIndex = 4
EndProperty
BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628}
Key = "导入数据库"
Object.ToolTipText = "导入数据库"
ImageIndex = 5
EndProperty
BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628}
Key = "日常收入"
Object.ToolTipText = "日常收入"
ImageIndex = 6
EndProperty
BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628}
Key = "日常支出"
Object.ToolTipText = "日常支出"
ImageIndex = 7
EndProperty
BeginProperty Button10 {66833FEA-8583-11D1-B16A-00C0F0283628}
Key = "活期存款"
Object.ToolTipText = "活期存款"
ImageIndex = 8
EndProperty
BeginProperty Button11 {66833FEA-8583-11D1-B16A-00C0F0283628}
Key = "理财报告"
Object.ToolTipText = "每月明细"
Object.Tag = "理财报告"
ImageIndex = 9
EndProperty
BeginProperty Button12 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button13 {66833FEA-8583-11D1-B16A-00C0F0283628}
Key = "查询"
Object.ToolTipText = "查询"
ImageIndex = 10
EndProperty
BeginProperty Button14 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button15 {66833FEA-8583-11D1-B16A-00C0F0283628}
Key = "退出"
Object.ToolTipText = "退出"
ImageIndex = 13
EndProperty
EndProperty
End
Begin VB.Menu mnu_xt
Caption = "系统设置(&S)"
Begin VB.Menu mnuout
Caption = "导出数据库"
End
Begin VB.Menu mnuinput
Caption = "导入数据库"
End
Begin VB.Menu mnu_0
Caption = "-"
End
Begin VB.Menu mnu_xt_xg
Caption = "修改密码"
End
Begin VB.Menu mnu_xt_shz
Caption = "重新登陆"
End
Begin VB.Menu mnuexit
Caption = "退出"
End
End
Begin VB.Menu mnudata
Caption = "基础数据管理(&D)"
Begin VB.Menu mnu_xt_xu
Caption = "收支项目管理"
End
Begin VB.Menu mnu_xy_family
Caption = "家庭成员管理"
End
End
Begin VB.Menu mnu_rcgl
Caption = "日常收支管理(&N)"
Begin VB.Menu mnu_rcgl_sr
Caption = "日常收入"
End
Begin VB.Menu mnu_rcgl_zc
Caption = "日常支出"
End
End
Begin VB.Menu mnubank
Caption = "银行储蓄管理(&B)"
Begin VB.Menu mnu_rcgl_hq
Caption = "活期帐户"
End
Begin VB.Menu mnu_rcgl_dq
Caption = "定期储蓄"
End
End
Begin VB.Menu mnuborrwand
Caption = "借还钱管理(&H)"
Begin VB.Menu mnu_rcgl_jr
Caption = "借入款"
End
Begin VB.Menu mnu_rcgl_jc
Caption = "借出款"
End
End
Begin VB.Menu mnuanlysis
Caption = "理财分析(&A)"
Begin VB.Menu mnu_cx
Caption = "查询明细"
End
Begin VB.Menu mnu_bg_yue
Caption = "理财报告"
End
End
Begin VB.Menu Tools
Caption = "应用工具(&L)"
Begin VB.Menu Calculate
Caption = "计算器"
End
Begin VB.Menu Web
Caption = "Web浏览器"
End
End
End
Attribute VB_Name = "frm_main"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Calculate_Click()
frm_calculate.Show 0, frm_main
End Sub
Private Sub mnu_bg_yue_Click()
frm_list.Show 0, frm_main '参数,让frm_main为主窗体打开多个子窗体
End Sub
Private Sub mnu_cx_shouru_Click()
frm_query.Show 0, frm_main
End Sub
Private Sub mnu_bz_zt_Click()
End Sub
Private Sub mnu_cx_Click()
frm_query.Show 0, frm_main
End Sub
Private Sub mnu_rcgl_dq_Click()
frm_fix.Show 0, frm_main
End Sub
Private Sub mnu_rcgl_hq_Click()
frm_live.Show 0, frm_main
End Sub
Private Sub mnu_rcgl_jc_Click()
frm_borrowgo.Show 0, frm_main
End Sub
Private Sub mnu_rcgl_jr_Click()
frm_borrowin.Show 0, frm_main
End Sub
Private Sub mnu_rcgl_sr_Click()
frm_intake.Show 0, frm_main
End Sub
Private Sub mnu_rcgl_zc_Click()
frm_expend.Show 0, frm_main
End Sub
Private Sub mnu_xt_shz_Click()
frm_login.Show
Unload Me
End Sub
Private Sub mnu_xt_xg_Click()
frm_password.Show 0, frm_main
End Sub
Private Sub mnu_xt_xu_Click()
frm_project.Show 0, frm_main
End Sub
Private Sub mnu_xy_family_Click()
frm_family.Show 0, frm_main
End Sub
Private Sub mnuexit_Click()
Unload Me
End Sub
Private Sub mnuinput_Click()
Call FileIn
End Sub
Private Sub mnuout_Click()
Call FileGo
End Sub
Private Sub toolbar1_buttonclick(ByVal button As MSComctlLib.button)
Select Case button.Index
Case 1
Call mnu_xt_xu_Click
Case 2
Call mnu_xy_family_Click
Case 3
Call mnu_xt_xg_Click
Case 5
Call FileGo
Case 6
Call FileIn
Case 8
Call mnu_rcgl_sr_Click
Case 9
Call mnu_rcgl_zc_Click
Case 10
Call mnu_rcgl_hq_Click
Case 11
mnu_bg_yue_Click
Case 13
Call mnu_cx_Click
Case 15
Unload Me
End Select
End Sub
Private Function FileGo()
On Error GoTo 1
Dim A, B As String
CommonDialog1.ShowSave
A = CommonDialog1.FileName
B = App.Path & "\" & "database\MoneyMIS.mdb"
Set fs = CreateObject("Scripting.FileSystemObject")
fs.CopyFile B, A
MsgBox "数据库导出成功！", vbOKOnly + 64, "成功"
Exit Function
1:
MsgBox "数据库导出失败！", vbOKOnly + 64, "失败"
End Function
Private Function FileIn()
On Error GoTo 1
Dim A, B, C, D As String
C = MsgBox("是否真的导入数据库，导入新数据库后，将覆盖原来的所有录？", vbYesNo + 48 + 256, "警告")
If C = vbYes Then
CommonDialog1.ShowOpen
A = CommonDialog1.FileName
B = App.Path & "\" & "database\MoneyMIS.mdb"
'D = CurDir() & "\" & "MoneyMIS.mdb"
Set Fs1 = CreateObject("Sfcripting.FileSystemObject")
'Fs1.DeleteFile D, True
Fs1.CopyFile A, B
MsgBox "数据库导入成功！", vbOKOnly + 64, "成功"
Else
MsgBox "数据库导入失败！", vbOKOnly + 64, "失败"
End If
Exit Function
1:
MsgBox "数据库导入失败！", vbOKOnly + 64, "失败"
End Function
Private Sub Web_Click()
frm_internet.Show 0, frm_main
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -