?? formsum.frm
字號:
VERSION 5.00
Object = "{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0"; "FM20.DLL"
Begin VB.Form Formsum
BorderStyle = 3 'Fixed Dialog
Caption = "在此進行匯編工作"
ClientHeight = 4935
ClientLeft = 45
ClientTop = 330
ClientWidth = 6975
Icon = "Formsum.frx":0000
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
MinButton = 0 'False
Picture = "Formsum.frx":0442
ScaleHeight = 4935
ScaleWidth = 6975
ShowInTaskbar = 0 'False
StartUpPosition = 2 '屏幕中心
Begin MSForms.CommandButton CommandButton8
Height = 495
Left = 4920
TabIndex = 7
Top = 4080
Width = 1695
BackColor = 16777152
Caption = "返回"
Size = "2990;873"
FontName = "宋體"
FontHeight = 180
FontCharSet = 134
FontPitchAndFamily= 34
ParagraphAlign = 3
End
Begin MSForms.CommandButton CommandButton1
Height = 495
Left = 240
TabIndex = 6
Top = 360
Width = 3015
BackColor = 16777152
Caption = "檔案室庫存檔案目錄匯編"
Size = "5318;873"
FontName = "宋體"
FontHeight = 180
FontCharSet = 134
FontPitchAndFamily= 34
ParagraphAlign = 3
End
Begin MSForms.CommandButton CommandButton2
Height = 495
Left = 240
TabIndex = 5
Top = 1600
Width = 3015
BackColor = 16777152
Caption = "庫存檔案分類目錄匯編"
Size = "5318;873"
FontName = "宋體"
FontHeight = 180
FontCharSet = 134
FontPitchAndFamily= 34
ParagraphAlign = 3
End
Begin MSForms.CommandButton CommandButton3
Height = 495
Left = 240
TabIndex = 4
Top = 2840
Width = 3015
BackColor = 16777152
Caption = "案卷內容簡介匯編"
Size = "5318;873"
FontName = "宋體"
FontHeight = 180
FontCharSet = 134
FontPitchAndFamily= 34
ParagraphAlign = 3
End
Begin MSForms.CommandButton CommandButton4
Height = 495
Left = 240
TabIndex = 3
Top = 4080
Width = 3615
BackColor = 16777152
Caption = "按作者或課題負責人排列的案卷目錄匯編"
Size = "6376;873"
FontName = "宋體"
FontHeight = 180
FontCharSet = 134
FontPitchAndFamily= 34
ParagraphAlign = 3
End
Begin MSForms.CommandButton CommandButton5
Height = 495
Left = 3600
TabIndex = 2
Top = 360
Width = 3015
BackColor = 16777152
Caption = "相同保管期限的案卷目錄匯編"
Size = "5318;873"
FontName = "宋體"
FontHeight = 180
FontCharSet = 134
FontPitchAndFamily= 34
ParagraphAlign = 3
End
Begin MSForms.CommandButton CommandButton6
Height = 495
Left = 3600
TabIndex = 1
Top = 1600
Width = 3015
BackColor = 16777152
Caption = "相同密級的案卷目錄匯編"
Size = "5318;873"
FontName = "宋體"
FontHeight = 180
FontCharSet = 134
FontPitchAndFamily= 34
ParagraphAlign = 3
End
Begin MSForms.CommandButton CommandButton7
Height = 495
Left = 3600
TabIndex = 0
Top = 2840
Width = 3015
BackColor = 16777152
Caption = "具有相同主題詞的案卷目錄匯編"
Size = "5318;873"
FontName = "宋體"
FontHeight = 180
FontCharSet = 134
FontPitchAndFamily= 34
ParagraphAlign = 3
End
End
Attribute VB_Name = "Formsum"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
''''''''''''''''''''''''''''''''''
'當選擇“編研匯編”后彈出
''''''''''''''''''''''''''''''''''
Private Sub CommandButton1_Click()
On Error Resume Next
Formsumlist.Adodc2.RecordSource = "select 檔案號 as 案卷號,存放地點 as 匯編依據 from [檔案]"
Formsumlist.Adodc2.Refresh
If Formsumlist.Adodc2.Recordset.RecordCount = 0 Then
MsgBox "因無相關檔案,還無法成冊", , "注意:"
Else
Formsumlist.Adodc2.Recordset.MoveFirst
Formsumlist.Adodc1.Refresh
If Formsumlist.Adodc1.Recordset.RecordCount = 0 Then
Else
Formsumlist.Adodc1.Recordset.MoveFirst
Do Until Formsumlist.Adodc1.Recordset.EOF
Formsumlist.Adodc1.Recordset.Delete
Formsumlist.Adodc1.Recordset.MoveNext
Loop
End If
Do Until Formsumlist.Adodc2.Recordset.EOF
Formsumlist.Adodc1.Recordset.AddNew
Formsumlist.Adodc1.Recordset![案卷號] = Formsumlist.Adodc2.Recordset![案卷號]
Formsumlist.Adodc1.Recordset![匯編依據] = Formsumlist.Adodc2.Recordset![匯編依據]
Formsumlist.Adodc1.Recordset.Update
Formsumlist.Adodc2.Recordset.MoveNext
Loop
Formsumlist.Adodc1.RecordSource = "select * from [匯編] " 'group by [匯編依據]
Formsumlist.Adodc1.Refresh
Formsumlist.MSHFlexGrid1.MergeCells = flexMergeRestrictColumns
Formsumlist.MSHFlexGrid1.MergeRow(2) = True
Formsumlist.MSHFlexGrid1.MergeRow(1) = True
Formsumlist.MSHFlexGrid1.MergeRow(3) = True
Formsumlist.MSHFlexGrid1.ColWidth(1) = 3000
Formsumlist.MSHFlexGrid1.ColWidth(2) = 6000
Formsumlist.MSHFlexGrid1.ColWidth(3) = 0
Me.Hide
Formsumlist.Show
End If
End Sub
Private Sub CommandButton2_Click()
Formsumlist.Adodc2.RecordSource = "select 檔案號 as 案卷號,檔案類型 as 匯編依據 from [檔案]"
Formsumlist.Adodc2.Refresh
If Formsumlist.Adodc2.Recordset.RecordCount = 0 Then
MsgBox "因無相關檔案,還無法成冊", , "注意:"
Else
Formsumlist.Adodc2.Recordset.MoveFirst
Formsumlist.Adodc1.Refresh
If Formsumlist.Adodc1.Recordset.RecordCount = 0 Then
Else
Formsumlist.Adodc1.Recordset.MoveFirst
Do Until Formsumlist.Adodc1.Recordset.EOF
Formsumlist.Adodc1.Recordset.Delete
Formsumlist.Adodc1.Recordset.MoveNext
Loop
End If
Do Until Formsumlist.Adodc2.Recordset.EOF
Formsumlist.Adodc1.Recordset.AddNew
Formsumlist.Adodc1.Recordset![案卷號] = Formsumlist.Adodc2.Recordset![案卷號]
Formsumlist.Adodc1.Recordset![匯編依據] = Formsumlist.Adodc2.Recordset![匯編依據]
Formsumlist.Adodc1.Recordset.Update
Formsumlist.Adodc2.Recordset.MoveNext
Loop
Formsumlist.Adodc1.RecordSource = "select * from [匯編] " 'group by [匯編依據]
Formsumlist.Adodc1.Refresh
Formsumlist.MSHFlexGrid1.MergeRow(2) = True
Formsumlist.MSHFlexGrid1.ColWidth(1) = 3000
Formsumlist.MSHFlexGrid1.ColWidth(2) = 6000
Formsumlist.MSHFlexGrid1.ColWidth(3) = 0
Me.Hide
Formsumlist.Show
End If
End Sub
Private Sub CommandButton3_Click()
Formsumlist.Adodc2.RecordSource = "select 檔案號 as 案卷號,案卷內容簡介 as 匯編依據 from [檔案]"
Formsumlist.Adodc2.Refresh
If Formsumlist.Adodc2.Recordset.RecordCount = 0 Then
MsgBox "因無相關檔案,還無法成冊", , "注意:"
Else
Formsumlist.Adodc2.Recordset.MoveFirst
Formsumlist.Adodc1.Refresh
If Formsumlist.Adodc1.Recordset.RecordCount = 0 Then
Else
Formsumlist.Adodc1.Recordset.MoveFirst
Do Until Formsumlist.Adodc1.Recordset.EOF
Formsumlist.Adodc1.Recordset.Delete
Formsumlist.Adodc1.Recordset.MoveNext
Loop
End If
Do Until Formsumlist.Adodc2.Recordset.EOF
Formsumlist.Adodc1.Recordset.AddNew
Formsumlist.Adodc1.Recordset![案卷號] = Formsumlist.Adodc2.Recordset![案卷號]
Formsumlist.Adodc1.Recordset![匯編依據] = Formsumlist.Adodc2.Recordset![匯編依據]
Formsumlist.Adodc1.Recordset.Update
Formsumlist.Adodc2.Recordset.MoveNext
Loop
Formsumlist.Adodc1.RecordSource = "select * from [匯編] " 'group by [匯編依據]
Formsumlist.Adodc1.Refresh
Formsumlist.MSHFlexGrid1.MergeRow(2) = True
Formsumlist.MSHFlexGrid1.ColWidth(1) = 3000
Formsumlist.MSHFlexGrid1.ColWidth(2) = 6000
Formsumlist.MSHFlexGrid1.ColWidth(3) = 0
Me.Hide
Formsumlist.Show
End If
End Sub
Private Sub CommandButton4_Click()
Formsumlist.Adodc2.RecordSource = "select 檔案號 as 案卷號,課題負責人 as 匯編依據 from [檔案]"
Formsumlist.Adodc2.Refresh
If Formsumlist.Adodc2.Recordset.RecordCount = 0 Then
MsgBox "因無相關檔案,還無法成冊", , "注意:"
Else
Formsumlist.Adodc2.Recordset.MoveFirst
Formsumlist.Adodc1.Refresh
If Formsumlist.Adodc1.Recordset.RecordCount = 0 Then
Else
Formsumlist.Adodc1.Recordset.MoveFirst
Do Until Formsumlist.Adodc1.Recordset.EOF
Formsumlist.Adodc1.Recordset.Delete
Formsumlist.Adodc1.Recordset.MoveNext
Loop
End If
Do Until Formsumlist.Adodc2.Recordset.EOF
Formsumlist.Adodc1.Recordset.AddNew
Formsumlist.Adodc1.Recordset![案卷號] = Formsumlist.Adodc2.Recordset![案卷號]
Formsumlist.Adodc1.Recordset![匯編依據] = Formsumlist.Adodc2.Recordset![匯編依據]
Formsumlist.Adodc1.Recordset.Update
Formsumlist.Adodc2.Recordset.MoveNext
Loop
Formsumlist.Adodc1.RecordSource = "select * from [匯編] " 'group by [匯編依據]
Formsumlist.Adodc1.Refresh
Formsumlist.MSHFlexGrid1.MergeRow(2) = True
Formsumlist.MSHFlexGrid1.ColWidth(1) = 3000
Formsumlist.MSHFlexGrid1.ColWidth(2) = 6000
Formsumlist.MSHFlexGrid1.ColWidth(3) = 0
Me.Hide
Formsumlist.Show
End If
End Sub
Private Sub CommandButton5_Click()
Formsumlist.Adodc2.RecordSource = "select 檔案號 as 案卷號,保管期限 as 匯編依據 from [檔案]"
Formsumlist.Adodc2.Refresh
If Formsumlist.Adodc2.Recordset.RecordCount = 0 Then
MsgBox "因無相關檔案,還無法成冊", , "注意:"
Else
Formsumlist.Adodc2.Recordset.MoveFirst
Formsumlist.Adodc1.Refresh
If Formsumlist.Adodc1.Recordset.RecordCount = 0 Then
Else
Formsumlist.Adodc1.Recordset.MoveFirst
Do Until Formsumlist.Adodc1.Recordset.EOF
Formsumlist.Adodc1.Recordset.Delete
Formsumlist.Adodc1.Recordset.MoveNext
Loop
End If
Do Until Formsumlist.Adodc2.Recordset.EOF
Formsumlist.Adodc1.Recordset.AddNew
Formsumlist.Adodc1.Recordset![案卷號] = Formsumlist.Adodc2.Recordset![案卷號]
Formsumlist.Adodc1.Recordset![匯編依據] = Formsumlist.Adodc2.Recordset![匯編依據]
Formsumlist.Adodc1.Recordset.Update
Formsumlist.Adodc2.Recordset.MoveNext
Loop
Formsumlist.Adodc1.RecordSource = "select * from [匯編] " 'group by [匯編依據]
Formsumlist.Adodc1.Refresh
Formsumlist.MSHFlexGrid1.MergeRow(2) = True
Formsumlist.MSHFlexGrid1.ColWidth(1) = 3000
Formsumlist.MSHFlexGrid1.ColWidth(2) = 6000
Formsumlist.MSHFlexGrid1.ColWidth(3) = 0
Me.Hide
Formsumlist.Show
End If
End Sub
Private Sub CommandButton6_Click()
Formsumlist.Adodc2.RecordSource = "select 檔案號 as 案卷號,密級 as 匯編依據 from [檔案]"
Formsumlist.Adodc2.Refresh
If Formsumlist.Adodc2.Recordset.RecordCount = 0 Then
MsgBox "因無相關檔案,還無法成冊", , "注意:"
Else
Formsumlist.Adodc2.Recordset.MoveFirst
Formsumlist.Adodc1.Refresh
If Formsumlist.Adodc1.Recordset.RecordCount = 0 Then
Else
Formsumlist.Adodc1.Recordset.MoveFirst
Do Until Formsumlist.Adodc1.Recordset.EOF
Formsumlist.Adodc1.Recordset.Delete
Formsumlist.Adodc1.Recordset.MoveNext
Loop
End If
Do Until Formsumlist.Adodc2.Recordset.EOF
Formsumlist.Adodc1.Recordset.AddNew
Formsumlist.Adodc1.Recordset![案卷號] = Formsumlist.Adodc2.Recordset![案卷號]
Formsumlist.Adodc1.Recordset![匯編依據] = Formsumlist.Adodc2.Recordset![匯編依據]
Formsumlist.Adodc1.Recordset.Update
Formsumlist.Adodc2.Recordset.MoveNext
Loop
Formsumlist.Adodc1.RecordSource = "select * from [匯編] " 'group by [匯編依據]
Formsumlist.Adodc1.Refresh
Formsumlist.MSHFlexGrid1.MergeRow(2) = True
Formsumlist.MSHFlexGrid1.ColWidth(1) = 3000
Formsumlist.MSHFlexGrid1.ColWidth(2) = 6000
Formsumlist.MSHFlexGrid1.ColWidth(3) = 0
Me.Hide
Formsumlist.Show
End If
End Sub
Private Sub CommandButton7_Click()
Formsumlist.Adodc2.RecordSource = "select 檔案號 as 案卷號,案卷標題的主題詞 as 匯編依據 from [檔案]"
Formsumlist.Adodc2.Refresh
If Formsumlist.Adodc2.Recordset.RecordCount = 0 Then
MsgBox "因無相關檔案,還無法成冊", , "注意:"
Else
Formsumlist.Adodc2.Recordset.MoveFirst
Formsumlist.Adodc1.Refresh
If Formsumlist.Adodc1.Recordset.RecordCount = 0 Then
Else
Formsumlist.Adodc1.Recordset.MoveFirst
Do Until Formsumlist.Adodc1.Recordset.EOF
Formsumlist.Adodc1.Recordset.Delete
Formsumlist.Adodc1.Recordset.MoveNext
Loop
End If
Do Until Formsumlist.Adodc2.Recordset.EOF
Formsumlist.Adodc1.Recordset.AddNew
Formsumlist.Adodc1.Recordset![案卷號] = Formsumlist.Adodc2.Recordset![案卷號]
Formsumlist.Adodc1.Recordset![匯編依據] = Formsumlist.Adodc2.Recordset![匯編依據]
Formsumlist.Adodc1.Recordset.Update
Formsumlist.Adodc2.Recordset.MoveNext
Loop
Formsumlist.Adodc1.RecordSource = "select * from [匯編] " 'group by [匯編依據]
Formsumlist.Adodc1.Refresh
Formsumlist.MSHFlexGrid1.MergeRow(2) = True
Formsumlist.MSHFlexGrid1.ColWidth(1) = 3000
Formsumlist.MSHFlexGrid1.ColWidth(2) = 6000
Formsumlist.MSHFlexGrid1.ColWidth(3) = 0
Me.Hide
Formsumlist.Show
End If
End Sub
Private Sub CommandButton8_Click()
Me.Hide
Formmain.Show
End Sub
Private Sub Form_Unload(Cancel As Integer)
Me.Hide
Formmain.Show
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -