laporan praktikum pemrograman visual
Post on 26-Dec-2015
68 Views
Preview:
DESCRIPTION
TRANSCRIPT
Laporan Pemrograman Visual I
DISUSUN
OLEH:
Nama : DESMON KRISTANTO SIAHAAN
Nim : 212510056 Jurusan : TEKNIK INFORMATIKA
FAKULTAS ILMU KOMPUTERUNIVERSITAS METHODIST
INDONESIA
MEDAN
Tampilan Muka Visual Baisc (IDE)/Pengenanalan Visual Basic
Program Kalkulator
Private Sub CmdClose_Click()psn = MsgBox("Apakah Anda Ingin Keluar ???", vbYesNo + vbOKOnly, "Konfirmasi")If psn = vbYes ThenMsgBox "Terima Kasih"EndElse If psn = vbNo Then MsgBox "Loh Kog enggak jadi", vbOKOnly, "Information" End IfEnd IfEnd SubPrivate Sub CmdFrmGanjilGenap_Click()Unload MeFrmNegatifPositif.ShowEnd Sub
Private Sub HscBil1_Change()TxtBil1.Text = HscBil1.ValueEnd Sub
Private Sub HscBil2_Change()TxtBil2.Text = HscBil2.ValueEnd Sub
Private Sub OptBagi_Click()TxtHasil.Text = "Hasilnya adalah: " & Val(TxtBil1.Text) / Val(TxtBil2.Text)End Sub
Private Sub OptKali_Click()TxtHasil.Text = "Hasilnya adalah: " & Val(TxtBil1.Text) * Val(TxtBil2.Text)End Sub
Private Sub OptKurang_Click()TxtHasil.Text = "Hasilnya adalah: " & Val(TxtBil1.Text) - Val(TxtBil2.Text)End Sub
Private Sub OptModulus_Click()TxtHasil.Text = "Hasilnya adalah: " & Val(TxtBil1.Text) Mod Val(TxtBil2.Text)End Sub
Private Sub OptTambah_Click()TxtHasil.Text = "Hasilnya adalah: " & Val(TxtBil1.Text) + Val(TxtBil2.Text)End Sub
Program Bilangan Negatif Positif
Private Sub CmdClose_Click()psn = MsgBox("Apakah Anda Ingin Keluar ???", vbYesNo + vbOKOnly, "Konfirmasi")If psn = vbYes ThenMsgBox "Terima Kasih !!!"EndElse If psn = vbNo Then MsgBox "Loh Kog Enggak Jadi ..!!", vbInformation, "Information" End IfEnd IfEnd Sub
Private Sub CmdFrmKalkulator_Click()Unload MeFrmAritmatika.ShowEnd Sub
Private Sub CmdUlang_Click()TxtBilangan.Text = ""TxtHasil.Text = ""TxtBilangan.SetFocusEnd Sub
Private Sub Form_Activate()
TxtBilangan.SetFocusEnd Sub
Private Sub CmdUji_Click()If TxtBilangan.Text = Empty ThenMsgBox "Bilangan Harus Diisi", vbExclamation, "Pengingat"TxtBilangan.SetFocus
ElseIf Val(TxtBilangan.Text) >= 0 ThenTxtHasil.Text = TxtBilangan.Text & " Adalah Bilangan Positif"Else TxtHasil.Text = TxtBilangan.Text & " Adalah Bilangan Negatif"End IfEnd Sub
Program Mencari Luas Bangun Datar & Ruang
Private Sub Timer1_Timer()LblWaktu.Item(0).Caption = "Jam : " & Time & " Tanggal :" & DateLblWaktu.Item(1).Caption = "Jam : " & Time & " Tanggal :" & DateLblWaktu.Item(2).Caption = "Jam : " & Time & " Tanggal :" & DateEnd Sub
Private Sub Form_Activate()NonAktifLayangNonAktifLingkaranNonAktifSegitigaEnd Sub
Private Sub CmdUlangLayang_Click()BersihLayangEnd SubPrivate Sub CmdKeluarLayang_Click()KeluarLayangEnd Sub
Private Sub NonAktifLayang()TxtDiagonal2.Enabled = FalseTxtLLayang.Enabled = FalseCmdUlangLayang.Enabled = FalseCmdKeluarLayang.Enabled = FalseTxtDiagonal1.SetFocusEnd Sub
Private Sub BersihLayang()TxtDiagonal1.Text = ""TxtDiagonal2.Text = ""TxtLLayang.Text = ""TxtDiagonal1.SetFocusTxtDiagonal2.Enabled = FalseTxtLLayang.Enabled = FalseCmdUlangLayang.Enabled = FalseCmdKeluarLayang.Enabled = FalseEnd Sub
Private Sub TxtDiagonal1_KeyPress(KeyAscii As Integer)If KeyAscii = 13 ThenTxtDiagonal2.Enabled = TrueTxtDiagonal2.SetFocusEnd IfEnd Sub
Private Sub TxtDiagonal2_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 ThenTxtLLayang.Enabled = TrueTxtLLayang.Text = "Luas = " & " " & ((TxtDiagonal1.Text * TxtDiagonal2.Text) / 2) & " " & "cm2"CmdUlangLayang.Enabled = TrueCmdKeluarLayang.Enabled = TrueCmdUlangLayang.SetFocusEnd IfEnd SubPrivate Sub KeluarLayang()Pesan = MsgBox("Exit Form Luas Bangun Datar & Ruang ", vbQuestion + vbYesNo, "Konfirmasi")If Pesan = vbYes ThenMsgBox "Terima Kasih", vbInformation, "Informasi"EndElse If Pesan = vbNo Then MsgBox "Loh Kog Enggak Jadi!!!", vbOKOnly, "Informasi" BersihLayang End IfEnd IfEnd Sub
Private Sub NonAktifLingkaran()TxtLLingkaran.Enabled = FalseCmdUlangLingkaran.Enabled = FalseCmdKeluarLingkaran.Enabled = FalseTxtJariJari.SetFocusEnd Sub
Private Sub TxtJariJari_KeyPress(KeyAscii As Integer)If KeyAscii = 13 ThenTxtLLingkaran.Enabled = TrueTxtLLingkaran.Text = "Luas =" & " " & 3.14 * TxtJariJari * TxtJariJari & " " & "cm2"CmdUlangLingkaran.Enabled = TrueCmdKeluarLingkaran.Enabled = TrueCmdUlangLingkaran.SetFocusEnd IfEnd Sub
Private Sub CmdUlangLingkaran_Click()BersihLingkaranEnd Sub
Private Sub BersihLingkaran()TxtJariJari.Text = ""TxtLLingkaran.Text = ""CmdUlangLingkaran.Enabled = False
CmdKeluarLingkaran.Enabled = FalseTxtJariJari.SetFocusEnd Sub
Private Sub KeluarLingkaran()Pesan = MsgBox("Exit Form Luas Bangun Datar & Ruang ", vbQuestion + vbYesNo, "Konfirmasi")If Pesan = vbYes ThenMsgBox "Terima Kasih", vbInformation, "Informasi"EndElse If Pesan = vbNo Then MsgBox "Loh Kog Enggak Jadi!!!", vbOKOnly + 32, "Informasi" BersihLingkaran End IfEnd If End SubPrivate Sub CmdKeluarLingkaran_Click()KeluarLingkaranEnd Sub
Private Sub NonAktifSegitiga()TxtTinggi.Enabled = FalseTxtLSegitiga.Enabled = FalseCmdUlangSegitiga.Enabled = FalseCmdKeluarSegitiga.Enabled = FalseTxtAlas.SetFocusEnd Sub
Private Sub TxtAlas_KeyPress(KeyAscii As Integer)If KeyAscii = 13 ThenTxtTinggi.Enabled = TrueTxtTinggi.SetFocusEnd IfEnd Sub
Private Sub TxtTinggi_KeyPress(KeyAscii As Integer)If KeyAscii = 13 ThenTxtLSegitiga.Enabled = True
TxtLSegitiga.Text = "Luas =" & " " & ((TxtAlas.Text * TxtTinggi.Text) / 2) & " " & "cm2"CmdUlangSegitiga.Enabled = TrueCmdKeluarSegitiga.Enabled = TrueCmdUlangSegitiga.SetFocusEnd IfEnd Sub
Private Sub BersihSegitiga()TxtAlas.Text = ""TxtTinggi.Text = ""TxtLSegitiga.Text = ""CmdUlangSegitiga.Enabled = FalseCmdKeluarSegitiga.Enabled = FalseTxtAlas.SetFocusEnd Sub
Private Sub CmdUlangSegitiga_Click()BersihSegitigaEnd SubPrivate Sub KeluarSegitiga()Pesan = MsgBox("Exit Form Luas Bangun Datar & Ruang ", vbQuestion + vbYesNo, "Konfirmasi")If Pesan = vbYes ThenMsgBox "Terima Kasih", vbInformation, "Informasi"EndElse If Pesan = vbNo Then MsgBox "Loh Kog Enggak Jadi!!!", vbOKOnly + 32, "Informasi" BersihSegitiga End IfEnd IfEnd Sub
Private Sub CmdKeluarSegitiga_Click()KeluarSegitigaEnd Sub
Program Mencari Nilai Huruf
Private Sub CmdBatal_Click()TxtAngka.Text = EmptyTxtHuruf.Text = EmptyCmdProses.Enabled = FalseCmdBatal.Enabled = FalseCmdKeluar.Enabled = TrueTxtAngka.SetFocusEnd Sub
Private Sub CmdKeluar_Click()Pesan = MsgBox("Exit Program ???", vbQuestion + vbYesNo, "Konfirmasi")If Pesan = vbYes ThenMsgBox "Terima Kasih", vbOKOnly, "Konfirmasi"EndElse If Pesan = vbNo Then MsgBox "Loh Kog Enggak Jadi", vbOKOnly, "Konfirmasi" End IfEnd IfEnd Sub
Private Sub CmdProses_Click()Dim Angka As Integer
Dim Huruf As StringAngka = TxtAngka.Text
If (Angka >= 70) ThenHuruf = "LULUS"Else Huruf = "TIDAK LULUS"End IfTxtHuruf.Text = HurufCmdBatal.SetFocusEnd Sub
Private Sub Form_Activate()TxtHuruf.Enabled = FalseCmdProses.Enabled = FalseCmdBatal.Enabled = FalseCmdKeluar.Enabled = FalseTxtAngka.SetFocusEnd SubPrivate Sub TxtAngka_KeyPress(KeyAscii As Integer)If KeyAscii = 13 ThenTxtHuruf.Enabled = TrueCmdProses.Enabled = TrueCmdBatal.Enabled = True
CmdProses.SetFocusEnd If
End Sub
Program Kasir
Private Sub CboBanyak_Click()If CboBanyak.Text = "01" ThenTxtTotal.Text = CboBanyak.Text * TxtHarga.TextElseIf CboBanyak.Text = "02" ThenTxtTotal.Text = CboBanyak.Text * TxtHarga.TextElseIf CboBanyak.Text = "03" ThenTxtTotal.Text = CboBanyak.Text * TxtHarga.TextElseIf CboBanyak.Text = "04" ThenTxtTotal.Text = CboBanyak.Text * TxtHarga.TextElse TxtTotal.Text = CboBanyak.Text * TxtHarga.TextEnd IfTxtTotal.Enabled = 1TxtBayar.Enabled = 1TxtBayar.SetFocusEnd Sub
Private Sub CboKdBarang_Click()If CboKdBarang.Text = "KDOO1" ThenTxtNmBarang.Text = "Flash Disk"TxtHarga.Text = "50000"ElseIf CboKdBarang.Text = "KD002" ThenTxtNmBarang.Text = "Mouse"TxtHarga.Text = "65000"ElseIf CboKdBarang.Text = "KD003" ThenTxtNmBarang.Text = "Memory"TxtHarga.Text = "250000"ElseIf CboKdBarang.Text = "KD004" ThenTxtNmBarang.Text = "Harddisk"TxtHarga.Text = "500000"Else TxtNmBarang.Text = "Keyboard" TxtHarga.Text = "125000"End IfCboBanyak.Enabled = 1CboBanyak.SetFocusEnd Sub
Private Sub CmdBatal_Click()BatalEnd SubPrivate Sub Batal()CboKdBarang.Text = ""CboKdBarang.SetFocus
TxtNmBarang.Text = ""TxtHarga.Text = ""CboBanyak.Text = ""TxtTotal.Text = ""TxtBayar.Text = ""TxtKembali.Text = ""NonAktifEnd Sub
Private Sub CmdKeluar_Click()pesan = MsgBox("Exit Program Kasir??", vbQuestion + vbYesNo, "Konfirmasi")If pesan = vbYes ThenMsgBox "Terima Kasih", vbOKOnly, "Konfirmasi"EndElse If pesan = vbNo Then MsgBox "Loh Kog Enggak jadi", vbInformation, "Informasi" End If BatalEnd IfEnd Sub
Private Sub Form_Activate()NonAktifEnd SubPrivate Sub NonAktif()CboBanyak.Enabled = 0TxtTotal.Enabled = 0TxtBayar.Enabled = 0TxtKembali.Enabled = 0CmdBatal.Enabled = 0CboKdBarang.SetFocusEnd Sub
Private Sub TxtBayar_KeyPress(KeyAscii As Integer)If KeyAscii = 13 ThenTxtKembali.Text = TxtTotal.Text - TxtBayar.TextTxtKembali.Enabled = 1CmdBatal.Enabled = 1CmdBatal.SetFocusEnd IfEnd Sub
Program Mencari Nilai Pangkat Bilangan
Private Sub CmdHapus_Click()TxtNilai = EmptyTxtPangkat = EmptyTxtHasil = EmptyEnd Sub
Private Sub CmdProses_Click()Dim a As IntegerDim b As IntegerDim Jlh As Integera = Val(TxtNilai)b = Val(TxtPangkat)Jlh = 1For i = 1 To b Jlh = Jlh * aNext iTxtHasil.Text = JlhEnd Sub
Private Sub CmdTutup_Click()psn = MsgBox("Exit Program ???", 32 + 4, "Konfirmasi")
If psn = vbYes ThenMsgBox "Terima Kasih Atas Kunjungan Anda", vbInformation, "informasi"End If psn = vbNo Then MsgBox "Loh Kok Enggak Jadi Yachhhh", vbCritical, "Pesan" End IfEnd IfEnd Sub
Private Sub TxtNilai_KeyPress(KeyAscii As Integer)If KeyAscii = 13 ThenTxtPangkat.SetFocusEnd IfEnd SubPrivate Sub TxtPangkat_KeyPress(KeyAscii As Integer)If KeyAscii = 13 ThenCmdProses.SetFocusEnd IfEnd Sub
Program Faktorial
Private Sub cmdHapus_Click()TxtFaktorial = ""TxtHasil = ""End Sub
Private Sub cmdTutup_Click()EndEnd Sub
Private Sub TxtFaktorial_KeyPress(KeyAscii As Integer)Dim a As LongDim Jlh As LongDim Hasil As Longa = Val(TxtFaktorial.Text)Jlh = 1If KeyAscii = 13 Then
If a <= 0 Then TxtHasil.Text = 0 Else For i = a To 1 Step -1 Jlh = Jlh * i Next i End If TxtHasil.Text = JlhEnd IfEnd Sub
Program Penggajian
Private Sub NonAktif()txtNama.Enabled = 0cboGol.Enabled = 0optLaki.Enabled = 0optPerempuan.Enabled = 0cboStatus.Enabled = 0txtTunjangan.Enabled = 0txtGapok.Enabled = 0txtGaber.Enabled = 0cmdHitung.Enabled = 0cmdUlang.Enabled = 0End SubPrivate Sub Form_Load()For i = 212510054 To 212510056CboNIP.AddItem iNext i
NonAktifEnd SubPrivate Sub CboNIP_Click()If CboNIP.Text = "212510054" ThentxtNama.Text = "Evan Sembiring"ElseIf CboNIP.Text = "212510055" ThentxtNama.Text = "Ramot Manurung"Else txtNama.Text = "Desmon Siahaan"End If
txtNama.Enabled = 1cboGol.Enabled = 1cboGol.SetFocusEnd SubPrivate Sub cboGol_Click()If cboGol.Text = "III A" Then txtGapok.Text = 1500000 txtGapok = Format(txtGapok, "###,###,###")ElseIf cboGol.Text = "III B" Then txtGapok.Text = 2000000 txtGapok = Format(txtGapok, "###,###,###")ElseIf cboGol.Text = "III C" Then txtGapok.Text = 2500000 txtGapok = Format(txtGapok, "###,###,###")Else txtGapok.Text = 3000000 txtGapok = Format(txtGapok, "###,###,###")End If
optLaki.Enabled = 1optPerempuan.Enabled = 1txtGapok.Enabled = 1End SubPrivate Sub optLaki_Click()cboStatus.Enabled = 1
cboStatus.SetFocusEnd SubPrivate Sub optPerempuan_Click()cboStatus.Enabled = 1cboStatus.SetFocusEnd Sub
Private Sub cboStatus_Click()If cboStatus.Text = "Menikah" ThentxtTunjangan = 750000txtTunjangan = Format(txtTunjangan, "###,###,###")Else txtTunjangan = 2000000 txtTunjangan = Format(txtTunjangan, "###,###,###")End If
txtTunjangan.Enabled = 1cmdHitung.Enabled = 1txtGaber.Enabled = 1cmdHitung.SetFocusEnd SubPrivate Sub cmdHitung_Click()Dim a, b As Longa = txtTunjanganb = txtGapokc = Format(a + b, "###,###,###")txtGaber = c
cmdUlang.Enabled = 1cmdUlang.SetFocuscmdHitung.Enabled = 0End SubPrivate Sub Ulang()CboNIP = EmptytxtNama = EmptycboGol = EmptyoptLaki = EmptyoptPerempuan = EmptycboStatus = EmptytxtTunjangan = EmptytxtGapok = EmptytxtGaber = EmptyEnd SubPrivate Sub cmdUlang_Click()UlangcmdUlang.Enabled = 0CboNIP.SetFocus
NonAktifEnd SubPrivate Sub cmdKeluar_Click()pesan = MsgBox("Exit Program??", vbQuestion + vbYesNo, "Informasi")
If pesan = vbYes Then MsgBox "Terima Kasih", vbInformationEnd If pesan = vbNo Then MsgBox "Loh Kog Enggak Jadi", vbInformation
End IfEnd IfUlangEnd Sub
Program Tiket (Kuis)
Private Sub cboJlh_Click()txtTotal = Val(txtHarga.Text) * cboJlh.TexttxtTotal = Format(txtTotal, "Rp ###,###,###")End Sub
Private Sub cboTujuan_Click()If cboTujuan.Text = "Medan Sidikalang" ThentxtHarga.Text = 70000ElseIf cboTujuan.Text = "Medan Sibolga" ThentxtHarga = 80000ElseIf cboTujuan.Text = "Medan Siantar" ThentxtHarga = 60000ElseIf cboTujuan.Text = "Sidikalang Medan" ThentxtHarga = 70000ElseIf cboTujuan.Text = "Sibolga Medan" ThentxtHarga = 80000Else txtHarga = 60000End IfEnd Sub
Private Sub cmdBatal_Click()cboTujuan.Text = ""cboMobil.Text = ""
cboWaktu.Text = ""txtHarga.Text = ""cboJlh.Text = ""txtTotal.Text = ""txtBayar.Text = ""
txtKembali.Text = ""txtPembeli.Text = ""End Sub
Private Sub Form_Activate()txtPembeli.SetFocusFor i = 1 To 10cboJlh.AddItem iNext iEnd Sub
Private Sub txtBayar_KeyPress(KeyAscii As Integer)If KeyAscii = 13 ThentxtBayar = Format(txtBayar, "Rp ###,###,###") & ",-" If txtBayar = txtTotal Then txtKembali = "Uang nya pas, Terima kasih :)" Else If txtBayar = "" Or txtBayar < txtTotal Then txtKembali = "Kurang" & Space(1) & Format(txtBayar - txtTotal, "Rp ###,###,###") & ",-" Else txtKembali = "Kembali" & txtBayar - txtTotal End If End IfEnd IfEnd Sub
Program Tebak Angka
Private Sub cmdStart_Click()Timer1.Enabled = True
lblHasil.Caption = ""lblMenangkalah.Caption = ""End Sub
Private Sub cmdStop_Click()lblHasil.Caption = "Angka yang muncul : " & L1.Caption & L2.Caption & L3.Caption & L4.Caption
Timer1.Enabled = FalseIf li = L2 Or L1 = L3 Or L1 = L4 Or L2 = L3 Or L2 = L4 Or L3 = L4 ThenlblMenangkalah.Caption = "Anda Menang bro"Else lblMenangkalah.Caption = "Tidak ada angka yang sama You kalah broo "
End IfEnd Sub
Private Sub Form_Load()Timer1.Enabled = FalseEnd Sub
Private Sub Timer1_Timer()RandomizeL1.Caption = Int(Rnd() * 10)L2.Caption = Int(Rnd() * 10)L3.Caption = Int(Rnd() * 10)L4.Caption = Int(Rnd() * 10)
'lblMenangkalah.Visible = Not lblMenangkalah.VisibleEnd Sub
Program Teks Berjalan dan Teks Berkedip
Dim i, x As String
Private Sub Judul_Timer()Dim Jdl As Stringi = i + 1
Jdl = "Latihan dengan timer kontrol"If i > Len(Jdl) Then i = 0Me.Caption = Left(Jdl, Len(Jdl) - (Len(Jdl) - i))
End Sub
Private Sub Timer1_Timer()Dim Teks As StringTeks = "Pemrograman Visual Basic dengan timer" lblTeks.Caption = TekslblTeks.Visible = Not lblTeks.VisibleEnd Sub
Program Rumah Makan
Private Sub cmdPesan_Click()Pilihan = ""For i = 0 To 27x = Check1(i).Value = 1 If Check1(i).Value = 1 Then x = Val(LblHarga(i).Caption)
Pilihan = Pilihan + Check1(i).Caption + " " y = Val(y) + x End IfNext iLblPesan.Caption = PilihantxtTotal.Text = y
txtTotal = Format(txtTotal, "Rp ###,###,###") & ",-"txtBayar.SetFocusEnd Sub
Private Sub txtBayar_KeyPress(KeyAscii As Integer)If KeyAscii = 13 ThentxtBayar = Format(txtBayar, "Rp ###,###,###") & ",-" If txtBayar = txtTotal Then LblKet = "Uang nya pas, Terima Kasih :)" Else If txtBayar = "" Or txtBayar < txtTotal Then LblKet = "Kurang" & Format(txtTotal - txtBayar, "Rp ###,###,###") & ",-" Else LblKet = "Kembali" & Format(txtBayar - txtTotal, "Rp ###,###,###") & ",-" End If CmdPesanBaru.SetFocus End IfEnd IfEnd Sub
Private Sub PesananBaru()LblPesan.Caption = Empty
txtTotal.Text = EmptytxtBayar.Text = EmptyLblKet.Caption = EmptyFor i = 0 To 27Check1(i).Value = 0Next iEnd SubPrivate Sub CmdPesanBaru_Click()PesananBaruEnd Sub
Private Sub cmdKeluar_Click()pesan = MsgBox("Exit Aplication??", vbQuestion + vbYesNo, "Konfirmasi")If pesan = vbYes ThenMsgBox "Terima Kasih Atas Kunjungan Anda," & vbCrLf & "Aplikasi Segera Ditutup", vbExclamation, "Pesan"EndElse If pesan = vbNo Then MsgBox "Loh,Kog Enggak Jadi Yachhh", vbInformation, "" End If PesananBaruEnd IfEnd Sub
MDI Form
Private Sub mnuExit_Click()psn = MsgBox("Exit Application???", vbYesNo, "Konfirmasi")If psn = vbYes ThenEndEnd IfEnd Sub
Private Sub mnuKasir_Click()FrmKasir.ShowEnd Sub
Private Sub mnuMataUang_Click()frmMataUang.ShowEnd Sub
Private Sub mnuSegitiga_Click()
frmSegitiga.ShowEnd Sub
Private Sub mnuTebakAngka_Click()frmTebakAngka.ShowEnd Sub
Private Sub mnuTeksUlang_Click()frmPerulangan.ShowEnd Sub
Private Sub Timer1_Timer()Me.StatusBar1.Panels(1) = Format(Now, "hh:mm:ss")Me.StatusBar1.Panels(2) = Format(Now, "dd-mm-yyyy")Me.StatusBar1.Panels(3) = "Desmon Kristanto Siahaan"End Sub
Program Database Mahasiswa
Public conn As New ADODB.ConnectionPublic rs As New ADODB.RecordsetPublic koneksi As String
Private Sub cmdHapus_Click()hapus = MsgBox("Yakin Menghapus Data", vbYesNo, "Hapus Data")If hapus = vbYes Then rs.DeleteEnd IfEnd Sub
Private Sub cmdSimpan_Click()rs.Find "NPM='" & txtNPM.Text & "'", adSearchForward, adBookmarkFirstIf rs.EOF Then rs.AddNew rs!NPM = txtNPM.Text rs!Nama = txtNama.Text rs!Fakultas = cboFakultas.Text rs!Jurusan = cboJurusan.Text rs!Telp = txtTelp.Text rs!Alamat = txtAlamat.Text rs.UpdateElse MsgBox "Maaf,NPM Sudah Tersimpan", vbCriticalEnd If
txtNPM = ""txtNama = ""cboFakultas = ""cboJurusan = ""txtTelp = ""txtAlamat = ""
txtNPM.SetFocusEnd Sub
Private Sub Form_Activate()txtNPM.SetFocusEnd Sub
Private Sub Form_Load()'conn.CursorLocation = adUseClientkoneksi = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\DATA MHS\212510056 Desmon\Visual Basic\Mahasiswa\mahasiswa.mdb;Persist Security Info=False"conn.Open koneksirs.Open "tblMahasiswa", conn, 1, 3
With cboFakultas .AddItem "Kedokteran" .AddItem "Ekonomi" .AddItem "Sastra" .AddItem "Pertanian" .AddItem "Ilmu Komputer"End With
With cboJurusan .AddItem "Profersi Dokter" .AddItem "Manajemen" .AddItem "Sastra Inggris" .AddItem "Agroteknologi" .AddItem "Teknik Informatika"End WithEnd Sub
top related