📄 安装查询.frm
字号:
VERSION 5.00
Object = "{FAEEE763-117E-101B-8933-08002B2F4F5A}#1.1#0"; "DBLIST32.OCX"
Begin VB.Form 安装查询
Caption = "查询窗口"
ClientHeight = 6120
ClientLeft = 60
ClientTop = 510
ClientWidth = 5445
LinkTopic = "Form1"
ScaleHeight = 6120
ScaleWidth = 5445
StartUpPosition = 3 '窗口缺省
Begin VB.CommandButton CancelCommand2
Caption = "撤销"
Height = 615
Left = 3000
TabIndex = 14
Top = 4920
Width = 1575
End
Begin VB.CommandButton OkCommand
Caption = "确定"
Height = 615
Left = 840
Style = 1 'Graphical
TabIndex = 13
Top = 4920
Width = 1575
End
Begin VB.OptionButton Option2
Height = 375
Left = 3120
TabIndex = 12
Top = 4440
Value = -1 'True
Width = 255
End
Begin VB.OptionButton Option1
Height = 255
Left = 2160
TabIndex = 11
Top = 4560
Width = 375
End
Begin VB.CheckBox Check1
Height = 255
Left = 480
TabIndex = 10
Top = 4560
Width = 255
End
Begin VB.TextBox Text4
Height = 375
Left = 3720
TabIndex = 9
Top = 3720
Width = 1215
End
Begin VB.TextBox Text3
Height = 375
Left = 3720
TabIndex = 8
Top = 3240
Width = 1215
End
Begin VB.ComboBox Combo2
Height = 300
Left = 1800
TabIndex = 7
Top = 3840
Width = 1575
End
Begin VB.ComboBox Combo1
Height = 300
Left = 1800
TabIndex = 6
Top = 3258
Width = 1575
End
Begin VB.TextBox Text2
Height = 375
Left = 3960
TabIndex = 5
Top = 840
Width = 1215
End
Begin VB.TextBox Text1
Height = 300
Left = 1800
TabIndex = 4
Top = 840
Width = 1575
End
Begin MSDBCtls.DBCombo DBCombo3
Bindings = "安装查询.frx":0000
Height = 330
Left = 1800
TabIndex = 3
Top = 2646
Width = 1575
_ExtentX = 2778
_ExtentY = 582
_Version = 393216
ListField = "姓名"
Text = ""
End
Begin MSDBCtls.DBCombo DBCombo2
Bindings = "安装查询.frx":0014
Height = 330
Left = 1800
TabIndex = 2
Top = 2034
Width = 1575
_ExtentX = 2778
_ExtentY = 582
_Version = 393216
ListField = "规格型号"
Text = ""
End
Begin MSDBCtls.DBCombo DBCombo1
Bindings = "安装查询.frx":0028
Height = 330
Left = 1800
TabIndex = 1
Top = 1422
Width = 1575
_ExtentX = 2778
_ExtentY = 582
_Version = 393216
ListField = "空调名称"
Text = ""
End
Begin VB.Data Data4
Caption = "Data4"
Connect = "Access 2000;"
DatabaseName = "C:\大地科贸\大地数据库.mdb"
DefaultCursorType= 0 '缺省游标
DefaultType = 2 '使用 ODBC
Exclusive = 0 'False
Height = 495
Left = 3240
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "安装记录表"
Top = 0
Visible = 0 'False
Width = 1335
End
Begin VB.Data Data3
Caption = "Data3"
Connect = "Access 2000;"
DatabaseName = "C:\大地科贸\大地数据库.mdb"
DefaultCursorType= 0 '缺省游标
DefaultType = 2 '使用 ODBC
Exclusive = 0 'False
Height = 375
Left = 2160
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "人员信息表"
Top = 0
Visible = 0 'False
Width = 1455
End
Begin VB.Data Data2
Caption = "Data2"
Connect = "Access 2000;"
DatabaseName = "C:\大地科贸\大地数据库.mdb"
DefaultCursorType= 0 '缺省游标
DefaultType = 2 '使用 ODBC
Exclusive = 0 'False
Height = 375
Left = 1440
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "空调名称及型号表"
Top = 0
Visible = 0 'False
Width = 1455
End
Begin VB.Data Data1
Caption = "Data1"
Connect = "Access 2000;"
DatabaseName = "C:\大地科贸\大地数据库.mdb"
DefaultCursorType= 0 '缺省游标
DefaultType = 2 '使用 ODBC
Exclusive = 0 'False
Height = 375
Left = 240
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "select 空调名称 from 空调名称及型号表 group by 空调名称"
Top = 0
Visible = 0 'False
Width = 1140
End
Begin VB.Label Label10
BackStyle = 0 'Transparent
Caption = "否"
Height = 255
Left = 2760
TabIndex = 23
Top = 4560
Width = 375
End
Begin VB.Label Label9
BackStyle = 0 'Transparent
Caption = "是"
Height = 255
Left = 1800
TabIndex = 22
Top = 4560
Width = 255
End
Begin VB.Label Label8
BackStyle = 0 'Transparent
Caption = "是否结算"
Height = 255
Left = 840
TabIndex = 21
Top = 4560
Width = 735
End
Begin VB.Label Label7
BackStyle = 0 'Transparent
Caption = "其它项目2"
Height = 195
Left = 600
TabIndex = 20
Top = 3960
Width = 975
End
Begin VB.Label Label6
BackStyle = 0 'Transparent
Caption = "其它项目1"
Height = 255
Left = 600
TabIndex = 19
Top = 3480
Width = 975
End
Begin VB.Label Label5
BackStyle = 0 'Transparent
Caption = "安装人"
Height = 255
Left = 600
TabIndex = 18
Top = 2820
Width = 735
End
Begin VB.Label Label4
BackStyle = 0 'Transparent
Caption = "规格型号"
Height = 255
Left = 600
TabIndex = 17
Top = 2160
Width = 735
End
Begin VB.Label Label3
BackStyle = 0 'Transparent
Caption = "设备名称"
Height = 255
Left = 600
TabIndex = 16
Top = 1500
Width = 735
End
Begin VB.Label Label2
BackStyle = 0 'Transparent
Caption = "至"
Height = 255
Left = 3480
TabIndex = 15
Top = 840
Width = 375
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "安装日期"
Height = 255
Left = 600
TabIndex = 0
Top = 840
Width = 735
End
End
Attribute VB_Name = "安装查询"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub DBCombo1_Click(Area As Integer)
Data2.RecordSource = "select * from 空调名称及型号表 where 空调名称=' " & DBCombo1.Text & "' "
Data2.Refresh
End Sub
Private Sub Form_Activate()
For i = 3 To 23
Combo1.AddItem Data4.Recordset.Fields(i).Name
Combo2.AddItem Data4.Recordset.Fields(i).Name
Next i
End Sub
Private Sub OKCommand_Click()
SelectSql = ""
If DBCombo1.Text <> "" Then SelectSql = SelectSql & " and 空调名称 ='" & DBCombo1.Text & "' "
If DBCombo2.Text <> "" Then SelectSql = SelectSql & " and 规格型号 ='" & DBCombo2.Text & "' "
If DBCombo3.Text <> "" Then SelectSql = SelectSql & " and 主安装人 ='" & DBCombo3.Text & "' "
If Text1.Text <> "" Then SelectSql = SelectSql & " and 安装日期 >= #" & Text1.Text & "# "
If Text2.Text <> "" Then SelectSql = SelectSql & " and 安装日期 <= #" & Text2.Text & "# "
If Text3.Text <> "" Then SelectSql = SelectSql & " and " & Combo1.Text & " = '" & Text3.Text & "' "
If Text4.Text <> "" Then SelectSql = SelectSql & " and " & Combo1.Text & " = '" & Text4.Text & "' "
If Check1.Value = 1 Then
If Option1.Value = True Then
SelectSql = SelectSql & " and 是否结算 "
Else
SelectSql = SelectSql & " and not 是否结算 "
End If
End If
If SelectSql <> "" Then
安装信息.Data1.RecordSource = " select * from 安装记录表 where 空调名称 <>'' " & SelectSql
安装信息.Data1.Refresh
安装信息.SelectCommand.BackColor = &HFF&
End If
Unload Me
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -