frmtels.frm

手机短心控制接收发射程序,通过串口与手机连接,

VERSION 5.00
Begin VB.Form frmTelS 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "模糊查询"
   ClientHeight    =   960
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   5325
   Icon            =   "frmTelS.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   960
   ScaleWidth      =   5325
   ShowInTaskbar   =   0   'False
   StartUpPosition =   2  '屏幕中心
   Begin VB.CommandButton Command1 
      Caption         =   "确定(&C)"
      Default         =   -1  'True
      Height          =   495
      Left            =   3960
      TabIndex        =   2
      Top             =   240
      Width           =   1095
   End
   Begin VB.TextBox Text1 
      Height          =   270
      Left            =   1200
      TabIndex        =   1
      Top             =   315
      Width           =   2415
   End
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      Caption         =   "输入姓名"
      Height          =   180
      Left            =   240
      TabIndex        =   0
      Top             =   360
      Width           =   720
   End
End
Attribute VB_Name = "frmTelS"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private Sub Command1_Click()
    Dim intxt As String
    Dim strSearch As String
    Dim txtTmp As String
    If Text1.Text <> "" Then
        txtTmp = Left(Text1.Text, 1)
        If Hex(Asc(txtTmp)) <= Hex(Asc("z")) Then
            strSearch = "select * from phonebook where mem like'" & UCase(Text1.Text) & "*'"
        Else
            strSearch = "select * from phonebook where name like'" & Text1.Text & "*'"
        End If
    frmMain.Data1.RecordSource = strSearch
    frmMain.Data1.Refresh
    Unload Me
    End If
End Sub