frmfind.frm

VB城市排水系统

VERSION 5.00
Begin VB.Form frmfind 
   Caption         =   "Form1"
   ClientHeight    =   3000
   ClientLeft      =   4845
   ClientTop       =   4020
   ClientWidth     =   3630
   LinkTopic       =   "Form1"
   ScaleHeight     =   3000
   ScaleWidth      =   3630
   Begin VB.Frame Frame1 
      Caption         =   "查找信息"
      Height          =   1275
      Left            =   225
      TabIndex        =   3
      Top             =   810
      Width           =   3210
      Begin VB.TextBox Text1 
         Height          =   285
         Left            =   1260
         TabIndex        =   5
         Top             =   315
         Width           =   1725
      End
      Begin VB.TextBox Text2 
         Height          =   285
         Left            =   1260
         TabIndex        =   4
         Top             =   810
         Width           =   1725
      End
      Begin VB.Label Label1 
         Caption         =   "公司编号"
         Height          =   285
         Left            =   315
         TabIndex        =   7
         Top             =   315
         Width           =   1050
      End
      Begin VB.Label Label2 
         Caption         =   "公司名称"
         Height          =   330
         Left            =   270
         TabIndex        =   6
         Top             =   855
         Width           =   1050
      End
   End
   Begin VB.CommandButton Command2 
      Caption         =   "取消"
      Height          =   375
      Left            =   2565
      TabIndex        =   2
      Top             =   2385
      Width           =   870
   End
   Begin VB.CommandButton Command1 
      Caption         =   "查找"
      Height          =   375
      Left            =   1620
      TabIndex        =   0
      Top             =   2385
      Width           =   915
   End
   Begin VB.Label Label3 
      Caption         =   "请输入公司的编号或公司名称"
      Height          =   375
      Left            =   225
      TabIndex        =   1
      Top             =   270
      Width           =   3210
   End
End
Attribute VB_Name = "frmfind"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
'查找符合要求的记录
If Text1.Text <> "" Or Text2.Text <> "" Then
    adoPrimaryRS.MoveFirst
    Do Until adoPrimaryRS.EOF
        If adoPrimaryRS!编号ID = Text1.Text Or adoPrimaryRS!企业名称 = Text2.Text Then
            Exit Do
        End If
    adoPrimaryRS.MoveNext
    Loop
    If adoPrimaryRS.EOF Then
    MsgBox "没有找到相应的记录", vbQuestion
    End If
Else
    MsgBox "请输入相应的查找信息"
End If
End Sub

Private Sub Command2_Click()
Unload Me
End Sub