frmsrchmember.frm

该压缩包包含有很多关于数据库原理与应用的课件以及课程设计

VERSION 5.00
Begin VB.Form frmSrchMember 
   Caption         =   "读者信息"
   ClientHeight    =   5790
   ClientLeft      =   120
   ClientTop       =   420
   ClientWidth     =   6510
   LinkTopic       =   "Form2"
   MDIChild        =   -1  'True
   ScaleHeight     =   5790
   ScaleWidth      =   6510
   WindowState     =   2  'Maximized
   Begin VB.TextBox txtAddress 
      Height          =   495
      Left            =   2160
      TabIndex        =   12
      Text            =   "Text1"
      Top             =   4920
      Width           =   2175
   End
   Begin VB.TextBox txtSex 
      Height          =   495
      Left            =   2160
      TabIndex        =   9
      Text            =   "Text1"
      Top             =   4140
      Width           =   2175
   End
   Begin VB.TextBox txtMemName 
      Height          =   495
      Left            =   2160
      TabIndex        =   7
      Text            =   "Text1"
      Top             =   3360
      Width           =   2175
   End
   Begin VB.TextBox txtRollNo 
      Height          =   495
      Left            =   2160
      TabIndex        =   6
      Text            =   "Text1"
      Top             =   2580
      Width           =   2175
   End
   Begin VB.TextBox txtClassId 
      Height          =   495
      Left            =   2160
      TabIndex        =   4
      Text            =   "Text2"
      Top             =   1800
      Width           =   2175
   End
   Begin VB.Frame Frame1 
      Caption         =   "输入图书编号后回车"
      Height          =   975
      Left            =   600
      TabIndex        =   0
      Top             =   480
      Width           =   4455
      Begin VB.TextBox txtLibraryId 
         Height          =   375
         Left            =   1560
         TabIndex        =   2
         Text            =   "Text1"
         Top             =   480
         Width           =   2175
      End
      Begin VB.Label Label1 
         Caption         =   "图书编号"
         BeginProperty Font 
            Name            =   "微软雅黑"
            Size            =   14.25
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   615
         Left            =   0
         TabIndex        =   1
         Top             =   360
         Width           =   1215
      End
   End
   Begin VB.Label Label6 
      Caption         =   "地址"
      BeginProperty Font 
         Name            =   "微软雅黑"
         Size            =   14.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   720
      TabIndex        =   11
      Top             =   4920
      Width           =   1095
   End
   Begin VB.Label Label5 
      Caption         =   "性别"
      BeginProperty Font 
         Name            =   "微软雅黑"
         Size            =   14.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   720
      TabIndex        =   10
      Top             =   4200
      Width           =   1215
   End
   Begin VB.Label Label4 
      Caption         =   "学生姓名"
      BeginProperty Font 
         Name            =   "微软雅黑"
         Size            =   14.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   600
      TabIndex        =   8
      Top             =   3480
      Width           =   1335
   End
   Begin VB.Label Label3 
      Caption         =   "名单编号"
      BeginProperty Font 
         Name            =   "微软雅黑"
         Size            =   14.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   615
      Left            =   600
      TabIndex        =   5
      Top             =   2640
      Width           =   1335
   End
   Begin VB.Label Label2 
      Caption         =   "班级编号"
      BeginProperty Font 
         Name            =   "微软雅黑"
         Size            =   14.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   600
      TabIndex        =   3
      Top             =   1800
      Width           =   1215
   End
End
Attribute VB_Name = "frmSrchMember"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub txtLibraryId_Keypress(KeyAscii As Integer)
Dim LibraryNo As String

LibraryNo = txtLibraryId.Text
If KeyAscii = 13 Then
    clear
    If Not IsNumeric(LibraryNo) Then
        MsgBox "Invalid Search Key Entered", vbCritical, "Search Error"
        Call clear
        Exit Sub
    End If
    
    rsMemberInfo.MoveFirst
    For i = 0 To rsMemberInfo.RecordCount
        If rsMemberInfo.EOF = True Then
        Exit For
    End If
    
    If rsMemberInfo(0) = Val(Trim$(LibraryNo)) Then
        txtClassId.Text = Str(rsMemberInfo(1))
        txtRollNo.Text = Str(rsMemberInfo(2))
        txtMemName.Text = rsMemberInfo(3)
        txtSex.Text = rsMemberInfo(4)
        txtAddress.Text = rsMemberInfo(5)
        Exit For
    End If
    rsMemberInfo.MoveNext
Next
If txtClassId.Text = "" Then
    MsgBox "Invalid library ID", vbInformation, "Search Not Found"
    'cmdSave.enabled=false
    clear
End If
End If
End Sub