form8.frm

用vb编写的网上试题库对你学习VB很有帮助！

VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Begin VB.Form 历史记录 
   Caption         =   "                           历史记录"
   ClientHeight    =   6225
   ClientLeft      =   165
   ClientTop       =   555
   ClientWidth     =   7890
   LinkTopic       =   "Form8"
   Picture         =   "Form8.frx":0000
   ScaleHeight     =   6225
   ScaleWidth      =   7890
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton Command1 
      Caption         =   "返回上一目录"
      Height          =   495
      Left            =   2040
      TabIndex        =   1
      Top             =   2640
      Width           =   1575
   End
   Begin MSFlexGridLib.MSFlexGrid MSFlexGrid1 
      Bindings        =   "Form8.frx":1DDAE
      Height          =   1815
      Left            =   0
      TabIndex        =   0
      Top             =   0
      Width           =   5775
      _ExtentX        =   10186
      _ExtentY        =   3201
      _Version        =   393216
   End
   Begin VB.Data Data1 
      Caption         =   "Data1"
      Connect         =   "Access 2000;"
      DatabaseName    =   ""
      DefaultCursorType=   0  '缺省游标
      DefaultType     =   2  '使用 ODBC
      Exclusive       =   0   'False
      Height          =   345
      Left            =   240
      Options         =   0
      ReadOnly        =   0   'False
      RecordsetType   =   1  'Dynaset
      RecordSource    =   ""
      Top             =   2880
      Visible         =   0   'False
      Width           =   1140
   End
End
Attribute VB_Name = "历史记录"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()

Unload Me
End Sub

Private Sub Form_Load()
Data1.DatabaseName = "试题库.mdb"
Data1.RecordSource = "select * from 历史记录 where 用户名='" & 登陆.Text4.Text & "'"
Data1.Refresh
If 登陆.Option1.Value = True Then
Data1.DatabaseName = "试题库.mdb"
Data1.RecordSource = "select * from 历史记录 "
Data1.Refresh
End If
End Sub