📄 付款单.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 付款单
BackColor = &H00FFFFFF&
Caption = "付款单"
ClientHeight = 6735
ClientLeft = 60
ClientTop = 345
ClientWidth = 11730
ClipControls = 0 'False
Icon = "付款单.frx":0000
LinkTopic = "Form1"
ScaleHeight = 6735
ScaleWidth = 11730
StartUpPosition = 3 '窗口缺省
Begin VB.TextBox Text2
Height = 345
Left = 6540
TabIndex = 18
Top = 5700
Width = 2535
End
Begin MSComctlLib.Toolbar Toolbar1
Align = 1 'Align Top
Height = 1110
Left = 0
TabIndex = 16
Top = 0
Width = 11730
_ExtentX = 20690
_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 = 1770
Top = 870
_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":0442
Key = "save"
Object.Tag = "sa"
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "付款单.frx":214C
Key = "modify"
Object.Tag = "mo"
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "付款单.frx":259E
Key = "print"
Object.Tag = "pr"
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "付款单.frx":33F0
Key = "quit"
Object.Tag = "qu"
EndProperty
EndProperty
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 315
Index = 11
Left = 8640
TabIndex = 15
Top = 4020
Width = 2655
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 315
Index = 10
Left = 8610
TabIndex = 14
Top = 3690
Width = 2655
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 315
Index = 9
Left = 8640
TabIndex = 13
Top = 2640
Width = 2625
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 315
Index = 8
Left = 8640
TabIndex = 12
Top = 2310
Width = 2625
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 315
Index = 7
Left = 3780
TabIndex = 11
Top = 4710
Width = 7485
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 315
Index = 6
Left = 3780
TabIndex = 10
Top = 4380
Width = 7485
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 285
Index = 5
Left = 3780
TabIndex = 9
Top = 4050
Width = 3735
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 315
Index = 4
Left = 3780
TabIndex = 8
Top = 3690
Width = 3705
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 315
Index = 3
Left = 3780
TabIndex = 7
Top = 3330
Width = 7485
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 315
Index = 2
Left = 3780
TabIndex = 6
Top = 3000
Width = 7485
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 285
Index = 1
Left = 3780
TabIndex = 5
Top = 2640
Width = 3705
End
Begin VB.TextBox Text1
BorderStyle = 0 'None
Height = 315
Index = 0
Left = 3780
TabIndex = 4
Top = 2310
Width = 3735
End
Begin MSComDlg.CommonDialog cd
Left = 0
Top = 0
_ExtentX = 847
_ExtentY = 847
_Version = 393216
End
Begin VB.Label Label3
BackStyle = 0 'Transparent
Caption = "输入付款单编号"
Height = 525
Left = 5190
TabIndex = 19
Top = 5820
Width = 1305
End
Begin VB.Label date1
BackStyle = 0 'Transparent
Height = 405
Left = 780
TabIndex = 17
Top = 1860
Width = 3135
End
Begin VB.Label Label2
BackStyle = 0 'Transparent
Caption = "№：00000001"
Height = 255
Left = 8580
TabIndex = 3
Top = 1980
Width = 2535
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 = 4380
TabIndex = 2
Top = 1470
Width = 2145
End
Begin VB.Line Line1
BorderColor = &H00004000&
BorderWidth = 4
X1 = 4290
X2 = 6720
Y1 = 1920
Y2 = 1920
End
Begin VB.Label date
BackStyle = 0 'Transparent
Caption = "日期："
Height = 255
Left = 240
TabIndex = 1
Top = 2010
Width = 2415
End
Begin WordCtl.Document Document1
Height = 3165
Left = 30
OleObjectBlob = "付款单.frx":370A
TabIndex = 0
Top = 2250
Width = 12990
End
End
Attribute VB_Name = "付款单"
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)
Dim txtSQL, Tsql, MsgText As String
Dim mrc As ADODB.Recordset
Static numj, micount As Integer
Select Case Button.Key
Case "save"
numj = numj + 1
Tsql = " 收款单号 ='" & Trim((Text2.Text) & " ") & "'"
Label2.Caption = "№0000000" & numj
txtSQL = "select *from 收款单 where" & Tsql
Set mrc = ExecuteSQL(txtSQL, MsgText)
If Trim(Text2.Text) = "" Then
MsgBox "没有输入付款单编号"
Exit Sub
End If
If mrc.RecordCount = 0 Then
MsgBox "没有记录！"
Label2.Caption = "№0000000"
Exit Sub
Unload Me
End If
Dim i As Integer
For i = 0 To 11
Text1(i).Text = mrc.Fields(i)
Next i
mrc.Update
mrc.Close
Case "modify"
MsgBox "直接在单上修改保存既可！"
Case "print"
付款单.PrintForm
Case "quit"
Unload Me
End Select
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -