'Koneksi Ke Database
Me.data1.DatabaseName = App.Path + "\quiz.mdb"
End Sub
'Membuat Prosedur
Me.tno = ""
Me.tpsi = ""
Me.tkes = ""
Me.tint = ""
Me.tnil = ""
Me.tket = ""
End Sub
Sub aktif()
Me.tpsi.Enabled = True
Me.tkes.Enabled = True
Me.tint.Enabled = True
End Sub
Sub nonaktif()
Me.tno.Enabled = False
Me.tpsi.Enabled = False
Me.tkes.Enabled = False
Me.tint.Enabled = False
Me.tnil.Enabled = False
Me.tket.Enabled = False
End Sub
'Ketika Form Aktif
Private Sub Form_Activate()
bersih
nonaktif
Me.cnew.SetFocus
End Sub
'Membuat No. Otomatis
bersih
aktif
With data1.Recordset
If .RecordCount > 0 Then
.MoveLast
tno.Text = Val(!nopeserta) + 1
Else
tno.Text = 1
End If
End With
Me.tpsi.SetFocus
End Sub
'Mencari nilai dan Keterangan
If KeyAscii = 13 Then
Me.tnil.Text = (Val(Me.tpsi) + Val(Me.tkes) + Val(Me.tint)) / 3
If Me.tnil.Text > 70 Then
tket.Text = "Lolos Tes"
Else
tket.Text = "Ikut Lagi Taon Dpan"
End If
End If
End Sub
'Menyimpan Record
With data1.Recordset
.AddNew
!nopeserta = Me.tno.Text
If Me.Option1.Value = True Then
!pendidikan = Me.Option1.Caption
Else
!pendidikan = Me.Option2.Caption
End If
!psikotes = Val(Me.tpsi.Text)
!kesehatan = Val(Me.tkes.Text)
!interview = Val(Me.tint.Text)
!nilai = Val(Me.tnil.Text)
!keterangan = Me.tket.Text
.Update
End With
MsgBox "Data Tersimpan"
bersih
nonaktif
Me.cnew.SetFocus
End Sub
'Menghapus Record
If MsgBox("Hapus Nih?", vbYesNo) = vbYes Then
data1.Recordset.Delete
End If
End Sub
'Keluar dari Form
If MsgBox("Keluar Nih?", vbYesNo) = vbYes Then
Unload Me
End If
End Sub
Posting Komentar