MODIFIED SOURCE CODE FOR FIND.FRM
Made on Tuesday, Apr 8, 2003 at 9:43 AM
Option Explicit
'>>>>>>>>>>>>>>>>>>>>>>>>
'ResMe Converted To A Property: Const FORMCAPTION = "Find Record"
'ResMe Converted To A Property: Const BUTTON1 = "&OK"
'ResMe Converted To A Property: Const BUTTON2 = "&Cancel"
'ResMe Converted To A Property: Const Label1 = "&Fields:"
'ResMe Converted To A Property: Const Label2 = "&Operators:"
'ResMe Converted To A Property: Const LABEL3 = "&Value or Expression:"
'>>>>>>>>>>>>>>>>>>>>>>>>
Dim mbNotFound As Integer
Private Sub cmdCancel_Click()
Hide
'set the flag for the recordset/recagrid form
gbFindFailed = True
End Sub
Private Sub optFindType_Click(Index As Integer)
gnFindType = Index
End Sub
Private Sub txtExpression_Change()
cmdOK.Enabled = Len(lstFields.Text) > 0 And Len(lstOperators.Text) > 0 And Len(txtExpression.Text) > 0
End Sub
Private Sub lstFields_Click()
cmdOK.Enabled = Len(lstFields.Text) > 0 And Len(lstOperators.Text) > 0 And Len(txtExpression.Text) > 0
End Sub
Private Sub lstOperators_Click()
cmdOK.Enabled = Len(lstFields.Text) > 0 And Len(lstOperators.Text) > 0 And Len(txtExpression.Text) > 0
End Sub
Private Sub Form_KeyUp(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyF1 And Shift = 0 Then
DisplayTopic 2016128
End If
End Sub
Private Sub Form_Load()
'ResMe autogenerated line of code to call the initialization routine that was automatically generated.
Call frmFindForm_Auto_Init
Me.Caption = FORMCAPTION
cmdOK.Caption = BUTTON1
cmdCancel.Caption = BUTTON2
lblLabels(0).Caption = Label1
lblLabels(1).Caption = Label2
lblLabels(2).Caption = LABEL3
lstOperators.AddItem "="
lstOperators.AddItem "<>"
lstOperators.AddItem ">="
lstOperators.AddItem "<="
lstOperators.AddItem ">"
lstOperators.AddItem "<"
'WAS: lstOperators.AddItem "Like"
lstOperators.AddItem LoadResString(S310_Like)
lstOperators.ListIndex = 0
mbNotFound = False
End Sub
Private Sub cmdOK_Click()
On Error GoTo FindErr
Dim i As Integer
i = lstFields.ListIndex
mbNotFound = False
Screen.MousePointer = vbHourglass
gsFindField = lstFields.Text
gsFindExpr = txtExpression.Text
gsFindOp = lstOperators.Text
Hide
Screen.MousePointer = vbDefault
Exit Sub
FindErr:
If Err <> gnEOF_ERR Then
ShowError
Else
mbNotFound = True
Resume Next
End If
End Sub
'*********************************************************************************
'** This Section Of Code Was Automatically Generated By ResMe **
'** **
'** String assignments to Constants have been converted to read-only properties **
'*********************************************************************************
'This was: Const FORMCAPTION = "Find Record"
Property Get FORMCAPTION As String
'WAS: FORMCAPTION = "Find Record"
FORMCAPTION = LoadResString(S249_Find_Record)
End Property
'This was: Const BUTTON1 = "&OK"
Property Get BUTTON1 As String
BUTTON1 = "&OK"
End Property
'This was: Const BUTTON2 = "&Cancel"
Property Get BUTTON2 As String
'WAS: BUTTON2 = "&Cancel"
BUTTON2 = LoadResString(S84_Cancel)
End Property
'This was: Const Label1 = "&Fields:"
Property Get Label1 As String
'WAS: Label1 = "&Fields:"
Label1 = LoadResString(S242_Fields)
End Property
'This was: Const Label2 = "&Operators:"
Property Get Label2 As String
'WAS: Label2 = "&Operators:"
Label2 = LoadResString(S387_Operators)
End Property
'This was: Const LABEL3 = "&Value or Expression:"
Property Get LABEL3 As String
'WAS: LABEL3 = "&Value or Expression:"
LABEL3 = LoadResString(S572_Value_or_Expression)
End Property
Private Sub frmFindForm_Auto_Init()
'This routine initializes all User Interface control properties on frmFindForm.
'This section of code was automatically generated by the ResMe String Extraction Utility.
'WAS: Me.Caption = "Find"
Me.Caption = LoadResString(S248_Find)
'WAS: optFindType(3).Caption = "FindLast"
optFindType(3).Caption = LoadResString(S251_FindLast)
'WAS: optFindType(2).Caption = "FindPrevious"
optFindType(2).Caption = LoadResString(S253_FindPrevious)
'WAS: optFindType(1).Caption = "FindNext"
optFindType(1).Caption = LoadResString(S252_FindNext)
'WAS: optFindType(0).Caption = "FindFirst"
optFindType(0).Caption = LoadResString(S250_FindFirst)
'WAS: cmdOK.Caption = "&OK"
cmdOK.Caption = LoadResString(S355_OK)
'WAS: cmdCancel.Caption = "&Cancel"
cmdCancel.Caption = LoadResString(S84_Cancel)
'WAS: lblLabels(1).Caption = "Operators: "
lblLabels(1).Caption = LoadResString(S388_Operators)
'WAS: lblLabels(0).Caption = "Fields: "
lblLabels(0).Caption = LoadResString(S243_Fields)
'WAS: lblLabels(2).Caption = "Value or Expression: "
lblLabels(2).Caption = LoadResString(S573_Value_or_Expression)
End Sub