form1.frm

来自「vb源码大全」· FRM 代码 · 共 52 行

VERSION 5.00
Begin VB.Form Form1 
   Caption         =   "Form1"
   ClientHeight    =   3195
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   4680
   LinkTopic       =   "Form1"
   ScaleHeight     =   3195
   ScaleWidth      =   4680
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton Command1 
      Caption         =   "浏览数据记录"
      Height          =   615
      Left            =   1080
      TabIndex        =   0
      Top             =   1080
      Width           =   2655
   End
End
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()

  Dim db As DAO.Database
  Dim rs As DAO.Recordset
  Dim fld As DAO.Field
'根据实际设置数据库位置
  Set db = DBEngine.OpenDatabase(App.Path + "/MySampleDB.mdb")
  ' 打开数据记录集，这里使用SQL语言打开。
  
  Set rs = db.OpenRecordset("SELECT * FROM 客户表 WHERE CustomerID = 'C00001'")

  '显示所浏览到的记录
  '将结果输出到debug窗口
  rs.MoveFirst
  While Not rs.EOF
    For Each fld In rs.Fields
      Debug.Print fld.Value & ";";  '记录到显示器上
    Next
    Debug.Print
    rs.MoveNext
  Wend
  '关闭数据库
  rs.Close
Set rs = Nothing

End Sub