📄 formdment1.frm
字号:
VERSION 5.00
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "MSADODC.OCX"
Object = "{C3CBD80D-C8D1-11D2-9F8E-0080C7CE5CDC}#4.1#0"; "ACTCNDY2.OCX"
Object = "{F0D2F211-CCB0-11D0-A316-00AA00688B10}#1.0#0"; "MSDATLST.OCX"
Begin VB.Form Formdment1
BorderStyle = 1 'Fixed Single
Caption = "记录查找"
ClientHeight = 930
ClientLeft = 45
ClientTop = 330
ClientWidth = 7290
ControlBox = 0 'False
LinkTopic = "Form2"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 930
ScaleWidth = 7290
StartUpPosition = 2 '屏幕中心
Begin MSDataListLib.DataCombo DataCombo2
Bindings = "Formdment1.frx":0000
Height = 330
Left = 2280
TabIndex = 9
Top = 120
Width = 1455
_ExtentX = 2566
_ExtentY = 582
_Version = 393216
ListField = "功能"
Text = ""
End
Begin ActiveCandy.CandySphere command2
Cancel = -1 'True
Default = -1 'True
Height = 480
Left = 6720
TabIndex = 0
Top = 0
Width = 480
_ExtentX = 847
_ExtentY = 847
ContentType = 2
ContentLetter = "取消"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = 255
UseAnimation = 0 'False
UseSound = -1 'True
End
Begin MSDataListLib.DataCombo DataCombo1
Bindings = "Formdment1.frx":0015
Height = 330
Left = 600
TabIndex = 1
Top = 100
Width = 975
_ExtentX = 1720
_ExtentY = 582
_Version = 393216
ListField = "操作员"
Text = ""
Object.DataMember = ""
End
Begin ActiveCandy.CandySphere command1
Height = 480
Left = 6120
TabIndex = 2
Top = 0
Width = 480
_ExtentX = 847
_ExtentY = 847
SphereType = 3
ContentType = 2
ContentIcon = "Formdment1.frx":002A
ContentLetter = "确定"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = 255
PictureDisabled = "Formdment1.frx":047C
FocusColor = 0
UseOnTop = 0 'False
UseSound = -1 'True
End
Begin MSComCtl2.DTPicker DTPicker1
Bindings = "Formdment1.frx":08CE
BeginProperty DataFormat
Type = 1
Format = "yyyy-M-d"
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 3
EndProperty
DataSource = "hzzde"
Height = 300
Left = 4800
TabIndex = 3
Top = 120
Width = 1215
_ExtentX = 2143
_ExtentY = 529
_Version = 393216
CalendarTitleBackColor= 16711680
CalendarTitleForeColor= 255
Format = 24576003
CurrentDate = 36734
MaxDate = 36891
MinDate = 36708
End
Begin MSAdodcLib.Adodc Adodc1
Height = 330
Left = 360
Top = 120
Visible = 0 'False
Width = 1200
_ExtentX = 2117
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 2
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 2
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = "FILE NAME=C:\My Documents\花寨子早.UDL"
OLEDBString = ""
OLEDBFile = "C:\My Documents\花寨子早.UDL"
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = "操作员库"
Caption = "Adodc1"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin MSAdodcLib.Adodc Adodc2
Height = 375
Left = 2160
Top = 120
Visible = 0 'False
Width = 1575
_ExtentX = 2778
_ExtentY = 661
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 2
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 2
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = "FILE NAME=C:\My Documents\花寨子早.UDL"
OLEDBString = ""
OLEDBFile = "C:\My Documents\花寨子早.UDL"
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = "功能库"
Caption = "Adodc2"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin VB.Line Line1
X1 = 0
X2 = 7320
Y1 = 480
Y2 = 480
End
Begin VB.Label Label1
Caption = "姓名："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 0
TabIndex = 8
Top = 160
Width = 615
End
Begin VB.Label Label2
Caption = "项目："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 1680
TabIndex = 7
Top = 165
Width = 615
End
Begin VB.Label Label3
Caption = "进入日期："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 3840
TabIndex = 6
Top = 165
Width = 1095
End
Begin VB.Label Label4
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 1320
TabIndex = 5
Top = 600
Width = 5895
End
Begin VB.Label Label5
Caption = "查询条件为："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 0
TabIndex = 4
Top = 600
Width = 1215
End
End
Attribute VB_Name = "Formdment1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim cay, xm, jrqq As String
Dim lcay, lxm, ljrqq As String
Private Sub command1_Click() '确定
filterstring = Trim(Mid(filterstring, 5))
'Debug.Print filterstring
Unload Me
End Sub
Private Sub Command2_Click() '取消
Unload Me
filterstring = ""
lstring = ""
End Sub
Private Sub DataCombo1_Change()
command1.Enabled = True
End Sub
Private Sub DataCombo1_LostFocus()
'操作员
If DataCombo1.Text <> "" Then
lcay = "操作员为" & DataCombo1.Text
cay = "操作员='" & DataCombo1.Text & "'"
lstring = lstring + lcay + " "
filterstring = filterstring + "and " + cay
Label4.Caption = lstring
End If
End Sub
Private Sub DataCombo2_Change()
command1.Enabled = True
End Sub
Private Sub DataCombo2_LostFocus()
'项目
If DataCombo2.Text <> "" Then
lxm = "项目为" & DataCombo2.Text
xm = "项目='" & DataCombo2.Text & "'"
lstring = lstring + lxm + " "
filterstring = filterstring + "and " + xm
Label4.Caption = lstring
End If
End Sub
Private Sub DTPicker1_Change()
command1.Enabled = True
End Sub
Private Sub DTPicker1_LostFocus()
'当前时间
ljrqq = "进入时间为 " & DTPicker1.Value
jrqq = "查询时间=#" & DTPicker1.Value & "#"
lstring = lstring + ljrqq + " "
filterstring = filterstring + "and " + jrqq
Label4.Caption = lstring
End Sub
Private Sub Form_Load()
filterstring = ""
lstring = ""
command1.Enabled = False
DTPicker1.Value = Date
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -