⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 form_tong.frm

📁 运用VB和SQL Server实现
💻 FRM
📖 第 1 页 / 共 3 页
字号:
      Begin MSAdodcLib.Adodc Adodc_Tong 
         Height          =   375
         Left            =   -69480
         Top             =   3600
         Visible         =   0   'False
         Width           =   1200
         _ExtentX        =   2117
         _ExtentY        =   661
         ConnectMode     =   0
         CursorLocation  =   3
         IsolationLevel  =   -1
         ConnectionTimeout=   15
         CommandTimeout  =   30
         CursorType      =   3
         LockType        =   3
         CommandType     =   8
         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         =   "Adodc1"
         BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
            Name            =   "MS Sans Serif"
            Size            =   8.25
            Charset         =   0
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         _Version        =   393216
      End
      Begin MSDataGridLib.DataGrid DataGrid_Tong 
         Bindings        =   "Form_Tong.frx":0052
         Height          =   2055
         Left            =   -74760
         TabIndex        =   2
         Top             =   2880
         Width           =   7695
         _ExtentX        =   13573
         _ExtentY        =   3625
         _Version        =   393216
         HeadLines       =   1
         RowHeight       =   15
         BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
            Name            =   "MS Sans Serif"
            Size            =   8.25
            Charset         =   0
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
            Name            =   "MS Sans Serif"
            Size            =   8.25
            Charset         =   0
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ColumnCount     =   2
         BeginProperty Column00 
            DataField       =   ""
            Caption         =   ""
            BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
               Type            =   0
               Format          =   ""
               HaveTrueFalseNull=   0
               FirstDayOfWeek  =   0
               FirstWeekOfYear =   0
               LCID            =   2052
               SubFormatType   =   0
            EndProperty
         EndProperty
         BeginProperty Column01 
            DataField       =   ""
            Caption         =   ""
            BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
               Type            =   0
               Format          =   ""
               HaveTrueFalseNull=   0
               FirstDayOfWeek  =   0
               FirstWeekOfYear =   0
               LCID            =   2052
               SubFormatType   =   0
            EndProperty
         EndProperty
         SplitCount      =   1
         BeginProperty Split0 
            BeginProperty Column00 
            EndProperty
            BeginProperty Column01 
            EndProperty
         EndProperty
      End
      Begin VB.Frame Frame1 
         Height          =   2295
         Left            =   -74760
         TabIndex        =   1
         Top             =   480
         Width           =   7695
         Begin MSComCtl2.DTPicker DTPicker2 
            Height          =   375
            Left            =   3960
            TabIndex        =   33
            Top             =   480
            Width           =   1335
            _ExtentX        =   2355
            _ExtentY        =   661
            _Version        =   393216
            Format          =   66977793
            CurrentDate     =   39232
         End
         Begin MSComCtl2.DTPicker DTPicker1 
            Height          =   375
            Left            =   2160
            TabIndex        =   32
            Top             =   480
            Width           =   1335
            _ExtentX        =   2355
            _ExtentY        =   661
            _Version        =   393216
            Format          =   66977793
            CurrentDate     =   39232
         End
         Begin VB.TextBox Text3 
            Height          =   495
            Left            =   5760
            TabIndex        =   11
            Top             =   840
            Width           =   1455
         End
         Begin VB.CommandButton Command1 
            Caption         =   "统计"
            Height          =   495
            Left            =   6000
            TabIndex        =   9
            Top             =   1560
            Width           =   1215
         End
         Begin VB.TextBox Text2 
            Height          =   375
            Left            =   3960
            TabIndex        =   8
            Top             =   1440
            Width           =   1215
         End
         Begin VB.TextBox Text1 
            Height          =   375
            Left            =   2160
            TabIndex        =   7
            Top             =   1440
            Width           =   1215
         End
         Begin VB.ComboBox Combo1 
            Height          =   315
            Left            =   2160
            TabIndex        =   6
            Top             =   960
            Width           =   1215
         End
         Begin VB.CheckBox Check3 
            Caption         =   "借出金额:"
            Height          =   255
            Left            =   240
            TabIndex        =   5
            Top             =   1560
            Width           =   1335
         End
         Begin VB.CheckBox Check2 
            Caption         =   "借出人:"
            Height          =   255
            Left            =   240
            TabIndex        =   4
            Top             =   1020
            Width           =   1095
         End
         Begin VB.CheckBox Check1 
            Caption         =   "按借出日期:"
            Height          =   255
            Left            =   240
            TabIndex        =   3
            Top             =   480
            Width           =   1575
         End
         Begin VB.Label Label10 
            Caption         =   "从"
            Height          =   255
            Left            =   1800
            TabIndex        =   31
            Top             =   1560
            Width           =   255
         End
         Begin VB.Label Label9 
            Caption         =   "到"
            Height          =   255
            Left            =   3600
            TabIndex        =   30
            Top             =   1560
            Width           =   375
         End
         Begin VB.Label Label8 
            Caption         =   "到"
            Height          =   255
            Left            =   3600
            TabIndex        =   29
            Top             =   600
            Width           =   375
         End
         Begin VB.Label Label7 
            Caption         =   "从"
            Height          =   255
            Left            =   1800
            TabIndex        =   28
            Top             =   600
            Width           =   375
         End
         Begin VB.Label Label1 
            Caption         =   "总金额为:"
            Height          =   375
            Left            =   5760
            TabIndex        =   10
            Top             =   480
            Width           =   975
         End
      End
   End
End
Attribute VB_Name = "Form_Tong"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Check1_Click()
If Me.Check1.Value = 1 Then
    Me.Check2.Value = 0
    Me.Check3.Value = 0
End If
Me.Combo1 = ""
Me.Text1 = ""
Me.Text2 = ""
Me.Text3 = ""
End Sub

Private Sub Check2_Click()
If Me.Check2.Value = 1 Then
    Me.Check1.Value = 0
    Me.Check3.Value = 0
End If
Me.Combo1 = ""
Me.Text1 = ""
Me.Text2 = ""
Me.Text3 = ""
End Sub

Private Sub Check3_Click()
If Me.Check3.Value = 1 Then
    Me.Check2.Value = 0
    Me.Check1.Value = 0
End If
Me.Combo1 = ""
Me.Text1 = ""
Me.Text2 = ""
Me.Text3 = ""
End Sub

Private Sub Check4_Click()
If Me.Check4.Value = 1 Then
    Me.Check5.Value = 0
    Me.Check6.Value = 0
End If
Me.Combo2 = ""
Me.Text4 = ""
Me.Text5 = ""
Me.Text6 = ""
End Sub

Private Sub Check5_Click()

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -