?? frm公式修改.frm
字號:
VERSION 5.00
Begin VB.Form frm公式修改
BorderStyle = 3 'Fixed Dialog
Caption = "zztjk"
ClientHeight = 2355
ClientLeft = 1095
ClientTop = 330
ClientWidth = 7365
KeyPreview = -1 'True
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 2355
ScaleWidth = 7365
ShowInTaskbar = 0 'False
StartUpPosition = 2 '屏幕中心
Begin VB.CommandButton Com2
Caption = "統(tǒng)計表達式:"
BeginProperty Font
Name = "宋體"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 60
TabIndex = 13
Top = 780
Width = 1485
End
Begin VB.CommandButton Com1
Caption = "統(tǒng)計條件:"
BeginProperty Font
Name = "宋體"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 345
Left = 60
TabIndex = 12
Top = 390
Width = 1485
End
Begin VB.ComboBox Combo1
Height = 300
Left = 3180
Style = 2 'Dropdown List
TabIndex = 8
Top = 30
Width = 1965
End
Begin VB.PictureBox picButtons
Align = 2 'Align Bottom
Appearance = 0 'Flat
BorderStyle = 0 'None
ForeColor = &H80000008&
Height = 420
Left = 0
ScaleHeight = 420
ScaleWidth = 7365
TabIndex = 4
Top = 1530
Width = 7365
Begin VB.CommandButton cmd放棄
Caption = "放棄(&Q)"
BeginProperty Font
Name = "宋體"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 4944
TabIndex = 11
Top = 60
Width = 1095
End
Begin VB.CommandButton cmd修改
Caption = "修改(&E)"
BeginProperty Font
Name = "宋體"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 2532
TabIndex = 10
Top = 60
Width = 1095
End
Begin VB.CommandButton cmd保存
Caption = "保存(&S)"
BeginProperty Font
Name = "宋體"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 3750
TabIndex = 9
Top = 60
Width = 1095
End
Begin VB.CommandButton cmd關閉
Caption = "關閉(&C)"
BeginProperty Font
Name = "宋體"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 6150
TabIndex = 7
Top = 60
Width = 1095
End
Begin VB.CommandButton cmd刪除
Caption = "刪除(&D)"
BeginProperty Font
Name = "宋體"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 1326
TabIndex = 6
Top = 60
Width = 1095
End
Begin VB.CommandButton cmd添加
Caption = "添加(&A)"
BeginProperty Font
Name = "宋體"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 120
TabIndex = 5
Top = 60
Width = 1095
End
End
Begin VB.Data datPrimaryRS
Align = 2 'Align Bottom
Caption = " "
Connect = "Access"
DatabaseName = ""
DefaultCursorType= 0 'DefaultCursor
DefaultType = 2 'UseODBC
Exclusive = 0 'False
Height = 405
Left = 0
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = ""
Top = 1950
Width = 7365
End
Begin VB.TextBox txtFields
DataField = "統(tǒng)計公式"
DataSource = "datPrimaryRS"
BeginProperty Font
Name = "宋體"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 645
Index = 2
Left = 1590
MaxLength = 254
MultiLine = -1 'True
ScrollBars = 1 'Horizontal
TabIndex = 3
Top = 780
Width = 5715
End
Begin VB.TextBox txtFields
DataField = "統(tǒng)計條件"
DataSource = "datPrimaryRS"
BeginProperty Font
Name = "宋體"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 345
Index = 1
Left = 1590
MaxLength = 254
TabIndex = 2
Top = 380
Width = 5715
End
Begin VB.TextBox txtFields
DataField = "統(tǒng)計字段"
DataSource = "datPrimaryRS"
Enabled = 0 'False
BeginProperty Font
Name = "宋體"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 285
Index = 0
Left = 1470
MaxLength = 6
TabIndex = 1
Top = 30
Width = 1665
End
Begin VB.Label lblLabels
Caption = "統(tǒng)計字段:"
Enabled = 0 'False
BeginProperty Font
Name = "宋體"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 0
Left = 120
TabIndex = 0
Top = 60
Width = 1245
End
End
Attribute VB_Name = "frm公式修改"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim hxftjbj As Boolean
Dim hxfi As Integer
Option Explicit
Private Sub cmd保存_Click()
If Len(Trim(txtFields(0).Text)) > 0 And Len(Trim(txtFields(2).Text)) > 0 Then
datPrimaryRS.UpdateRecord
datPrimaryRS.Recordset.Bookmark = datPrimaryRS.Recordset.LastModified
cmd刪除.Enabled = True
cmd修改.Enabled = True
cmd關閉.Enabled = True
cmd保存.Enabled = False
cmd放棄.Enabled = False
cmd添加.Enabled = True
Combo1.Enabled = False
Com1.Enabled = False
Com2.Enabled = False
txtFields(1).Enabled = False
txtFields(2).Enabled = False
frm公式修改.Refresh
Else
hxfyn = MsgBox("統(tǒng)計字段和統(tǒng)計表達式不能為空!，請選擇！", 48)
End If
End Sub
Private Sub cmd放棄_Click()
cmd刪除.Enabled = True
cmd修改.Enabled = True
cmd關閉.Enabled = True
cmd保存.Enabled = False
cmd放棄.Enabled = False
cmd添加.Enabled = True
Combo1.Enabled = False
Com1.Enabled = False
Com2.Enabled = False
frm公式修改.Refresh
datPrimaryRS.Refresh
'If hxftjbj = True Then datPrimaryRS.Recordset.MoveLast
'If hxftjbj = False Then
datPrimaryRS.UpdateControls
txtFields(1).Enabled = False
txtFields(2).Enabled = False
End Sub
Private Sub cmd添加_Click()
datPrimaryRS.Recordset.AddNew
cmd刪除.Enabled = False
cmd修改.Enabled = False
cmd關閉.Enabled = False
cmd保存.Enabled = True
cmd放棄.Enabled = True
cmd添加.Enabled = False
Combo1.Enabled = True
Com1.Enabled = True
Com2.Enabled = True
txtFields(1).Enabled = True
txtFields(2).Enabled = True
End Sub
Private Sub cmd刪除_Click()
hxfyn = MsgBox("是否真的刪除?", 36)
If hxfyn = vbYes Then
With datPrimaryRS.Recordset
If Not .EOF Then
.Delete
.MoveNext
If .EOF And .RecordCount <> 0 Then .MoveLast
If .EOF And .RecordCount = 0 Then .MoveFirst
End If
End With
frm公式修改.Refresh
End If
End Sub
Private Sub cmd關閉_Click()
Screen.MousePointer = vbDefault
Unload Me
End Sub
Private Sub cmd修改_Click()
cmd刪除.Enabled = False
cmd修改.Enabled = False
cmd關閉.Enabled = False
cmd保存.Enabled = True
cmd放棄.Enabled = True
cmd添加.Enabled = False
Combo1.Enabled = True
Com1.Enabled = True
Com2.Enabled = True
txtFields(1).Enabled = True
txtFields(2).Enabled = True
End Sub
Private Sub Com1_Click()
hxfbds = txtFields(1).Text
frm表達式生成.Show 1
txtFields(1).Text = hxfbds
End Sub
Private Sub Com2_Click()
hxfbds = txtFields(2).Text
frm表達式生成.Show 1
txtFields(2).Text = hxfbds
End Sub
Private Sub Combo1_Click()
If Combo1.Text = "應發(fā)合計" Then
txtFields(0).Text = "應發(fā)合計"
GoTo en:
End If
If Combo1.Text = "代扣合計" Then
txtFields(0).Text = "代扣合計"
GoTo en:
End If
If Combo1.Text = "實發(fā)現(xiàn)金" Then
txtFields(0).Text = "實發(fā)現(xiàn)金"
GoTo en:
End If
tb1.MoveFirst
hxfi = 1
Do While hxfi <= 34
If tb1.Fields(hxfi - 1).Value = Combo1.Text Then
txtFields(0).Text = tb1.Fields(hxfi - 1).Name
Exit Do
Else
hxfi = hxfi + 1
End If
Loop
en: End Sub
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyPageUp And Not datPrimaryRS.Recordset.BOF Then
datPrimaryRS.Recordset.MovePrevious
If datPrimaryRS.Recordset.BOF Then datPrimaryRS.Recordset.MoveFirst
End If
If KeyCode = vbKeyPageDown And Not datPrimaryRS.Recordset.EOF Then
datPrimaryRS.Recordset.MoveNext
If datPrimaryRS.Recordset.EOF Then datPrimaryRS.Recordset.MoveLast
End If
End Sub
Private Sub Form_Load()
Combo1.Enabled = False
Com1.Enabled = False
Com2.Enabled = False
cmd刪除.Enabled = True
cmd修改.Enabled = True
cmd關閉.Enabled = True
cmd保存.Enabled = False
cmd放棄.Enabled = False
cmd添加.Enabled = True
txtFields(1).Enabled = False
txtFields(2).Enabled = False
End Sub
Private Sub Form_Unload(Cancel As Integer)
Screen.MousePointer = vbDefault
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -