📄 收款单.frm
字号:
VERSION 5.00
Object = "Word.Document.8"; "WINWORD.EXE"
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "Comdlg32.ocx"
Begin VB.Form tpaper2
BackColor = &H00FFFFFF&
Caption = "收款单"
ClientHeight = 7605
ClientLeft = 60
ClientTop = 345
ClientWidth = 13275
FillColor = &H00404000&
BeginProperty Font
Name = "新宋体"
Size = 18
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Icon = "收款单.frx":0000
LinkTopic = "Form1"
ScaleHeight = 7605
ScaleWidth = 13275
StartUpPosition = 3 '窗口缺省
Begin MSComctlLib.Toolbar Toolbar1
Align = 1 'Align Top
Height = 1110
Left = 0
TabIndex = 16
Top = 0
Width = 13275
_ExtentX = 23416
_ExtentY = 1958
ButtonWidth = 1455
ButtonHeight = 1799
Appearance = 1
ImageList = "ImageList1"
_Version = 393216
BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
NumButtons = 4
BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "保存"
Key = "save"
ImageIndex = 1
EndProperty
BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "修改"
Key = "modify"
ImageIndex = 2
EndProperty
BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "打印"
Key = "print"
ImageIndex = 3
EndProperty
BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "退出"
Key = "quit"
ImageIndex = 4
EndProperty
EndProperty
End
Begin MSComctlLib.ImageList ImageList1
Left = 1800
Top = 630
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 48
ImageHeight = 48
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 4
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "收款单.frx":0E42
Key = "save"
Object.Tag = "sa"
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "收款单.frx":2B4C
Key = "modify"
Object.Tag = "mo"
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "收款单.frx":2F9E
Key = "print"
Object.Tag = "pr"
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "收款单.frx":3DF0
Key = "quit"
Object.Tag = "qu"
EndProperty
EndProperty
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 285
Index = 11
Left = 9630
TabIndex = 15
Top = 4380
Width = 2655
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 285
Index = 10
Left = 9630
TabIndex = 14
Top = 4050
Width = 2655
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 285
Index = 9
Left = 9660
TabIndex = 13
Top = 3090
Width = 2625
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 285
Index = 8
Left = 9660
TabIndex = 12
Top = 2760
Width = 2625
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 315
Index = 7
Left = 4800
TabIndex = 11
Top = 5010
Width = 7485
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 315
Index = 6
Left = 4800
TabIndex = 10
Top = 4680
Width = 7485
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 285
Index = 5
Left = 4800
TabIndex = 9
Top = 4380
Width = 3735
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 285
Index = 4
Left = 4800
TabIndex = 8
Top = 4050
Width = 3705
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 285
Index = 3
Left = 4800
TabIndex = 7
Top = 3720
Width = 7485
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 315
Index = 2
Left = 4800
TabIndex = 6
Top = 3390
Width = 7485
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 285
Index = 1
Left = 4800
TabIndex = 5
Top = 3090
Width = 3705
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 315
Index = 0
Left = 4800
TabIndex = 4
Top = 2730
Width = 3735
End
Begin MSComDlg.CommonDialog cd
Left = 0
Top = 0
_ExtentX = 847
_ExtentY = 847
_Version = 393216
End
Begin VB.Label date1
BackStyle = 0 'Transparent
Height = 345
Left = 1830
TabIndex = 17
Top = 2370
Width = 1935
End
Begin VB.Label Label1
Alignment = 2 'Center
BackStyle = 0 'Transparent
Caption = "收款单"
BeginProperty Font
Name = "宋体"
Size = 21.75
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 405
Left = 5430
TabIndex = 3
Top = 1950
Width = 2145
End
Begin VB.Line Line1
BorderColor = &H00004000&
BorderWidth = 4
X1 = 5340
X2 = 7770
Y1 = 2400
Y2 = 2400
End
Begin VB.Label date
BackStyle = 0 'Transparent
Caption = "日期："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 1290
TabIndex = 2
Top = 2490
Width = 2415
End
Begin VB.Label Label2
BackStyle = 0 'Transparent
Caption = "№：00000001"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 10230
TabIndex = 1
Top = 2490
Width = 2535
End
Begin WordCtl.Document Document1
Height = 3165
Left = 1050
OleObjectBlob = "收款单.frx":410A
TabIndex = 0
Top = 2700
Width = 12990
End
End
Attribute VB_Name = "tpaper2"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private Sub Form_Load()
date1.Caption = Year(Now) & "年" & Month(Now) & "月" & Day(Now) & "日"
End Sub
Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
Select Case Button.Key
Case "save"
Static numi As Integer
numi = numi + 1
num = numi
Dim txtSQL(0 To 2) As String
Dim mrc As ADODB.Recordset
Dim MsgText As String
Dim miCount As Integer
'ToDo: create test for correct password
'check for correct password
txtSQL(0) = "select *from 收款单 "
Set mrc = ExecuteSQL(txtSQL(0), MsgText)
miCount = mrc.RecordCount + 1
If numi <= miCount Then numi = miCount
Label2.Caption = "№0000000" & numi
mrc.AddNew
Dim i As Integer
For i = 0 To 11
mrc.Fields(i) = Trim(Text1(i).Text)
Next i
mrc.Fields(12) = numi
mrc.Update
mrc.Close
MsgBox "收款单保存入数据库成功！", vbOKOnly + vbExclamation, "保存收款单"
Unload Me
Case "modify"
MsgBox "直接在单上修改保存既可！"
Case "print"
付款单.PrintForm
Case "quit"
Unload Me
End Select
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -