?? form2.frm
字號:
VERSION 5.00
Begin VB.Form Form2
BorderStyle = 3 'Fixed Dialog
Caption = "查詢條件構成器"
ClientHeight = 2295
ClientLeft = 45
ClientTop = 330
ClientWidth = 6525
LinkTopic = "Form2"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 2295
ScaleWidth = 6525
ShowInTaskbar = 0 'False
StartUpPosition = 2 '屏幕中心
Begin VB.CommandButton Command1
Caption = "取消"
Height = 375
Left = 3720
TabIndex = 9
Top = 1800
Width = 1215
End
Begin VB.Frame Frame1
Caption = "查詢條件表達式："
Height = 615
Left = 240
TabIndex = 7
Top = 960
Width = 6135
Begin VB.Label Labvalue
BeginProperty Font
Name = "宋體"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 4080
TabIndex = 11
Top = 240
Width = 1935
End
Begin VB.Label Laboperate
BeginProperty Font
Name = "宋體"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 2040
TabIndex = 10
Top = 240
Width = 1815
End
Begin VB.Label Labfield
BeginProperty Font
Name = "宋體"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 240
TabIndex = 8
Top = 240
Width = 1575
End
End
Begin VB.CommandButton CmdOk
Caption = "確定(&O)"
Height = 375
Left = 2160
TabIndex = 6
Top = 1800
Width = 1215
End
Begin VB.ComboBox Combo3
Height = 300
Left = 4560
TabIndex = 4
Top = 480
Width = 1815
End
Begin VB.ComboBox Combo2
Height = 300
Left = 2520
Style = 2 'Dropdown List
TabIndex = 3
Top = 480
Width = 1695
End
Begin VB.ComboBox Combo1
Height = 300
Left = 240
Style = 2 'Dropdown List
TabIndex = 2
Top = 480
Width = 1575
End
Begin VB.Label Label3
Caption = "查詢值："
BeginProperty Font
Name = "宋體"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 4560
TabIndex = 5
Top = 120
Width = 840
End
Begin VB.Label Label2
AutoSize = -1 'True
Caption = "選擇關系運算符："
BeginProperty Font
Name = "宋體"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 2520
TabIndex = 1
Top = 120
Width = 1680
End
Begin VB.Label Label1
Caption = "選擇查詢字段："
BeginProperty Font
Name = "宋體"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 240
TabIndex = 0
Top = 120
Width = 1530
End
End
Attribute VB_Name = "Form2"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private Sub CmdOk_Click()
Dim Fieldname, operate, value As String
Select Case Combo2.ListIndex
Case 0
operate = "="
Case 1
operate = ">="
Case 2
operate = ">"
Case 3
operate = "<"
Case 4
operate = "<="
Case 5
operate = "<>"
End Select
Fieldname = Combo1.Text
value = Combo3.Text
Select Case Combo1.ListIndex
Case 0, 1, 2, 7
FindString = Fieldname & operate & "'" & value & "'"
Case 3, 4, 6
FindString = Fieldname & operate & value
Case 5
FindString = Fieldname & operate & "#" & value & "#"
End Select
Unload Form2
End Sub
Private Sub Combo1_Click()
Labfield.Caption = Combo1.Text
End Sub
Private Sub Combo2_Click()
Dim Temp As String
Select Case Combo2.ListIndex
Case 0
Temp = "="
Case 1
Temp = ">="
Case 2
Temp = ">"
Case 3
Temp = "<"
Case 4
Temp = "<="
Case 5
Temp = "<>"
End Select
Laboperate.Caption = Temp
End Sub
Private Sub Combo3_Change()
Labvalue.Caption = Combo3.Text
End Sub
Private Sub Combo3_Click()
Labvalue.Caption = Combo3.Text
End Sub
Private Sub Combo3_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Labvalue.Caption = Combo3.Text
End If
End Sub
Private Sub Command1_Click()
cancelFlag = True
Unload Me
End Sub
Private Sub Form_Load()
Dim num As Integer
For num = 0 To Form1.Data1.Recordset.Fields.Count - 1
Combo1.AddItem Form1.Data1.Recordset.Fields(num).Name
Next num
'---
Combo2.AddItem "等于（=）"
Combo2.AddItem "大于或等于（>=）"
Combo2.AddItem "大于（>）"
Combo2.AddItem "小于（<）"
Combo2.AddItem "小于或等（<=）"
Combo2.AddItem "不等于（<>）"
'--
Combo1.ListIndex = 1
Combo2.ListIndex = 0
'--
Combo3.AddItem "H001"
Combo3.AddItem "H002"
Combo3.AddItem "H003"
Combo3.AddItem "H004"
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -