Private Sub Command1_Click()
Dim e As String
Text6.Text = “20” & Mid(Text2.Text, 3, 2)
Text7.Text = Right(Text2.Text, 3)
e = Left(Text2.Text, 1)
If e = “E” Then
Text3.Text = “EKSEKUTIF”
ElseIf e = “R” Then
Text3.Text = “REGULER”
End If
e = Mid(Text2.Text, 5, 1)
If e = “1” Then
Text4.Text = “SISTEM INFORMASI”
ElseIf e = “2” Then
Text4.Text = “MANAJEMEN INFORMATIKA”
ElseIf e = “3” Then
Text4.Text = “MANAJEMEN DAN KOMP.AKUNTANSI”
End If
e = Mid(Text2.Text, 6, 2)
If e = “01” Then
Text5.Text = “STRATA SATU”
ElseIf e = “02” Then
Text5.Text = “DIPLOMA TIGA”
ElseIf e = “03” Then
Text5.Text = “DIPLOMA SATU”
End If
If Text3.Text = “EKSEKUTIF” And Text5.Text = “STRATA SATU” Then
Text8.Text = “200000”
Text9.Text = “1900000”
Text10.Text = “1500000”
Text11.Text = “1250000”
ElseIf Text3.Text = “EKSEKUTIF” And Text5.Text = “DIPLOMA TIGA” Then
Text8.Text = “1500000”
Text9.Text = “1650000”
Text10.Text = “1250000”
Text11.Text = “1250000”
ElseIf Text3.Text = “EXSEKUTIF” And Text5.Text = “DIPLOMA SATU” Then
Text8.Text = “150000”
Text9.Text = “1350000”
Text10.Text = “1250000”
Text11.Text = “1250000”
End If
If Text3.Text = “REGULER” And Text5.Text = “STRATA SATU” Then
Text8.Text = “200000”
Text9.Text = “1900000”
Text10.Text = “1500000”
Text11.Text = “1000000”
ElseIf Text3.Text = “REGULER” And Text5.Text = “DIPLOMA TIGA” Then
Text8.Text = “1500000”
Text9.Text = “1650000”
Text10.Text = “1250000”
Text11.Text = “1000000”
ElseIf Text3.Text = “REGULER” And Text5.Text = “DIPLOMA SATU” Then
Text8.Text = “150000”
Text9.Text = “1350000”
Text10.Text = “1250000”
Text11.Text = “1000000”
End If
Text12.Text = Val(Text8) + Val(Text9) + Val(Text10) + Val(Text11) + Val(Text12)
End Sub
Private Sub Command2_Click()
With Data1.Recordset
.AddNew
.Fields(“nama”) = Text1.Text
.Fields(“npm”) = Text2.Text
.Fields(“kelas”) = Text3.Text
.Fields(“jurusan”) = Text4.Text
.Fields(“prodi”) = Text5.Text
.Fields(“tahun”) = Text6.Text
.Fields(“nurut”) = Text7.Text
.Fields(“pendaftaran”) = Text8.Text
.Fields(“semester”) = Text9.Text
.Fields(“sarana”) = Text10.Text
.Fields(“posdikti”) = Text11.Text
.Fields(“total”) = Text12.Text
.Update
MsgBox “BERHASIL TERSIMPAN”, vbOKCancel
End With
Text1.SetFocus
End Sub
Private Sub Command3_Click()
Text1.SetFocus
With Data1.Recordset
Text1.Text = .Fields(“nama”)
Text2.Text = .Fields(“npm”)
Text3.Text = .Fields(“kelas”)
Text4.Text = .Fields(“jurusan”)
Text5.Text = .Fields(“prodi”)
Text6.Text = .Fields(“tahun”)
Text7.Text = .Fields(“nurut”)
Text8.Text = .Fields(“pendaftaran”)
Text9.Text = .Fields(“semester”)
Text10.Text = .Fields(“sarana”)
Text11.Text = .Fields(“posdikti”)
Text12.Text = .Fields(“total”)
End With
End Sub
Private Sub Command4_Click()
MsgBox “DATA INI AKAN DIHAPUS”, vbOKOnly
Data1.Recordset.Delete
Text1.SetFocus
Text1.Text = “”
Text2.Text = “”
Text3.Text = “”
Text4.Text = “”
Text5.Text = “”
Text6.Text = “”
Text7.Text = “”
Text8.Text = “”
Text9.Text = “”
Text10.Text = “”
Text11.Text = “”
Text12.Text = “”
End Sub
Private Sub Command5_Click()
With Data1.Recordset
.Edit
Text1.Text = .Fields(“nama”)
Text2.Text = .Fields(“npm”)
Text3.Text = .Fields(“kelas”)
Text4.Text = .Fields(“jurusan”)
Text5.Text = .Fields(“prodi”)
Text6.Text = .Fields(“tahun”)
Text7.Text = .Fields(“nurut”)
Text8.Text = .Fields(“pendaftaran”)
Text9.Text = .Fields(“semester”)
Text10.Text = .Fields(“sarana”)
Text11.Text = .Fields(“posdikti”)
Text12.Text = .Fields(“total”)
.Update
End With
MsgBox “DATA TELAH DIGANTII”, vbOKOnly
End Sub
End Sub
Private Sub Command6_Click()
MsgBox “ANDA YAKIN AKAN KELUAR”, vbOKOnly
End
End Sub
Private Sub Command7_Click()
Text1.SetFocus
Text1.Text = “”
Text2.Text = “”
Text3.Text = “”
Text4.Text = “”
Text5.Text = “”
Text6.Text = “”
Text7.Text = “”
Text8.Text = “”
Text9.Text = “”
Text10.Text = “”
Text11.Text = “”
Text12.Text = “”
End Sub
Private Sub Form_Activate()
Text1.SetFocus
End Sub
Private Sub Text1_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Text2.SetFocus
End If
End Sub