【VB开源代码栏目提醒】：本文主要为网学会员提供repair_query.frm，希望对需要repair_query.frm网友有所帮助，学习一下!

    VERSION 5.00
    Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "MSADODC.OCX"
    Object = "{CDE57A40-8B86-11D0-B3C6-00A0C90AEA82}#1.0#0"; "MSDATGRD.OCX"
    Begin VB.Form repair_query 
       Caption         =   "查询记录单"
       ClientHeight    =   5850
       ClientLeft      =   60
       ClientTop       =   345
       ClientWidth     =   8295
       LinkTopic       =   "Form1"
       ScaleHeight     =   5850
       ScaleWidth      =   8295
       StartUpPosition =   3  '窗口缺省
       Begin VB.TextBox Text1 
          Height          =   375
          Left            =   2160
          TabIndex        =   2
          Top             =   240
          Width           =   1695
       End
       Begin VB.CommandButton Command1 
          Caption         =   "确认"
          Height          =   375
          Left            =   4200
          TabIndex        =   1
          Top             =   240
          Width           =   855
       End
       Begin MSAdodcLib.Adodc Adodc1 
          Height          =   375
          Left            =   6240
          Top             =   1200
          Visible         =   0   'False
          Width           =   1200
          _ExtentX        =   2117
          _ExtentY        =   661
          ConnectMode     =   0
          CursorLocation  =   3
          IsolationLevel  =   -1
          ConnectionTimeout=   15
          CommandTimeout  =   30
          CursorType      =   3
          LockType        =   3
          CommandType     =   8
          CursorOptions   =   0
          CacheSize       =   50
          MaxRecords      =   0
          BOFAction       =   0
          EOFAction       =   0
          ConnectStringType=   1
          Appearance      =   1
          BackColor       =   -2147483643
          ForeColor       =   -2147483640
          Orientation     =   0
          Enabled         =   -1
          Connect         =   $"repair_query.frx":0000
          OLEDBString     =   $"repair_query.frx":0092
          OLEDBFile       =   ""
          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 MSDataGridLib.DataGrid DataGrid1 
          Height          =   4695
          Left            =   120
          TabIndex        =   0
          Top             =   960
          Width           =   8055
          _ExtentX        =   14208
          _ExtentY        =   8281
          _Version        =   393216
          HeadLines       =   1
          RowHeight       =   15
          BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
             Name            =   "宋体"
             Size            =   9
             Charset         =   134
             Weight          =   400
             Underline       =   0   'False
             Italic          =   0   'False
             Strikethrough   =   0   'False
          EndProperty
          BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
             Name            =   "宋体"
             Size            =   9
             Charset         =   134
             Weight          =   400
             Underline       =   0   'False
             Italic          =   0   'False
             Strikethrough   =   0   'False
          EndProperty
          ColumnCount     =   2
          BeginProperty Column00 
             DataField       =   ""
             Caption         =   ""
             BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
                Type            =   0
                Format          =   ""
                HaveTrueFalseNull=   0
                FirstDayOfWeek  =   0
                FirstWeekOfYear =   0
                LCID            =   2052
                SubFormatType   =   0
             EndProperty
          EndProperty
          BeginProperty Column01 
             DataField       =   ""
             Caption         =   ""
             BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
                Type            =   0
                Format          =   ""
                HaveTrueFalseNull=   0
                FirstDayOfWeek  =   0
                FirstWeekOfYear =   0
                LCID            =   2052
                SubFormatType   =   0
             EndProperty
          EndProperty
          SplitCount      =   1
          BeginProperty Split0 
             BeginProperty Column00 
             EndProperty
             BeginProperty Column01 
             EndProperty
          EndProperty
       End
       Begin VB.Label Label3 
          Caption         =   "标志为1为维修完成"
          ForeColor       =   &H000000FF&
          Height          =   255
          Left            =   5760
          TabIndex        =   5
          Top             =   600
          Width           =   2055
       End
       Begin VB.Label Label2 
          Caption         =   "标志为0为等待维修"
          ForeColor       =   &H000000FF&
          Height          =   255
          Left            =   5760
          TabIndex        =   4
          Top             =   240
          Width           =   2055
       End
       Begin VB.Label Label1 
          Caption         =   "编号："
          Height          =   375
          Left            =   1320
          TabIndex        =   3
          Top             =   360
          Width           =   735
       End
    End
    Attribute VB_Name = "repair_query"
    Attribute VB_GlobalNameSpace = False
    Attribute VB_Creatable = False
    Attribute VB_PredeclaredId = True
    Attribute VB_Exposed = False
    Private Sub Command1_Click()
    Set cn = New ADODB.Connection
    Set rs = New ADODB.Recordset
    If Text1.Text = "" Then
     MsgBox "请输入设备编号"
    Else
      cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & App.Path & "\file.mdb;Persist Security Info=False"
      sql = "select * from repair where dno='" & Text1.Text & "'"
      rs.Open sql, cn, 1, 1
      If rs.EOF = True Then
       MsgBox "没有找到该设备编号"
      Else
    Adodc1.CommandType = adCmdText
    Adodc1.RecordSource = "select dno as 设备编号,rprob as 故障,rflag as 标志,operator as 经手人,date as 维修时间 from repair where dno='" & Text1.Text & "'order by date desc"
    Adodc1.Refresh
    Set DataGrid1.DataSource = Adodc1
    DataGrid1.Refresh
      End If
    End If
    End Sub