ndbb.frm
来自「这是一个医院管理系统中的院长查询模块」· FRM 代码 · 共 437 行 · 第 1/2 页
FRM
437 行
VERSION 5.00
Object = "{00028C01-0000-0000-0000-000000000046}#1.0#0"; "DBGRID32.OCX"
Begin VB.Form NDBB
Caption = "医院管理综合质量统计表"
ClientHeight = 3930
ClientLeft = 1875
ClientTop = 3255
ClientWidth = 6420
ControlBox = 0 'False
BeginProperty Font
Name = "隶书"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Icon = "NDBB.frx":0000
LinkTopic = "Form8"
Moveable = 0 'False
ScaleHeight = 3930
ScaleWidth = 6420
Begin VB.CommandButton Command1
Cancel = -1 'True
Caption = "返 回&Q"
BeginProperty Font
Name = "隶书"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 9990
TabIndex = 4
Top = 330
Width = 1650
End
Begin VB.CommandButton Command2
Caption = "查 询&C"
BeginProperty Font
Name = "隶书"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 6630
TabIndex = 3
Top = 330
Width = 1650
End
Begin VB.CommandButton Command3
Caption = "打印预览"
BeginProperty Font
Name = "隶书"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 8310
TabIndex = 2
Top = 330
Width = 1650
End
Begin VB.Data Data1
BackColor = &H00C0E0FF&
Connect = "Access"
DatabaseName = ""
DefaultCursorType= 1 'ODBCCursor
DefaultType = 1 'UseODBC
Exclusive = 0 'False
BeginProperty Font
Name = "System"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00C00000&
Height = 345
Left = 90
Options = 0
ReadOnly = 0 'False
RecordsetType = 2 'Snapshot
RecordSource = ""
Top = 8040
Width = 11685
End
Begin VB.Frame Frame1
ForeColor = &H00FF0000&
Height = 780
Left = 30
TabIndex = 1
Top = 45
Width = 11805
Begin VB.TextBox Text2
BackColor = &H00C0C0FF&
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 4200
MaxLength = 8
TabIndex = 7
Top = 300
Width = 1155
End
Begin VB.TextBox TEXT1
BackColor = &H00C0C0FF&
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 1980
MaxLength = 8
TabIndex = 5
Top = 300
Width = 1155
End
Begin VB.Label Label1
Caption = "季度:"
BeginProperty Font
Name = "隶书"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 330
Index = 1
Left = 3390
TabIndex = 8
Top = 330
Width = 855
End
Begin VB.Label Label1
Caption = "查询年份:"
BeginProperty Font
Name = "隶书"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 330
Index = 0
Left = 510
TabIndex = 6
Top = 330
Width = 1605
End
End
Begin MSDBGrid.DBGrid DBGrid1
Bindings = "NDBB.frx":030A
Height = 7155
Left = 30
OleObjectBlob = "NDBB.frx":031A
TabIndex = 0
TabStop = 0 'False
Top = 870
Width = 11805
End
End
Attribute VB_Name = "NDBB"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Sub PRINT_1() '
Dim dd As Excel.Application
Set dd = CreateObject("Excel.Application")
dd.Workbooks.Open ("C:\PP\SB\医院各项医疗指标完成情况表.xls")
dd.Range("A1").Select: dd.ActiveCell.FormulaR1C1 = TEXT1 + " 年 第 " + Text2 + " 季度 医院各项医疗指标完成情况表"
dd.Visible = True
dd.Range("G6").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S1)
dd.Range("G14").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S2)
dd.Range("G15").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S3)
dd.Range("G16").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S3)
dd.Range("G17").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S4)
dd.Range("G18").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S5)
dd.Range("G19").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S6)
dd.Range("G23").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S7)
dd.Range("G24").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S8)
dd.Range("G25").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S9)
dd.Range("G26").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S10)
dd.Range("G28").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S11)
dd.Range("N8").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S12)
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?