modul basic programing with visual basic 6japikinfo.com/downlot.php?file=modul basic...
TRANSCRIPT
Modul Basic Programing
With Visual Basic 6.0
Disusun Oleh : Aririk Japik, S.Kom
2 Copyright © by : japikinfo.com all right reserved
A. Rancangan Database :
Nama Database :dbtoko
Tabel Merk
Field Type Ukuran
Kode_merk Text 10
Merk_Barang Text 30
Tabel Jenis
Field Type Ukuran
Kode_Jenis Text 10
Jenis_Barang Text 30
Tabel Barang
Field Type Ukuran
Kode_Merk Text 10
Merk_Barang Text 30
Jenis_Barang Text 30
Nama_Barang Text 50
Harga Currency -
Satuan Text 12
Stok Number 4
Buat Database di Ms. Access lalu Publish ke versi 2002-2003 dengan cara :
Klik Save as Access 2002-2003 lalu simpan (untuk Ms. Acces 2007)
Klik Publish Pilih Access 2002-2003 lalu simpan (untuk Ms. Acces 2010)
3 Copyright © by : japikinfo.com all right reserved
B. Rancangan Form :
Form Merk
TxtKode
TxtMB
TbTambah TbSimpan TbKeluar TbCari TbHapus
TbUbah
View Code Merk
'Prosedur untuk database & tabel
Dim Db As Database
Dim RsMerk As Recordset
Sub Koneksi()
Set Db = OpenDatabase(App.Path + "\dbToko.mdb")
Set RsMerk = Db.OpenRecordset ("Merk", dbOpenDynaset)
End Sub
Private Sub Form_Load()
Call NonAktif
Call Koneksi
End Sub
Private Sub TbCari_Click()
Dim CARI As String
4 Copyright © by : japikinfo.com all right reserved
CARI = InputBox("Masukkan Kode Merk", "Cari")
If CARI <> "" Then
RsMerk.FindFirst "Kode_Merk='" & CARI & "'"
If RsMerk.NoMatch Then
MsgBox "Tidak ada kode merk", vbCritical, "Pesan"
Else
TxtKode.Text = RsMerk.Fields(0)
TxtMB = RsMerk.Fields(1)
End If
Else
MsgBox "Anda Mengosongkan Pencarian", vbExclamation, "Pesan"
End If
End Sub
Private Sub TbHapus_Click()
If TxtKode.Text = "" Then
MsgBox "Tidak Ada data yang dihapus", vbExclamation, "Warning"
Else
Dim Hapus As String
Hapus = MsgBox("Yakin Kode" & TxtKode.Text & "Akan Dihapus", vbYesNo
+ vbInformation, "Hapus")
If Hapus = vbYes Then
RsMerk.Delete
MsgBox "Data Merk BERHSIL Dihapus", vbInformation, "Sukses"
TxtKode.Text = ""
TxtMB.Text = ""
Else
MsgBox "Gagal Untuk menghapus", vbExclamation, "info"
End If
End If
End Sub
5 Copyright © by : japikinfo.com all right reserved
Private Sub TbKeluar_Click()
Unload Me
End Sub
Sub Aktif()
TxtMB.Enabled = True
TxtKode.Enabled = True
TbSimpan.Enabled = True
TbHapus.Enabled = True
TbUbah.Enabled = True
TxtKode.SetFocus
End Sub
Sub NonAktif()
TxtMB.Enabled = False
TxtKode.Enabled = False
TbSimpan.Enabled = False
TbHapus.Enabled = False
TbUbah.Enabled = False
End Sub
Private Sub TbSimpan_Click()
If TxtKode.Text = "" Or TxtMB.Text = "" Then
MsgBox "Input Data dengan lengkap",vbCritical, "error"
Else
With RsMerk
.AddNew
.Fields(0) = TxtKode.Text
.Fields(1) = TxtMB.Text
.Update
MsgBox "Data Merk BERHASIL Disimpan", vbInformation, "Sukses"
TxtKode.Text = ""
TxtMB.Text = ""
6 Copyright © by : japikinfo.com all right reserved
TxtKode.SetFocus
End With
End If
End Sub
Private Sub TbTambah_Click()
Call Aktif
End Sub
Private Sub TbUbah_Click()
If TxtKode.Text = "" Or TxtMB.Text = "" Then
MsgBox "Data masih kosong", vbExclamation, "Warning"
Else
With RsMerk
.Edit
.Fields(0) = TxtKode.Text
.Fields(1) = TxtMB.Text
.Update
MsgBox "Data Merk BERHASIL DIedit", vbInformation, "SUKSES"
TxtKode.Text = ""
TxtMB.Text = ""
End With
End If
End Sub
7 Copyright © by : japikinfo.com all right reserved
Form Jenis
TxtKode
TxtJB
TbTambah TbSimpan TbKeluar TbCari TbHapus
TbUbah
View Form Jenis
'Prosedur untuk database & tabel
Dim Db As Database
Dim RsJenis As Recordset
Sub Koneksi()
Set Db = OpenDatabase(App.Path + "\dbToko.mdb")
Set RsJenis = Db.OpenRecordset ("Jenis", dbOpenDynaset)
End Sub
Sub Aktif()
TxtJB.Enabled = True
TxtKode.Enabled = True
TbSimpan.Enabled = True
TbHapus.Enabled = True
TbUbah.Enabled = True
TxtKode.SetFocus
End Sub
8 Copyright © by : japikinfo.com all right reserved
Sub NonAktif()
TxtJB.Enabled = False
TxtKode.Enabled = False
TbSimpan.Enabled = False
TbHapus.Enabled = False
TbUbah.Enabled = False
End Sub
Private Sub Form_Load()
Call Koneksi
Call NonAktif
End Sub
Private Sub TbCari_Click()
Dim CARI As String
CARI = InputBox("Masukkan Kode Jenis", _
"Cari")
If CARI <> "" Then
RsJenis.FindFirst "Kode_Jenis='" & CARI & _
"'"
If RsJenis.NoMatch Then
MsgBox "Tidak ada kode Jenis", _
vbCritical, "Pesan"
Else
TxtKode.Text = RsJenis.Fields(0)
TxtJB = RsJenis.Fields(1)
End If
Else
MsgBox "Anda Mengosongkan Pencarian", _
vbExclamation, "Pesan"
End If
End Sub
9 Copyright © by : japikinfo.com all right reserved
Private Sub TbHapus_Click()
If TxtKode.Text = "" Then
MsgBox "Tidak Ada data yang dihapus", _
vbExclamation, "Warning"
Else
Dim Hapus As String
Hapus = MsgBox("Yakin Kode" & TxtKode.Text & "Akan Dihapus", vbYesNo +
vbInformation, "Hapus")
If Hapus = vbYes Then
RsJenis.Delete
MsgBox "Data Jenis BERHSIL Dihapus", vbInformation, "Sukses"
TxtKode.Text = ""
TxtJB.Text = ""
Else
MsgBox "Gagal Untuk menghapus", vbExclamation, "info"
End If
End If
End Sub
Private Sub TbKeluar_Click()
Unload Me
End Sub
Private Sub TbSimpan_Click()
If TxtKode.Text = "" Or TxtJB.Text = "" Then
MsgBox "Input Data dengan lengkap", vbCritical, "error"
Else
With RsJenis
.AddNew
.Fields(0) = TxtKode.Text
.Fields(1) = TxtJB.Text
.Update
MsgBox "Data Jenis BERHASIL Disimpan", vbInformation, "Sukses"
TxtKode.Text = ""
TxtJB.Text = ""
10 Copyright © by : japikinfo.com all right reserved
TxtKode.SetFocus
End With
End If
End Sub
Private Sub TbTambah_Click()
Call Aktif
End Sub
Private Sub TbUbah_Click()
If TxtKode.Text = "" Or TxtJB.Text = "" Then
MsgBox "Data masih kosong", vbExclamation,"Warning"
Else
With RsJenis
.Edit
.Fields(0) = TxtKode.Text
.Fields(1) = TxtJB.Text
.Update
MsgBox "Data Jenis BERHASIL DIedit", vbInformation, "SUKSES"
TxtKode.Text = ""
TxtJB.Text = ""
End With
End If
End Sub
11 Copyright © by : japikinfo.com all right reserved
Form Barang Form barang berfungsi untuk menginput data barang dimana merk dan jenis barang
diambil dari tabel merk dan tabel jenis.
txtKobar
cmbMerk
cmbJenis
txtnabar
txtharga
cmbsatuan
txtstok
TbTambah TbSimpan TbHapus TbUbah TbCari TbKeluar
View Code Barang
Dim Db As Database
Dim RsBarang As Recordset
Dim RsMerk As Recordset
Dim RsJenis As Recordset
Private Sub Form_Load()
Set Db = OpenDatabase(App.Path + "\dbtoko.mdb")
Set RsBarang = Db.OpenRecordset("Barang", dbOpenDynaset)
Set RsMerk = Db.OpenRecordset("Merk", dbOpenDynaset)
Set RsJenis = Db.OpenRecordset("Jenis", dbOpenDynaset)
'Memamanggil Nama Merk Barang
Call TampilMerk
12 Copyright © by : japikinfo.com all right reserved
Call TampilJenis
Call Satuan
Call Non_Aktif
End Sub
Sub TampilMerk()
With RsMerk
CmbMerk.Clear
Do Until .EOF
CmbMerk.AddItem .Fields(1)
.MoveNext
Loop
.MoveFirst
End With
End Sub
Sub TampilJenis()
With RsJenis
CmbJenis.Clear
Do Until .EOF
CmbJenis.AddItem .Fields(1)
.MoveNext
Loop
.MoveFirst
End With
End Sub
Private Sub TbBatal_Click()
Call Non_Aktif
End Sub
Private Sub TbCari_Click()
Dim CARI As String
CARI = InputBox("Masukkan Kode Barang", "Cari")
If CARI <> "" Then
13 Copyright © by : japikinfo.com all right reserved
RsBarang.FindFirst "Kode_Barang='" & CARI & "'"
If RsBarang.NoMatch Then
MsgBox "Kode Barang Tidak Ada", vbCritical, "Pesan"
Else
TxtKobar.Text = RsBarang.Fields(0)
CmbMerk.Text = RsBarang.Fields(1)
CmbJenis.Text = RsBarang.Fields(2)
TxtNabar.Text = RsBarang.Fields(3)
TxtHarga.Text = RsBarang.Fields(4)
cmbSatuan.Text = RsBarang.Fields(5)
txtStok.Text = RsBarang.Fields(6)
End If
Else
MsgBox "Anda Mengosongkan Pencarian", _
vbExclamation, "Pesan"
End If
End Sub
Private Sub TbCariJenis_Click()
Form_Jenis.Show
End Sub
Private Sub TbCariMerk_Click()
Form_Merk.Show
End Sub
Sub Satuan()
cmbSatuan.AddItem "pcs"
cmbSatuan.AddItem "unit"
cmbSatuan.AddItem "pack"
cmbSatuan.AddItem "buah"
End Sub
14 Copyright © by : japikinfo.com all right reserved
Private Sub TbHapus_Click()
Dim Hapus As String
Hapus = MsgBox("Yakin akan menghapus Kode Barang " _
& TxtKobar.Text & " ini", vbYesNo + vbInformation, _
"Hapus")
If Hapus = vbYes Then
RsBarang.Delete
MsgBox "Data Barang Berhasil dihapus", _
vbInformation, "Pesan"
Call Bersih
Else
MsgBox "Batal Menghapus", vbInformation, "Hapus"
End If
End Sub
Private Sub TbKeluar_Click()
Unload Me
End Sub
Private Sub TbSimpan_Click()
If TxtKobar.Text = Empty Or CmbMerk.Text = Empty Or CmbJenis.Text = Empty Or
TxtNabar.Text = Empty Or TxtHarga.Text = Empty Or cmbSatuan.Text = Empty
Then
MsgBox "Input data dengan lengkap", vbCritical, "Error"
Else
With RsBarang
.AddNew
.Fields(0) = TxtKobar.Text
.Fields(1) = TxtNabar.Text
.Fields(2) = CmbMerk.Text
.Fields(3) = CmbJenis.Text
.Fields(4) = TxtHarga.Text
.Fields(5) = cmbSatuan.Text
.Fields(6) = txtStok.Text
.Update
15 Copyright © by : japikinfo.com all right reserved
MsgBox "Data Barang Berhasil disimpan", vbInformation, "Sukses"
Call Bersih
End With
End If
End Sub
Sub Bersih()
TxtKobar.Text = Empty
CmbMerk.Text = Empty
CmbJenis.Text = Empty
TxtNabar.Text = Empty
TxtHarga.Text = Empty
cmbSatuan.Text = Empty
txtStok.Text = Empty
End Sub
Sub Aktif()
TxtKobar.Enabled = True
CmbMerk.Enabled = True
CmbJenis.Enabled = True
TxtNabar.Enabled = True
TxtHarga.Enabled = True
cmbSatuan.Enabled = True
txtStok.Enabled = True
TbSimpan.Enabled = True
TbUbah.Enabled = True
TbHapus.Enabled = True
TxtKobar.SetFocus
End Sub
Sub Non_Aktif()
TxtKobar.Enabled = False
CmbMerk.Enabled = False
CmbJenis.Enabled = False
16 Copyright © by : japikinfo.com all right reserved
TxtNabar.Enabled = False
TxtHarga.Enabled = False
cmbSatuan.Enabled = False
txtStok.Enabled = False
'Untuk Tombol
TbSimpan.Enabled = False
TbUbah.Enabled = False
TbHapus.Enabled = False
End Sub
Private Sub TbTambah_Click()
Call Aktif
End Sub
Private Sub TbUbah_Click()
If TxtKobar.Text = Empty Or TxtNabar.Text = Empty Then
MsgBox "Data Barang masih kosong", vbCritical, "error"
Else
With RsBarang
.Edit
.Fields(0) = TxtKobar.Text
.Fields(1) = TxtNabar.Text
.Fields(2) = CmbMerk.Text
.Fields(3) = CmbJenis.Text
.Fields(4) = TxtHarga.Text
.Fields(5) = cmbSatuan.Text
.Fields(6) = txtStok.Text
.Fields(7) = TxtKet.Text
.Update
MsgBox "Data Barang BERHASIL di Ubah", vbInformation, "Ubah"
Call Bersih
End With
End If
End Sub
17 Copyright © by : japikinfo.com all right reserved
Menu Utama
Menu utama berfungsi untuk memanggil semua form dalam ksebuah
project
TbMerk
TbJenis
TbBarang
TbExit
Sub Aktif()
Frame1.Visible = True
End Sub
Sub NonAktif()
Frame1.Visible = False
End Sub
Private Sub Form_Load()
Call NonAktif
End Sub
Private Sub TbBarang_Click()
Barang.Show
18 Copyright © by : japikinfo.com all right reserved
End Sub
Private Sub TbExit_Click()
End
End Sub
Private Sub TbJenis_Click()
Call Jenis.Show
End Sub
Private Sub TbMenu_Click()
Call Aktif
End Sub
Private Sub TbMerk_Click()
Merk.Show
End Sub