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 + -
显示快捷键?