- NPM
Private Sub CmdBatal_Click()
TxtNama.SetFocus
TxtNama.Text = “”
TxtNpm.Text = “”
TxtJurusan.Text = “”
TxtPrody.Text = “”
TxtTahunMasuk.Text = “”
TxtNomorUrut.Text = “”
End Sub
Private Sub CMDSAVE_Click()
Adodc1.Recordset.Save
End Sub
Private Sub CmdLagi_Click()
TxtNama.SetFocus
TxtNama.Text = “”
TxtNpm.Text = “”
TxtJurusan.Text = “”
TxtPrody.Text = “”
TxtTahunMasuk.Text = “”
TxtNomorUrut.Text = “”
End Sub
Private Sub CmdProses_Click()
Dim Kode, KodeJurusan, KodePrody, Jurusan, Prody, TahunMasuk, NomorUrut As Variant
Kode = TxtNpm
TahunMasuk = “20” & Left(Kode, 2)
TxtTahunMasuk = TahunMasuk
KodeJurusan = Mid(Kode, 3, 1)
Select Case KodeJurusan
Case “1”
Jurusan = “Sistem Informasi”
Case “2”
Jurusan = “Teknik Informatika”
Case “3”
Jurusan = “Manajemen Informatika”
Case “4”
Jurusan = “Komputer Akuntansi”
End Select
TxtJurusan = Jurusan
KodePrody = Mid(Kode, 4, 2)
Select Case KodePrody
Case “01”
Prody = “Strata Satu”
Case “02”
Prody = “Diplomat Empat”
Case “03”
Prody = “Diplomat Tiga”
Case “04”
Prody = “Diplomat Dua”
End Select
TxtPrody = Prody
NomorUrut = Right(Kode, 3)
TxtNomorUrut = NomorUrut
End Sub
Private Sub Cmdcancel_Click()
TxtNama.SetFocus
TxtNama.Text = “”
TxtNpm.Text = “”
TxtJurusan.Text = “”
TxtPrody.Text = “”
TxtTahunMasuk.Text = “”
TxtNomorUrut.Text = “”
End Sub
Private Sub CMDADD_Click()
Adodc1.Recordset.AddNew
End Sub
Private Sub CMDKELUAR_CLICK(index as integer)
Unload Me
End Sub
SCREENSHOOT
- TUGAS TOKO ALAT TULIS SALSABILA
Private Sub CmdBatal_Click()
TxtNama.SetFocus
TxtNama.Text = “”
TxtNpm.Text = “”
TxtJurusan.Text = “”
TxtPrody.Text = “”
TxtTahunMasuk.Text = “”
TxtNomorUrut.Text = “”
End Sub
Private Sub CMDSAVE_Click()
Adodc1.Recordset.Save
End Sub
Private Sub CmdLagi_Click()
TxtNama.SetFocus
TxtNama.Text = “”
TxtNpm.Text = “”
TxtJurusan.Text = “”
TxtPrody.Text = “”
TxtTahunMasuk.Text = “”
TxtNomorUrut.Text = “”
End Sub
Private Sub CmdProses_Click()
Dim Kode, KodeJurusan, KodePrody, Jurusan, Prody, TahunMasuk, NomorUrut As Variant
KodeJurusan = Mid(Kode, 3, 1)
Select Case KodeJurusan
Case “1”
Jurusan = “Sistem Informasi”
Case “2”
Jurusan = “Teknik Informatika”
Case “3”
Jurusan = “Manajemen Informatika”
Case “4”
Jurusan = “Komputer Akuntansi”
End Select
TxtJurusan = Jurusan
KodePrody = Mid(Kode, 4, 2)
Select Case KodePrody
Case “01”
Prody = “Strata Satu”
Case “02”
Prody = “Diplomat Empat”
Case “03”
Prody = “Diplomat Tiga”
Case “04”
Prody = “Diplomat Dua”
End Select
TxtPrody = Prody
NomorUrut = Right(Kode, 3)
TxtNomorUrut = NomorUrut
End Sub
Private Sub Cmdcancel_Click()
TxtNama.SetFocus
TxtNama.Text = “”
TxtNpm.Text = “”
TxtJurusan.Text = “”
TxtPrody.Text = “”
TxtTahunMasuk.Text = “”
TxtNomorUrut.Text = “”
End Sub
Private Sub CMDADD_Click()
Adodc1.Recordset.AddNew
End Sub
Private Sub CMDKELUAR_CLICK(index as integer)
Unload Me
End Sub
SCREENSHOOOT
- TUGAS GOLONGAN
Private Sub CMDkeluar_Click(index as integer)
Unload Me
End Sub
Private Sub cmdbaru_Click()
Adodc1.Recordset.AddNew
End Sub
Private Sub CMDHAPUS_Click()
Adodc1.Recordset.Delete
End Sub
Private Sub CMDSAVE_Click()
Adodc1.Recordset.save
End Sub
Private Sub txtnpm_keypress(keyascii As Integer)
If keyascii = 13 Then
txtnama.SetFocus
End If
End Sub
Private Sub Cmdbatal_Click()
kosong
End Sub
Private Sub cmdlagi_Click()
kosong
End Sub
Private Sub Form_load()
CBOGOLONGAN.AddItem “I”
CBOGOLONGAN.AddItem “II”
CBOGOLONGAN.AddItem “III”
CBOGOLONGAN.AddItem “IV”
End Sub
Private Sub cbogolongan_Click()
Dim gapok, pajak, tunjangan, total As Variant
Select Case CBOGOLONGAN.Text
Case “I”
gapok = 1500000
tunjangan = 150000
Case “II”
gapok = 2000000
tunjangan = 200000
Case “III”
gapok = 2500000
tunjangan = 250000
Case “IV”
gapok = 3000000
tunjangan = 300000
Case Else
gapok = 0
tunjangan = 0
End Select
total = gapok + tunjangan
pajak = total * 0.1
txtgapok.Text = gapok
txttunjangan.Text = tunjangan
txtpajak.Text = pajak
txttotal.Text = total – pajak
End Sub
Public Sub kosong()
txtNPM.SetFocus
txtNPM.Text = “”
txtnama.Text = “”
CBOGOLONGAN.Text = “”
txtgapok.Text = “”
txttunjangan.Text = “”
txtpajak.Text = “”
txttotal.Text = “”
End Sub
SCREENSHOOT
- TUGAS DATA BUKU STMIK PRINGSEWU
Private Sub CMD4_Click(index As Integer)
Unload Me
End Sub
Private Sub CMDADD_Click()
Adodc1.Recordset.addnew
End Sub
Private Sub CmdBatal_Click()
CboKode.SetFocus
CboKode = “Pilih Kode Buku”
TxtJudul = “”
TxtPengarang = “”
TxtTHTerbit = “”
TxtPenerbit = “”
TxtHarga = “”
End Sub
Private Sub CMDCANCEL_Click()
Adodc1.Recordset.Cancel
End Sub
Private Sub CMDKELUAR_Click(index As Integer)
Unload Me
End Sub
Private Sub CmdLagi_Click()
CboKode.SetFocus
CboKode = “Pilih Kode Buku”
TxtJudul = “”
TxtPengarang = “”
TxtTHTerbit = “”
TxtPenerbit = “”
TxtHarga = “”
End Sub
Private Sub CmdProses_Click()
Dim Kode, KodeBuku, KodePenerbit, KodeTahun, Tahun, Penerbit, Judul, Pengarang, Harga As Variant
TxtTHTerbit.Text = “20” & Right(CboKode.Text, 2)
Kode = CboKode
KodeBuku = Mid(Kode, 3, 3)
Select Case KodeBuku
Case “SIM”
Judul = “Sistem Informasi Manajemen”
Pengarang = “Yati Nur Oktavia”
Harga = 75900
Case “EDP”
Judul = “Elektronik Data Processing”
Pengarang = “Imam Tarmizi”
Harga = 62000
Case “MNJ”
Judul = “Manajemen”
Pengarang = “Valentina Mariana Adiwianti”
Harga = 42000
Case “CDR”
Judul = “Corel Draw”
Pengarang = “Riyan Suhandi”
Harga = 53000
Case “RPL”
Judul = “Rekayasa Perangkat Lunak”
Pengarang = “Sinta Umpu Singa”
Harga = 83000
End Select
TxtJudul = Judul
TxtPengarang = Pengarang
TxtHarga = Harga
KodePenerbit = Left(Kode, 1)
Select Case KodePenerbit
Case “A”
Penerbit = “Andi Offset Yogyakarta”
Case “I”
Penerbit = “Indah Surabaya”
Case “S”
Penerbit = “Indah Surabaya”
Case “E”
Penerbit = “Elek Media Komputindo”
Case “M”
Penerbit = “Maxicom”
End Select
TxtPenerbit = Penerbit
End Sub
Private Sub CMDSAVE_Click()
Adodc1.Recordset.Save
End Sub
Private Sub Form_Load()
CboKode.AddItem “A-SIM-01”
CboKode.AddItem “I-EDP-02”
CboKode.AddItem “S-MNJ-03”
CboKode.AddItem “E-CDR-04”
CboKode.AddItem “M-RPL-05”
End Sub
SCREENSHOOT
- TUGAS ENTRI PENJUALAN KOMPUTER
Private Sub CboKode_Click()
Dim kode, jk, hs As Variant
kode = CboKode
Select Case kode
Case “P205”
jk = “Pentium II 500 Mega Hz”
hs = 1500000
Case “P308”
jk = “Pentium III 800 Mega Hz”
hs = 2100000
Case “P310”
jk = “Pentium III 1.0 Giga Hz”
hs = 3500000
Case “P415”
jk = “Pentium IV 1.5 Giga Hz”
hs = 4000000
Case “P417”
jk = “Pentium IV 1.7 Giga Hz”
hs = 4200000
Case “P419”
jk = “Pentium IV 1.9 Giga Hz”
hs = 5500000
End Select
TxtJenisKomputer = jk
TxtHargaSatuan = hs
TxtJumlahJual.SetFocus
End Sub
Private Sub CMDADD_Click()
Adodc1.Recordset.addnew
End Sub
Private Sub CMDCANCEL_Click()
Adodc1.Recordset.Cancel
End Sub
Private Sub CMD4_Click(index As Integer)
Unload Me
End Sub
Private Sub CMDSAVE_Click()
Adodc1.Recordset.Update
End Sub
Private Sub CmdLagi_Click()
CboKode.SetFocus
CboKode.Text = “Pilih Kode Komputer”
TxtJenisKomputer = “”
TxtHargaSatuan = “”
TxtJumlahJual = “”
TxtHargaJual = “”
TxtDiskon = “”
TxtHargaBayar = “”
End Sub
Private Sub CmdProses_Click()
Dim HargaSatuan, Jumlah, Penjualan, Diskon, Bayar As Variant
Jumlah = Val(TxtJumlahJual)
HargaSatuan = Val(TxtHargaSatuan)
Penjualan = HargaSatuan * Jumlah
TxtHargaJual = Penjualan
Select Case Penjualan
Case Is > 30000000
Diskon = Penjualan * 0.15
Case Is > 25000000
Diskon = Penjualan * 0.1
Case Is > 20000000
Diskon = Penjualan * 0.05
Case Is > 15000000
Diskon = Penjualan * 0.02
Case Is <= 150000000
Diskon = Penjualan * 0
End Select
TxtDiskon = Diskon
Bayar = Penjualan – Diskon
TxtHargaBayar = Bayar
End Sub
Private Sub Form_Load()
CboKode.AddItem “P205”
CboKode.AddItem “P308”
CboKode.AddItem “P310”
CboKode.AddItem “P415”
CboKode.AddItem “P417”
CboKode.AddItem “P419”
End Sub
SCREENSHOOT
- TUGAS ENTRI PENJUALAN LAPTOP APEL
Private Sub CboKode_Click()
Dim Merk, Harga, Kode As Variant
Kode = Mid(CboKode.Text, 7, 5)
Select Case Kode
Case “MC965”
Merk = “Apple MC965 MacBook Air”
Harga = 12800000
Case “MC966”
Merk = “Apple MC966 MacBook Air”
Harga = 15800000
Case “MC968”
Merk = “Apple MC968 MacBook Air”
Harga = 9900000
Case “MC969”
Merk = “Apple MC969 MacBook Air”
Harga = 11900000
Case “MC700”
Merk = “Apple MC700 MacBook Pro”
Harga = 10800000
Case “MC721”
Merk = “Apple MC721 MacBook Pro”
Harga = 15900000
Case “MC723”
Merk = “Apple MC723 MacBook Pro”
Harga = 19300000
Case “MC724”
Merk = “Apple MC724 MacBook Pro”
Harga = 13700000
Case “MC311”
Merk = “Apple MC311 MacBook Pro”
Harga = 24200000
Case “MC313”
Merk = “Apple MC313 MacBook Pro”
Harga = 11900000
Case “MC314”
Merk = “Apple MC314 MacBook Pro”
Harga = 14700000
Case “MC318”
Merk = “Apple MC318 MacBook Pro”
Harga = 17600000
Case “MC322”
Merk = “Apple MC322 MacBook Pro”
Harga = 21300000
End Select
TxtMerk = Merk
TxtHarga = Harga
End Sub
Private Sub CMDKELUAR_Click()
Unload Me
End Sub
Private Sub CmdLagi_Click()
CboKode.SetFocus
CboKode.Text = “Pilih Kode Laptop”
TxtMerk.Text = “”
TxtHarga.Text = “”
TxtJual.Text = “”
TxtHargaJual.Text = “”
TxtDiskon.Text = “”
TxtTotal.Text = “”
End Sub
Private Sub CmdProses_Click()
Dim HS, Jual, Jumlah, Diskon, Total As Variant
HS = Val(TxtHarga)
Jual = Val(TxtJual)
Jumlah = HS * Jual
TxtHargaJual = Jumlah
Select Case Jumlah
Case Is > 140000000
Diskon = Jumlah * 0.15
Case Is > 135000000
Diskon = Jumlah * 0.1
Case Is > 130000000
Diskon = Jumlah * 0.05
Case Is > 125000000
Diskon = Jumlah * 0.02
Case Is <= 125000000
Diskon = Jumlah * 0
End Select
TxtDiskon = Diskon
Total = Jumlah – Diskon
TxtTotal = Total
End Sub
Private Sub Form_Load()
CboKode.AddItem “Apple MC965 MacBook Air”
CboKode.AddItem “Apple MC966 MacBook Air”
CboKode.AddItem “Apple MC968 MacBook Air”
CboKode.AddItem “Apple MC969 MacBook Air”
CboKode.AddItem “Apple MC700 MacBook Pro”
CboKode.AddItem “Apple MC721 MacBook Pro”
CboKode.AddItem “Apple MC723 MacBook Pro”
CboKode.AddItem “Apple MC724 MacBook Pro”
CboKode.AddItem “Apple MC311 MacBook Pro”
CboKode.AddItem “Apple MC313 MacBook Pro”
CboKode.AddItem “Apple MC314 MacBook Pro”
CboKode.AddItem “Apple MC318 MacBook Pro”
CboKode.AddItem “Apple MC322 MacBook Pro”
End Sub
Private Sub CMD4_Click(index As Integer)
Unload Me
End Sub
Private Sub CMDADD_Click()
Adodc1.Recordset.AddNew
End Sub
Private Sub CMDCANCEL_Click()
Adodc1.Recordset.Cancel
End Sub
Private Sub CMDSAVE_Click()
Adodc1.Recordset.Save
End Sub
SCREENSHOOT
- PULANG PETANG
Private Sub CmdBatal_Click()
TxtNama.SetFocus
TxtNama = “”
TxtNik = “”
TxtGolongan = “”
TxtKodeStatus = “”
TxtStatus = “”
TxtTahun = “”
TxtJabatan = “”
TxtBagian = “”
TxtGajiPokok = “”
TxtTunjangan = “”
TxtTotalGaji = “”
End Sub
Private Sub CmdKeluar_Click()
Unload Me
End Sub
Private Sub CmdLagi_Click()
TxtNama.SetFocus
TxtNama = “”
TxtNik = “”
TxtGolongan = “”
TxtKodeStatus = “”
TxtStatus = “”
TxtTahun = “”
TxtJabatan = “”
TxtBagian = “”
TxtGajiPokok = “”
TxtTunjangan = “”
TxtTotalGaji = “”
End Sub
Private Sub CmdProses_Click()
Dim Golongan, KodeBagian, KodeStatus, Status, Tahun, Jabatan, Bagian, GajiPokok, Tunjangan As Variant
Golongan = Mid(TxtNik.Text, 6, 1)
TxtGolongan = Golongan
KodeStatus = Mid(TxtNik.Text, 8, 1)
TxtKodeStatus = KodeStatus
If KodeStatus = “S” Then
Status = “Single”
ElseIf KodeStatus = “M” Then
Status = “Menikah”
ElseIf KodeStatus = “J” Then
Status = “Janda”
ElseIf KodeStatus = “D” Then
Status = “Duda”
End If
TxtStatus = Status
Tahun = Left(TxtNik.Text, 4)
TxtTahun = Tahun
Select Case Golongan
Case “A”
Jabatan = “Manager”
GajiPokok = 4000000
Tunjangan = 1025000
Case “B”
Jabatan = “Ka. Seksi”
GajiPokok = 3500000
Tunjangan = 975000
Case “C”
Jabatan = “Staff”
GajiPokok = 3000000
Tunjangan = 925000
End Select
TxtJabatan = Jabatan
TxtGajiPokok = GajiPokok
TxtTunjangan = Tunjangan
KodeBagian = Right(TxtNik.Text, 3)
Select Case KodeBagian
Case “KEU”
Bagian = “Accounting”
Case “ADM”
Bagian = “Administrasi”
Case “SDM”
Bagian = “General Affair”
Case “EDP”
Bagian = “IT Unit”
Case “SPM”
Bagian = “Security”
End Select
TxtBagian = Bagian
TxtTotalGaji = GajiPokok + Tunjangan
End Sub
Private Sub CMDSAVE_Click()
Adodc1.Recordset.Save
End Sub
Private Sub Form_Activate()
TxtNama.SetFocus
End Sub
Private Sub TxtNama_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
TxtNik.SetFocus
End If
End Sub
Private Sub CMDADD_Click()
Adodc1.Recordset.AddNew
End Sub
Private Sub CMDCANCEL_Click()
Adodc1.Recordset.Delete
End Sub
Private Sub CMD4_Click(index As Integer)
Unload Me
End Sub
SCREENSHOOT
- KERETA API
Private Sub CmdKeluar_Click()
Unload Me
End Sub
Private Sub CmdLagi_Click()
TxtKt.SetFocus
TxtKt = “”
TxtHt = “”
TxtJk = “”
TxtJb = “”
TxtJt = “”
TxtTotal = “”
End Sub
Private Sub CmdProses_Click()
Dim Kode, Harga, Jenis, Berangkat As Variant
Kode = Left(TxtKt.Text, 3)
Select Case Kode
Case “BIM”
Harga = 50000
Jenis = “BIMA”
Berangkat = “16.00”
Case “EKO”
Harga = 35000
Jenis = “EKONOMI”
Berangkat = “19.00”
Case “MUT”
Harga = 23000
Jenis = “MUTIARA”
Berangkat = “17.00”
Case “SEN”
Harga = 15000
Jenis = “SENJA”
Berangkat = “20.00”
End Select
TxtHt = Harga
TxtJk = Jenis
TxtJb = Berangkat
TxtJt.SetFocus
End Sub
Private Sub Command1_Click()
Adodc1.Recordset.AddNew
End Sub
Private Sub Command3_Click()
Adodc1.Recordset.MoveLast
End Sub
Private Sub Command4_Click()
Unload Me
End Sub
Private Sub TxtJt_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
TxtTotal = Val(TxtHt.Text) * Val(TxtJt.Text)
End If
End Sub
SCREENSHOOT
- APLIKASI DATA BUKU
Private Sub CmdBatal_Click()
CboKode.SetFocus
CboKode = “Pilih Kode Buku”
TxtJudul = “”
TxtPengarang = “”
TxtTerbit = “”
TxtPenerbit = “”
TxtHarga = “”
End Sub
Private Sub CmdKeluar_Click()
Unload Me
End Sub
Private Sub CmdLagi_Click()
CboKode.SetFocus
CboKode = “Pilih Kode Buku”
TxtJudul = “”
TxtPengarang = “”
TxtTerbit = “”
TxtPenerbit = “”
TxtHarga = “”
End Sub
Private Sub CmdProses_Click()
Dim Kode, KodeBuku, KodePenerbit, KodeTahun, Tahun, Penerbit, Judul, Pengarang, Harga As Variant
Kode = CboKode
KodeBuku = Left(Kode, 3)
Select Case KodeBuku
Case “SIM”
Judul = “Sistem Informasi Manajemen”
Pengarang = “Fadiya Ulfa”
Harga = 75900
Case “EDP”
Judul = “Elektronik Data Processing”
Pengarang = “Nurul Agustina”
Harga = 62000
Case “MNJ”
Judul = “Manajemen”
Pengarang = “Rian Hidayat”
Harga = 42000
Case “CDR”
Judul = “Corel Draw”
Pengarang = “Siti Nur Khotimah”
Harga = 53000
Case “RPL”
Judul = “Rekayasa Perangkat Lunak”
Pengarang = “Winda Erlianti”
Harga = 83000
End Select
TxtJudul = Judul
TxtPengarang = Pengarang
TxtHarga = Harga
KodePenerbit = Right(Kode, 1)
Select Case KodePenerbit
Case “A”
Penerbit = “Andi Offset Yogyakarta”
Case “I”
Penerbit = “Indah Surabaya”
Case “S”
Penerbit = “Indah Surabaya”
Case “E”
Penerbit = “Elek Media Komputindo”
Case “M”
Penerbit = “Maxicom”
End Select
TxtPenerbit = Penerbit
KodeTahun = Mid(Kode, 5, 2)
Select Case KodeTahun
Case “09”
Tahun = “20” & KodeTahun
Case “10”
Tahun = “20” & KodeTahun
Case “11”
Tahun = “20” & KodeTahun
Case “12”
Tahun = “20” & KodeTahun
Case “13”
Tahun = “20” & KodeTahun
End Select
TxtTerbit = Tahun
End Sub
Private Sub Command1_Click()
Adodc1.Recordset.AddNew
End Sub
Private Sub Command2_Click()
Adodc1.Recordset.Delete
End Sub
Private Sub Command3_Click()
Adodc1.Recordset.Save
Adodc1.Recordset.MoveLast
End Sub
Private Sub Command4_Click()
Unload Me
End Sub
Private Sub Form_Load()
CboKode.AddItem “SIM-09-A”
CboKode.AddItem “EDP-10-I”
CboKode.AddItem “MNJ-11-S”
CboKode.AddItem “CDR-12-E”
CboKode.AddItem “RPL-13-M”
End Sub
SCREENSHOOT