📄 frmfahan.frm
字号:
BeginProperty Column06
ColumnWidth = 2085.166
EndProperty
BeginProperty Column07
ColumnWidth = 794.835
EndProperty
BeginProperty Column08
ColumnWidth = 615.118
EndProperty
BeginProperty Column09
ColumnWidth = 2085.166
EndProperty
BeginProperty Column10
ColumnWidth = 2085.166
EndProperty
BeginProperty Column11
ColumnWidth = 1365.165
EndProperty
BeginProperty Column12
ColumnWidth = 1094.74
EndProperty
BeginProperty Column13
ColumnWidth = 2085.166
EndProperty
BeginProperty Column14
ColumnWidth = 2085.166
EndProperty
EndProperty
End
Begin MSComCtl2.DTPicker DTPicker1
DataField = "发文日期"
DataSource = "datPrimaryRS"
Height = 330
Index = 1
Left = 4290
TabIndex = 40
Top = 3090
Width = 1335
_ExtentX = 2355
_ExtentY = 582
_Version = 393216
CalendarBackColor= -2147483624
Format = 26935297
CurrentDate = 37038
End
Begin MSAdodcLib.Adodc Adodc4
Height = 330
Left = -74160
Top = 3060
Visible = 0 'False
Width = 1935
_ExtentX = 3413
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 1
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = ""
OLEDBString = ""
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = ""
Caption = "Adodc4"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin VB.Label lblLabels
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "相关文件:"
ForeColor = &H80000008&
Height = 180
Index = 12
Left = 240
TabIndex = 54
Top = 4710
Width = 810
End
Begin VB.Label lblLabels
Alignment = 1 'Right Justify
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "签发人:"
ForeColor = &H80000008&
Height = 180
Index = 10
Left = 3420
TabIndex = 53
Top = 4710
Width = 810
End
Begin VB.Label lblLabels
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "主题词:"
ForeColor = &H80000008&
Height = 180
Index = 9
Left = 420
TabIndex = 52
Top = 4200
Width = 660
End
Begin VB.Label lblLabels
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "文件页数:"
ForeColor = &H80000008&
Height = 180
Index = 7
Left = 240
TabIndex = 51
Top = 3690
Width = 810
End
Begin VB.Label lblLabels
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "文件日期:"
ForeColor = &H80000008&
Height = 180
Index = 5
Left = 240
TabIndex = 50
Top = 3135
Width = 810
End
Begin VB.Label lblLabels
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "文件名称:"
ForeColor = &H80000008&
Height = 180
Index = 4
Left = 240
TabIndex = 49
Top = 2640
Width = 810
End
Begin VB.Label lblLabels
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "发送单位:"
ForeColor = &H80000008&
Height = 180
Index = 3
Left = 240
TabIndex = 48
Top = 2130
Width = 810
End
Begin VB.Label lblLabels
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "部门:"
ForeColor = &H80000008&
Height = 180
Index = 2
Left = 600
TabIndex = 47
Top = 1110
Width = 480
End
Begin VB.Label lblLabels
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "年度:"
ForeColor = &H80000008&
Height = 180
Index = 0
Left = 600
TabIndex = 46
Top = 600
Width = 480
End
Begin VB.Label lblLabels
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "文件编号:"
ForeColor = &H80000008&
Height = 180
Index = 14
Left = 240
TabIndex = 45
Top = 1650
Width = 810
End
Begin VB.Label lblLabels
Alignment = 1 'Right Justify
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "文件分类:"
ForeColor = &H80000008&
Height = 180
Index = 11
Left = 3420
TabIndex = 44
Top = 1110
Width = 810
End
Begin VB.Label lblLabels
Alignment = 1 'Right Justify
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "附件数:"
ForeColor = &H80000008&
Height = 180
Index = 8
Left = 3420
TabIndex = 43
Top = 3660
Width = 810
End
Begin VB.Label lblLabels
Alignment = 1 'Right Justify
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "发文日期:"
ForeColor = &H80000008&
Height = 180
Index = 6
Left = 3420
TabIndex = 42
Top = 3180
Width = 810
End
Begin VB.Label lblLabels
Alignment = 1 'Right Justify
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "序号:"
ForeColor = &H80000008&
Height = 180
Index = 1
Left = 3420
TabIndex = 41
Top = 600
Width = 810
End
End
Begin VB.Label lbl记录数
Appearance = 0 'Flat
BackColor = &H00FFF8E7&
Caption = "0"
ForeColor = &H80000008&
Height = 330
Left = 3420
TabIndex = 56
Top = 5490
Width = 525
End
Begin VB.Label lblLabels
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "共有条目数:"
ForeColor = &H80000008&
Height = 330
Index = 15
Left = 1890
TabIndex = 55
Top = 5490
Width = 1065
End
End
Attribute VB_Name = "frmFaHan"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim strUserName As String
Private Sub cmdAll_Click()
datPrimaryRS.Recordset.Filter = ""
datPrimaryRS.Refresh
SSTab1.Tab = 1
End Sub
Private Sub cmdCancel_Click()
SSTab1.Tab = 1
End Sub
Private Sub cmdFaWen_Click()
If Not (Adodc4.Recordset.EOF Or Adodc4.Recordset.BOF) Then
If Not IsNull(Adodc4.Recordset.Fields("事由").Value) Then
txtFields(4).Text = Adodc4.Recordset.Fields("事由").Value
End If
If Not IsNull(Adodc4.Recordset.Fields("主题词").Value) Then
txtFields(9).Text = Adodc4.Recordset.Fields("主题词").Value
End If
If Not IsNull(Adodc4.Recordset.Fields("内容").Value) Then
txtFields(5).Text = Adodc4.Recordset.Fields("内容").Value
End If
End If
SSTab1.Tab = 0
End Sub
Private Sub cmdFilter_Click()
Dim strFilter As String
'生成filter字符串
strFilter = ""
If Trim(txtFields(5).Text) <> "" Then
strFilter = "年度=" & Trim(txtFields(5).Text)
End If
If Trim(txtFields(6).Text) <> "" Then
If strFilter = "" Then
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -