form3.frm

vb

VERSION 5.00
Begin VB.Form Form3 
   Caption         =   "Form3"
   ClientHeight    =   7185
   ClientLeft      =   4785
   ClientTop       =   3180
   ClientWidth     =   8805
   Icon            =   "Form3.frx":0000
   LinkTopic       =   "Form3"
   MaxButton       =   0   'False
   ScaleHeight     =   7185
   ScaleWidth      =   8805
   Begin VB.CommandButton Command2 
      Caption         =   "Command2"
      Height          =   735
      Left            =   6600
      TabIndex        =   12
      Top             =   4080
      Width           =   1335
   End
   Begin VB.CommandButton Command1 
      Caption         =   "E"
      Height          =   735
      Index           =   4
      Left            =   2160
      TabIndex        =   5
      Top             =   6360
      Width           =   1455
   End
   Begin VB.CommandButton Command1 
      Caption         =   "D"
      Height          =   735
      Index           =   3
      Left            =   2160
      TabIndex        =   4
      Top             =   5400
      Width           =   1455
   End
   Begin VB.CommandButton Command1 
      Caption         =   "C"
      Height          =   735
      Index           =   2
      Left            =   2160
      TabIndex        =   3
      Top             =   4560
      Width           =   1455
   End
   Begin VB.CommandButton Command1 
      Caption         =   "B"
      Height          =   735
      Index           =   1
      Left            =   2160
      TabIndex        =   2
      Top             =   3720
      Width           =   1455
   End
   Begin VB.CommandButton Command1 
      Caption         =   "A"
      Height          =   735
      Index           =   0
      Left            =   2160
      TabIndex        =   1
      Top             =   2640
      Width           =   1455
   End
   Begin VB.TextBox Text1 
      DataField       =   "题目"
      DataSource      =   "Data1"
      Height          =   1695
      Left            =   2280
      MultiLine       =   -1  'True
      TabIndex        =   0
      Text            =   "Form3.frx":0816
      Top             =   840
      Width           =   5775
   End
   Begin VB.Data Data1 
      Caption         =   "Data1"
      Connect         =   "Access"
      DatabaseName    =   "D:\你适合从事管理工作吗？\data\职业价值观.mdb"
      DefaultCursorType=   0  '缺省游标
      DefaultType     =   2  '使用 ODBC
      Exclusive       =   0   'False
      Height          =   855
      Left            =   2880
      Options         =   0
      ReadOnly        =   0   'False
      RecordsetType   =   1  'Dynaset
      RecordSource    =   "MYValue"
      Top             =   360
      Visible         =   0   'False
      Width           =   3135
   End
   Begin VB.Label Label2 
      BackStyle       =   0  'Transparent
      Caption         =   "很不重要"
      Height          =   615
      Index           =   4
      Left            =   3840
      TabIndex        =   11
      Top             =   6360
      Width           =   2175
   End
   Begin VB.Label Label2 
      BackStyle       =   0  'Transparent
      Caption         =   "较不重要"
      Height          =   615
      Index           =   3
      Left            =   3840
      TabIndex        =   10
      Top             =   5520
      Width           =   2175
   End
   Begin VB.Label Label2 
      BackStyle       =   0  'Transparent
      Caption         =   "一般"
      Height          =   615
      Index           =   2
      Left            =   3840
      TabIndex        =   9
      Top             =   4680
      Width           =   2175
   End
   Begin VB.Label Label2 
      BackStyle       =   0  'Transparent
      Caption         =   "比较重要"
      Height          =   615
      Index           =   1
      Left            =   3840
      TabIndex        =   8
      Top             =   3720
      Width           =   2175
   End
   Begin VB.Label Label2 
      BackStyle       =   0  'Transparent
      Caption         =   "非常重要"
      Height          =   615
      Index           =   0
      Left            =   3840
      TabIndex        =   7
      Top             =   2760
      Width           =   2175
   End
   Begin VB.Label Label1 
      Caption         =   "Label1"
      DataField       =   "题号"
      DataSource      =   "Data1"
      Height          =   495
      Left            =   1800
      TabIndex        =   6
      Top             =   840
      Width           =   495
   End
End
Attribute VB_Name = "Form3"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command2_Click()
Print s2
End Sub

Private Sub Form_Load()
Data1.DatabaseName = App.Path + "\data\职业价值观.mdb"
End Sub

Private Sub Command1_Click(Index As Integer)
Dim defen '每题得分
Select Case Index
Case 0
     defen = 5
Case 1
    defen = 4
Case 2
    defen = 3
Case 3
    defen = 2
Case 4
    defen = 1
End Select

s2 = s2 + defen

 Data1.Recordset.MoveNext
    If Data1.Recordset.EOF Then
       j = MsgBox("测试完毕！", 64, "职业价值观")
        Data1.Recordset.MoveLast
        'Command2_Click
        
    End If
    
    If Data1.Recordset.BOF Then
        MsgBox "第一条记录"
        Data1.Recordset.MoveFirst
    End If
End Sub