makalah aplikasi inventaris

APLIKASI INVENTARIS

MAKALAH

Disusun untuk melengkapi tugas

Mata kuliah Pemrograman Database (VB.Net 2005)

Dosen Sri Kuswayati, S.Si.

Oleh

Tri Cahyo Prasetyo

104060036

STMIK JABAR SEKOLAH TINGGI MANAJEMEN INFORMATIKA DAN KOMPUTER

JAWA BARAT

Jl. Soekarno-Hatta No. 775-777 Telp.Fax. (022)7335108, 73474775 Bandung 40293

Jl. Cisaranten Kulon No. 140 Soekarno – Hatta Bandung 40293

http://www.stmik-jabar.ac.id email: [email protected]

mailto:[email protected]

KATA PENGANTAR

Puji dan syukur kita panjatkan kehadirat Tuhan Yang Maha Esa, karena berkat rahmat

dan hidayah Nya penulis dapat menyelesaikan makalah ini dengan Teknik Pemrograman

Objek dengan Visual Studio 2005 yang berjudul ´PROGRAM APLIKASI PENGGAJIAN .́

Penyelesaian makalah ini tidak terlepas dari bantuan berbagai pihak. Oleh karena itu

dengan kerendahan hati penulis mengucapkan terima kasih kepada :

1. Dosen pembimbing yang telah banyak memberi saran dan masukan tentang tugas.

2. Kedua orang tua yang mendukung baik secara moril maupun materil.

3. Sahabat penulis yang selalu menyemangati dan selalu menemani disaat

penulis

membutuhkan dukungan.

Penulis menyadari masih banyak kekurangan dan masih jauh dari kesempurnaan

dalam makalah yang penulis buat ini, untuk itu penulis mengharapkan kritik dan saran dari

teman- teman untuk menyempurnakan makalah ini.

Semoga Makalah ini bermanfaat bagi pembaca sekalian.

Bandung, 17 Juni 2012

Tri Cahyo Prasetyo

BAB I

PENDAHULUAN

A. Latar belakang

Microsoft berkonsentrasi dalam mengembangkan Microsoft .NET Framework

2.0, dan tentunya alat bantu untuk membangun program di atasnya. Hingga pada

tahun 2005, mereka pun merilis versi terbaru dari Visual Basic.NET, yang kali ini

disebut dengan Visual Basic 2005 (dengan membuang kata ".NET"),

bersama sama dengan beberapa aplikasi pengembangan lainnya.

Untuk rilis 2005 ini, Microsoft menambahkan beberapa fitur baru, di antaranya

adalah:

a. Edit and Continue

Fitur ini sebelumnya terdapat di dalam Visual Basic akan tetapi dihapus di dalam

Visual Basic .NET. Dengan keberadaan fitur ini, para programmer dapat

memodifikasi kode pada saat program dieksekusi dan melanjutkan proses

eksekusi dengan kode yang telah dimodifikasi tersebut. Evaluasi ekspresi pada

saat waktu desain.

b. Munculnya Pseudo-NameSpace "My", yang menyediakan:

o Akses yang mudah terhadap beberapa area tertentu dari dalam

.NET Framework yang tanpanya membutuhkan kode yang sangat signifikan.

o Kelas-kelas yang dibuat secara dinamis (khususnya My.Forms).

c. Peningkatan yang dilakukan terhadap konverter kode sumber dari Visual

Basic ke Visual Basic .NET.

d. Penggunaan kata kunci (keyword) Using, yang menyederhanakan penggunaan

objek- objek yang membutuhkan pola Dispose untuk membebaskan sumber daya

yang sudah tidak terpakai.

e. Just My Code, yang menyembunyikan kode reusable yang ditulis oleh alat

bantu Intergrated Development Environment (IDE) Visual Studio .NET.

f. Pengikatan sumber data (Data Source binding), yang mampu

mempermudah pengembangan aplikasi Basis Data berbasis Klien/Server.

Fungsi- fungsi yang tersebut di atas (khususnya My) ditujukan untuk

memfokuskan Visual Basic .NET sebagai sebuah platform pengembangan

aplikasi secara cepat dan "menjauhkannya" dari bahasa C#.

B . Manfaat

o Memberi informasi kepada pembaca mengenai bahasa pemrograman Visual

Basic

o Makalah ini diharapkan menjadi sumbangan pemikiran bagi para

pembaca untuk mengembangkan bahasa pemrograman dimasa sekarang.

C . Tujuan

o Untuk memenuhi tugas Tehnik Pemrograman.

o Untuk memberi pengetahuan kepada pembaca tentang bahasa pemograman

Visual Basic 2005.

BAB II

PERANCANGAN PROGRAM

Pembahasan

1.1 Definisi Sistem Operasi

Sistem informasi dapat didefinisikan sebagai suatu kumpulan data yang sudah

diolah, terintegrasi dan saling melengkapi yang menghasilkan informasi

yang mempunyai nilai atau berguna dalam pengambilan keputusan. Sistem

informasi akuntansi pada aplikasi ini merupakan sistem informasi yang

memproses data transaksi bisnis sehingga menghasilkan keluaran berupa informasi

keuangan yang berguna bagi pemakainya.

1.2 Pengertian Visual Basic 2005

Visual Basic 2005 adalah salah satu bahasa pemrograman yang

ditargetkan dalam .NET Framework. Seperti bahasa sehari-hari, Visual Basic

memiliki sintaks dan beberapa kata-kata yang valid yang bisa digunakan dalam

membuat aplikasi. Visual Basic merupakan pilihan yang populer bagi yang mulai

belajar pemrograman karena sintaks penulisan kodenya begitu mudah

dibandingkan dengan bahasa pemrograman yang lain.

1.3 Kelebihan dan kekurangan Visual Basic 2005

Kelebihan :

1. Pengguna dengan dasar pemrograman apapun bisa dengan

mudah menggunakan.

2. Ketika kita melakukan instalasi program lain yang mendukung

penggunaannya dalam VB, maka komponen dari program tersebut bisa di

masukkan dalam daftar komponen VB.

3. Ketika kita melakukan kesalahan penulisan kode, VB secara

otomatis memberitahuinya dan tidak perlu bersusah oayah mencarinya

lagi dalam list code.

Kekurangan :

1. Sifat Komersial.

2. File VB sering menjadi target serangan virus.

3. Dokumentasi sebenarnya lengkap dalam MSDN, namun untuk instalasi

MSDN membutuhkan biaya dan space hardisk yang besar.

1.4 Pengertian Microsoft Access 2000

Microsoft Access merupakan salah satu software pengolah database yang

berjalan dibawah sistem windows. Microsoft Access merupakan salah satu

produk Office dari Microsoft yang dapat menangani database dengan skala

besar maupun kecil. Dalam pengolahan database, Microsoft Access ini memiliki

sarana atau objek- objek yang dapat mempermudah pekerjaan bagi pengguna.

Microsoft Access 2000 yang untuk selanjutnya disingkat Access

2000 merupakan salah satu program aplikasi basis data (database) paling

lengkap dan canggih untuk saat ini, yang digunakan untuk merancang, membuat

dan mengelola database secara lebih mudah. Software Access 2000 pada

umumnya tergabung dalam paket software Microsoft Office 2000 yang tersimpan

dalam CD-ROM.

1.5 Kelebihan dan Kekurangan Microsoft Access 2000

Kelebihan :

Salah satu keunggulan Microsoft Access dilihat dari perspektif programmer

adalah kompatibilitasnya dengan bahasa pemrograman Structured Query

Language (SQL). Para pengguna dapat mencampurkan dan menggunakan kedua jenis

bahasa tersebut (VBA dan Macro) untuk memprogram form dan logika dan juga

untuk mengaplikasikan konsep berorientasi objek.

Kekurangan :

Microsoft Access kurang begitu bagus jika diakses melalui jaringan sehingga

aplikasi-aplikasi yang digunakan oleh banyak pengguna cenderung menggunakan

solusi sistem manajemen basis data yang bersifat klien atau server.

2.1 Rancangan Database

Nama Database : Database.mdb

2.1.1 Tabel login

2.1.2 Tabel Pemegang

2.1.3 Tabel Aset Non Bergerak

2.1.4 Tabel Aset Bergerak

2.1.5 Tabel Rekap Aset Bergerak

2.1.6 Tabel Aset Rekap Non Bergerak

2.1.7 Tabel Rekap Aset Komputer

2.1.8 Tabel Kontrol Komputer

2.1.9 Tabel Kontrol Aset Kandaraan

2.10 Tabel Relationship Diagram

2.2 Racangan Aplikasi

Berikut adalah rancangan aplikasi dari “Aplikasi inventaris”

2.2.1 Splash screen

Source Code Splash Screen:

Public NotInheritable Class Opening

Private Sub Opening_Load(ByVal sender As Object, ByVal e As

System.EventArgs) Handles Me.Load

Timer1.Start()

End Sub

Private Sub Timer1_Tick_(ByVal sender As System.Object, ByVal e

As System.EventArgs) Handles Timer1.Tick

If ProgressBar1.Value < 100 Then

ProgressBar1.Value += 5

ElseIf ProgressBar1.Value = 100 Then

Timer1.Stop()

Me.Hide()

HOME.Show()

End If

End Sub

End Class

2.2.2 Form Login

Source Code Form Login:

Imports System.Data.OleDb

Public Class LOGIN

Private Sub Login_Load(ByVal sender As System.Object, ByVal e As

System.EventArgs) Handles MyBase.Load

Call Koneksi()

End Sub

Sub bersih()

userlogin.Text = ""

passlogin.Text = ""

End Sub

Private Sub OK_Click(ByVal sender As System.Object, ByVal e As

System.EventArgs) Handles OK.Click

If userlogin.Text = "" Or passlogin.Text = "" Then

MsgBox("Mohon untuk melengkapi semuanya")

userlogin.Focus()

Else

cmd = New OleDbCommand("select * from formpassuser where

Nama = '" & userlogin.Text & "' and Pasword = '" & passlogin.Text &

"'", con)

rd = cmd.ExecuteReader

rd.Read()

If rd.HasRows Then

Me.Visible = False

HOME.Show()

HOME.panel1.Text = rd.Item("Nama")

HOME.panel2.Text = rd.Item("Status")

If HOME.panel2.Text <> "ADMIN" Then

HOME.PilihanToolStripMenuItem.Enabled = False

HOME.KontrolAsetToolStripMenuItem.Enabled =

False

Else

HOME.PilihanToolStripMenuItem.Enabled = True

HOME.KontrolAsetToolStripMenuItem.Enabled = True

End If

Else

MsgBox("Password Atau Username Salah,Silakan

Ulangi")

userlogin.Focus()

bersih()

End If

End If

End Sub

Private Sub Cancel_Click(ByVal sender As System.Object, ByVal e

As System.EventArgs) Handles Cancel.Click

Me.Close()

End Sub

End Class

2.2.3 Form Menu Utama

Source Code Menu Utama:

Imports System.Windows.Forms

Public Class HOME

Private Sub ShowNewForm(ByVal sender As Object, ByVal e As

EventArgs)

' Create a new instance of the child form.

Dim ChildForm As New System.Windows.Forms.Form

' Make it a child of this MDI form before showing it.

ChildForm.MdiParent = Me

m_ChildFormNumber += 1

ChildForm.Text = "Window " & m_ChildFormNumber

ChildForm.Show()

End Sub

Private Sub OpenFile(ByVal sender As Object, ByVal e As

EventArgs)

Dim OpenFileDialog As New OpenFileDialog

OpenFileDialog.InitialDirectory =

My.Computer.FileSystem.SpecialDirectories.MyDocuments

OpenFileDialog.Filter = "Text Files (*.txt)|*.txt|All Files

(*.*)|*.*"

If (OpenFileDialog.ShowDialog(Me) =

System.Windows.Forms.DialogResult.OK) Then

Dim FileName As String = OpenFileDialog.FileName

' TODO: Add code here to open the file.

End If

End Sub

Private Sub SaveAsToolStripMenuItem_Click(ByVal sender As

Object, ByVal e As EventArgs)

Dim SaveFileDialog As New SaveFileDialog

SaveFileDialog.InitialDirectory =

My.Computer.FileSystem.SpecialDirectories.MyDocuments

SaveFileDialog.Filter = "Text Files (*.txt)|*.txt|All Files

(*.*)|*.*"

If (SaveFileDialog.ShowDialog(Me) =

System.Windows.Forms.DialogResult.OK) Then

Dim FileName As String = SaveFileDialog.FileName

' TODO: Add code here to save the current contents of

the form to a file.

End If

End Sub

Private Sub ExitToolsStripMenuItem_Click(ByVal sender As Object,

ByVal e As EventArgs)

Global.System.Windows.Forms.Application.Exit()

End Sub

Private Sub CutToolStripMenuItem_Click(ByVal sender As Object,


' Use My.Computer.Clipboard to insert the selected text or

images into the clipboard

End Sub

Private Sub CopyToolStripMenuItem_Click(ByVal sender As Object,


' Use My.Computer.Clipboard to insert the selected text or

images into the clipboard

End Sub

Private Sub PasteToolStripMenuItem_Click(ByVal sender As Object,


'Use My.Computer.Clipboard.GetText() or

My.Computer.Clipboard.GetData to retrieve information from the

clipboard.

End Sub

Private Sub CascadeToolStripMenuItem_Click(ByVal sender As


Me.LayoutMdi(MdiLayout.Cascade)

End Sub

Private Sub TileVerticleToolStripMenuItem_Click(ByVal sender As


Me.LayoutMdi(MdiLayout.TileVertical)

End Sub

Private Sub TileHorizontalToolStripMenuItem_Click(ByVal sender

As Object, ByVal e As EventArgs)

Me.LayoutMdi(MdiLayout.TileHorizontal)

End Sub

Private Sub ArrangeIconsToolStripMenuItem_Click(ByVal sender As


Me.LayoutMdi(MdiLayout.ArrangeIcons)

End Sub

Private Sub CloseAllToolStripMenuItem_Click(ByVal sender As


' Close all child forms of the parent.

For Each ChildForm As Form In Me.MdiChildren

ChildForm.Close()

Next

End Sub

Private m_ChildFormNumber As Integer = 0

Private Sub BergerakToolStripMenuItem_Click(ByVal sender As

System.Object, ByVal e As System.EventArgs) Handles

BergerakToolStripMenuItem.Click

Form6.MdiParent = Me

Form6.Show()

End Sub

Private Sub PemegangToolStripMenuItem_Click(ByVal sender As


PemegangToolStripMenuItem.Click


Form2.Show()

End Sub

Private Sub BergerakToolStripMenuItem1_Click(ByVal sender As


BergerakToolStripMenuItem1.Click


Form3.Show()

End Sub

Private Sub InputUserToolStripMenuItem_Click(ByVal sender As


InputUserToolStripMenuItem.Click


Form4.Show()

End Sub

Private Sub EditPasswordToolStripMenuItem_Click(ByVal sender As


EditPasswordToolStripMenuItem.Click


Form7.Show()

End Sub

Private Sub KomputerToolStripMenuItem_Click(ByVal sender As


KomputerToolStripMenuItem.Click


Form8.Show()

End Sub

Private Sub NonBergerakToolStripMenuItem1_Click(ByVal sender As


NonBergerakToolStripMenuItem1.Click


Form9.Show()

End Sub

Private Sub KomputerToolStripMenuItem1_Click(ByVal sender As


KomputerToolStripMenuItem1.Click


Form10.Show()

End Sub

Private Sub KendaraanToolStripMenuItem_Click(ByVal sender As


KendaraanToolStripMenuItem.Click


Form5.Show()

End Sub

Private Sub NonBergerakToolStripMenuItem_Click(ByVal sender As


NonBergerakToolStripMenuItem.Click


Form1.Show()

End Sub

Private Sub ExitToolStripMenuItem_Click(ByVal sender As


ExitToolStripMenuItem.Click

If MessageBox.Show("Anda yakin ingin Keluar dari Aplikasi?",

"", MessageBoxButtons.YesNo) = Windows.Forms.DialogResult.Yes Then

Form1.Close()

Form2.Close()

Form3.Close()

Form4.Close()

Form5.Close()

Form6.Close()

Form7.Close()

Form8.Close()

Form9.Close()

Form10.Close()

Form11.Close()

LOGIN.Close()

Me.Close()

End If

End Sub




kontrol.ReportFileName = "rekapb.rpt"

kontrol.WindowState =

Crystal.WindowStateConstants.crptMaximized

kontrol.RetrieveDataFiles()

kontrol.Action = 1

End Sub




rekap.ReportFileName = "rekapnb.rpt"

rekap.WindowState =


rekap.RetrieveDataFiles()

rekap.Action = 1

End Sub




rekap.ReportFileName = "asetb.rpt"

rekap.WindowState =



rekap.Action = 1

End Sub




rekap.ReportFileName = "asetnb.rpt"

rekap.WindowState =



rekap.Action = 1

End Sub

Private Sub KendaraanToolStripMenuItem1_Click(ByVal sender As


KendaraanToolStripMenuItem1.Click

kontrol.ReportFileName = "kontrolkend.rpt"




kontrol.Action = 1

End Sub

Private Sub VersionToolStripMenuItem_Click(ByVal sender As


VersionToolStripMenuItem.Click

Form11.Show()

End Sub




kontrol.ReportFileName = "kontrolkom.rpt"




kontrol.Action = 1

End Sub




kontrol.ReportFileName = "rekapkomputer.rpt"




kontrol.Action = 1

End Sub

End Class

2.2.4 Form Aset Bergerak

Source Code Form Aset Bergerak:


Public Class Form1

Dim daaset As OleDb.OleDbDataAdapter

Dim con As New

OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data

Source=C:\Documents and Settings\Tri Cahyo Prasetyo\My

Documents\Visual Studio

2005\Projects\AplikasiSekretariat\AplikasiSekretariat\bin\Debug\Data

base.mdb")

Dim dtaset As New DataTable()

Dim draset As DataRow

Function Koneksi(ByVal strDatabase As String) As String

Dim kalimat As String

kalimat = "Provider=Microsoft.Jet.OLEDB.4.0;Data




base.mdb"

kalimat &= "Data Source=" & strDatabase & ""

Return kalimat

End Function

Sub bersih()

kdaset.Text = ""

jnaset.Text = ""

mraset.Text = ""

sraset.Text = ""

btaset.Text = ""

kdaset.Focus()

End Sub

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As


Dim dc(1) As DataColumn

Try

daaset = New OleDb.OleDbDataAdapter("select * from

formaset", con)

daaset.Fill(dtaset)

dc(0) = dtaset.Columns("Kd_Aset")

dtaset.PrimaryKey = dc

dgaset.DataSource = dtaset

Catch errConn As OleDb.OleDbException

MsgBox(errConn.Message)

End Try

End Sub

Private Sub saveaset_Click(ByVal sender As System.Object, ByVal

e As System.EventArgs) Handles saveaset.Click

If kdaset.Text = "" Or jnaset.Text = "" Or mraset.Text = ""

Or sraset.Text = "" Or btaset.Text = "" Then

MsgBox("Database Belum Lengkap")

kdaset.Focus()

Else

Try

Dim cbTambah As OleDb.OleDbCommandBuilder = New

OleDb.OleDbCommandBuilder(daaset)

draset = dtaset.NewRow()

draset("Kd_Aset") = kdaset.Text

draset("Jenis") = jnaset.Text

draset("Merk") = mraset.Text

draset("Seri") = sraset.Text

draset("Bentuk") = btaset.Text

dtaset.Rows.Add(draset)

con.Open()

daaset.Update(dtaset)

dtaset.AcceptChanges()

con.Close()

MsgBox("database berhasil tersimpan")

Catch errTambah As Exception

MsgBox(errTambah.Message)

End Try

End If

kdaset.Focus()

bersih()

End Sub

Private Sub btlaset_Click(ByVal sender As System.Object, ByVal e

As System.EventArgs) Handles btlaset.Click

kdaset.Text = ""

jnaset.Text = ""

mraset.Text = ""

sraset.Text = ""

btaset.Text = ""

kdaset.Focus()

End Sub

Private Sub craset_Click(ByVal sender As System.Object, ByVal e

As System.EventArgs) Handles craset.Click

Try

draset = dtaset.Rows.Find(kdaset.Text)

kdaset.Text = draset("Kd_Aset").ToString

jnaset.Text = draset("Jenis").ToString

mraset.Text = draset("Merk").ToString

sraset.Text = draset("Seri").ToString

btaset.Text = draset("Bentuk").ToString

MsgBox("Database ditemukan")

Catch errCari As Exception

MsgBox("Database tidak ditemukan")

End Try

End Sub

Private Sub delaset_Click(ByVal sender As System.Object, ByVal e

As System.EventArgs) Handles delaset.Click

If MessageBox.Show("Anda yakin ingin menghapus Database

ini?", "", MessageBoxButtons.YesNo) = Windows.Forms.DialogResult.Yes

Then

Try

Dim cbhapus As OleDb.OleDbCommandBuilder = New


draset.Delete()

daaset.DeleteCommand = cbhapus.GetDeleteCommand



daaset.DeleteCommand.Connection.Close()

MsgBox("Database berhasil dihapus")

Catch errHapus As Exception

MsgBox(errHapus.Message)

End Try

End If

bersih()

kdaset.Focus()

End Sub

Private Sub changeaset_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles changeaset.Click

If MessageBox.Show("Anda yakin untuk mengubah Database


Then

Try

Dim cbEdit As OleDb.OleDbCommandBuilder = New


draset("Kd_Aset") = kdaset.Text

draset("Jenis") = jnaset.Text

draset("Merk") = mraset.Text

draset("Seri") = sraset.Text

draset("Bentuk") = btaset.Text

con.Open()



con.Close()

MsgBox("Database Berhasil Diubah")

Catch errEdit As Exception

MsgBox(errEdit.Message)

End Try

kdaset.Focus()

bersih()

End If

End Sub

End Class

2.2.5 Form Aset Non Bergerak

Source Code Form Aset Bergerak:

Public Class Form6

Dim daasetb As OleDb.OleDbDataAdapter

Dim con As New


Source=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and

Settings\Tri Cahyo Prasetyo\My Documents\Visual Studio


base.mdb")

Dim dtasetb As New DataTable()

Dim drasetb As DataRow







base.mdb"


Return kalimat

End Function

Sub bersih()

kdasetb.Text = ""

jnasetb.Text = ""

mrasetb.Text = ""

srasetb.Text = ""

btasetb.Text = ""

kdasetb.Focus()

End Sub




Try

daasetb = New OleDb.OleDbDataAdapter("select * from

formasetbergerak", con)

daasetb.Fill(dtasetb)

dc(0) = dtasetb.Columns("kd_aset")

dtasetb.PrimaryKey = dc

dgasetb.DataSource = dtasetb



End Try

End Sub

Private Sub saveasetb_Click(ByVal sender As System.Object, ByVal

e As System.EventArgs) Handles saveasetb.Click

If kdasetb.Text = "" Or jnasetb.Text = "" Or mrasetb.Text =

"" Or srasetb.Text = "" Or btasetb.Text = "" Then

MsgBox("Database belum lengkap")

kdasetb.Focus()

Else

Try


OleDb.OleDbCommandBuilder(daasetb)

drasetb = dtasetb.NewRow

drasetb("kd_aset") = kdasetb.Text

drasetb("Jenis_kendaraan") = jnasetb.Text

drasetb("Merk_kendaraan") = mrasetb.Text

drasetb("Model_kendaraan") = srasetb.Text

drasetb("Bentuk_kendaraan") = btasetb.Text

dtasetb.Rows.Add(drasetb)

con.Open()

daasetb.Update(dtasetb)

dtasetb.AcceptChanges()

con.Close()

MsgBox("Database berhasil tersimpan")



End Try

End If

bersih()

kdasetb.Focus()

End Sub

Private Sub btlasetb_Click(ByVal sender As System.Object, ByVal

e As System.EventArgs) Handles btlasetb.Click

kdasetb.Text = ""

jnasetb.Text = ""

mrasetb.Text = ""

srasetb.Text = ""

btasetb.Text = ""

kdasetb.Focus()

End Sub

Private Sub crasetb_Click(ByVal sender As System.Object, ByVal e

As System.EventArgs) Handles crasetb.Click

Try

drasetb = dtasetb.Rows.Find(kdasetb.Text)

kdasetb.Text = drasetb("kd_aset").ToString

jnasetb.Text = drasetb("Jenis_kendaraan").ToString

mrasetb.Text = drasetb("Merk_kendaraan").ToString

srasetb.Text = drasetb("Model_kendaraan").ToString

btasetb.Text = drasetb("Bentuk_kendaraan").ToString

MsgBox("Database berhasil ditemukan")


MsgBox(errCari.Message)

End Try

End Sub

Private Sub delasetb_Click(ByVal sender As System.Object, ByVal

e As System.EventArgs) Handles delasetb.Click



Then

Try



drasetb.Delete()

daasetb.DeleteCommand = cbhapus.GetDeleteCommand



daasetb.DeleteCommand.Connection.Close()




End Try

End If

bersih()

kdasetb.Focus()

End Sub

Private Sub changeasetb_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles changeasetb.Click



Then

Try



drasetb("kd_aset") = kdasetb.Text

drasetb("Jenis_kendaraan") = jnasetb.Text

drasetb("Merk_kendaraan") = mrasetb.Text

drasetb("Model_kendaraan") = srasetb.Text

drasetb("Bentuk_kendaraan") = btasetb.Text

con.Open()



con.Close()




End Try

bersih()

kdasetb.Focus()

End If

End Sub

End Class

2.2.6 Form Rekap Aset Bergerak

Source Code Form Rekap Aset Bergerak:

Public Class Form3

Dim darkp As OleDb.OleDbDataAdapter

Dim daasetb As OleDb.OleDbDataAdapter

Dim dapeg As OleDb.OleDbDataAdapter

Dim con As New





base.mdb")

Dim dtrkp As New DataTable()

Dim dtasetb As New DataTable()

Dim dtpeg As New DataTable()

Dim drrkp As DataRow


Dim drpeg As DataRow

Function Koneksi(ByVal strDatabase As String)






base.mdb"

kalimat &= "" & strDatabase & ""

Return kalimat

End Function




Try

daasetb = New OleDb.OleDbDataAdapter("select * from


daasetb.Fill(dtasetb)

dc(0) = dtasetb.Columns("kd_aset")

dtasetb.PrimaryKey = dc

With kdasetrkp

.DataSource = dtasetb

.DisplayMember = "kd_aset"

.ValueMember = "kd_aset"

End With

dapeg = New OleDb.OleDbDataAdapter("select * from

formpemegang", con)

dapeg.Fill(dtpeg)

dc(0) = dtpeg.Columns("Kd_pemegang")

dtpeg.PrimaryKey = dc

With kdpegangrkp

.DataSource = dtpeg

.DisplayMember = "Kd_pemegang"

.ValueMember = "Kd_pemegang"

End With

darkp = New OleDb.OleDbDataAdapter("select * from

formrekapaset", con)

darkp.Fill(dtrkp)

dc(0) = dtrkp.Columns("Kd_Rekap")

dtrkp.PrimaryKey = dc

dgrkp.DataSource = dtrkp



End Try

End Sub

Private Sub saverkp_Click(ByVal sender As System.Object, ByVal e

As System.EventArgs) Handles saverkp.Click

If norkp.Text = "" Or kdasetrkp.Text = "" Or

kdpegangrkp.Text = "" Or tglrkp.Text = "" Or hrgrkp.Text = "" Or

nopolrkp.Text = "" Or stnkrkp.Text = "" Or mesrkp.Text = "" Or

bpkbrkp.Text = "" Or kondisirkp.Text = "" Then

MsgBox("Rekap belum Lengkap")

norkp.Focus()

Else

Try


OleDb.OleDbCommandBuilder(darkp)

drrkp = dtrkp.NewRow

drrkp("Kd_Rekap") = norkp.Text

drrkp("Kd_Aset") = kdasetrkp.Text

drrkp("Kd_Pemegang") = kdpegangrkp.Text

drrkp("Tgl_Beli") = tglrkp.Text

drrkp("Harga") = hrgrkp.Text

drrkp("Warna") = wrnrkp.Text

drrkp("No_Polisi") = nopolrkp.Text

drrkp("Masa_STNK") = stnkrkp.Text

drrkp("No_Mesin") = mesrkp.Text

drrkp("BPKB") = bpkbrkp.Text

drrkp("Kondisi") = kondisirkp.Text

dtrkp.Rows.Add(drrkp)

con.Open()

darkp.Update(dtrkp)

dtrkp.AcceptChanges()

con.Close()

MsgBox("Rekap berhasil tersimpan")



End Try

End If

norkp.Focus()

kosong()

End Sub

Sub kosong()

norkp.Text = ""

tglrkp.Text = ""

hrgrkp.Text = ""

wrnrkp.Text = ""

nopolrkp.Text = ""

stnkrkp.Text = ""

mesrkp.Text = ""

bpkbrkp.Text = ""

kondisirkp.Text = ""

End Sub

Private Sub changerkp_Click(ByVal sender As System.Object, ByVal

e As System.EventArgs) Handles changerkp.Click

If MessageBox.Show("Anda yakin untuk mengubah Rekap ini?",


Try



drrkp("Kd_Rekap") = norkp.Text

drrkp("Kd_Aset") = kdasetrkp.Text

drrkp("kd_Pemegang") = kdpegangrkp.Text

drrkp("Tgl_Beli") = tglrkp.Text

drrkp("Harga") = hrgrkp.Text

drrkp("Warna") = wrnrkp.Text

drrkp("No_Polisi") = nopolrkp.Text

drrkp("Masa_STNK") = stnkrkp.Text

drrkp("No_Mesin") = mesrkp.Text

drrkp("BPKB") = bpkbrkp.Text

drrkp("Kondisi") = kondisirkp.Text

con.Open()

darkp.Update(dtrkp)


con.Close()




End Try

End If

kosong()

norkp.Focus()

End Sub

Private Sub kdasetrkp_SelectedIndexChanged(ByVal sender As


kdasetrkp.SelectedIndexChanged

Try


drasetb = dtasetb.Rows.Find(kdasetrkp.Text)

jnaset2.Text = drasetb("Jenis_kendaraan").ToString

mraset2.Text = drasetb("Merk_kendaraan").ToString

sraset2.Text = drasetb("Model_kendaraan").ToString

Catch errTampil As Exception

End Try

End Sub

Private Sub kdpegangrkp_SelectedIndexChanged(ByVal sender As


kdpegangrkp.SelectedIndexChanged

Try


drpeg = dtpeg.Rows.Find(kdpegangrkp.Text)

nama2.Text = drpeg("Nama").ToString

jabatan2.Text = drpeg("Jabatan").ToString

struktur2.Text = drpeg("Struktur").ToString


End Try

End Sub

Private Sub cancelrkp_Click(ByVal sender As System.Object, ByVal

e As System.EventArgs) Handles cancelrkp.Click

norkp.Text = ""

tglrkp.Text = ""

hrgrkp.Text = ""

wrnrkp.Text = ""

nopolrkp.Text = ""

stnkrkp.Text = ""

mesrkp.Text = ""

bpkbrkp.Text = ""

kondisirkp.Text = ""

norkp.Focus()

End Sub

Private Sub searchrkp_Click(ByVal sender As System.Object, ByVal

e As System.EventArgs) Handles searchrkp.Click

Try

drrkp = dtrkp.Rows.Find(norkp.Text)

norkp.Text = drrkp("Kd_Rekap").ToString

kdasetrkp.Text = drrkp("Kd_Aset").ToString

kdpegangrkp.Text = drrkp("Kd_Pemegang").ToString

tglrkp.Text = drrkp("Tgl_Beli").ToString

hrgrkp.Text = drrkp("Harga").ToString

wrnrkp.Text = drrkp("Warna").ToString

nopolrkp.Text = drrkp("No_Polisi").ToString

stnkrkp.Text = drrkp("Masa_STNK").ToString

mesrkp.Text = drrkp("No_mesin").ToString

bpkbrkp.Text = drrkp("BPKB").ToString

kondisirkp.Text = drrkp("Kondisi").ToString

MsgBox("Rekap Ditemukan")



End Try

End Sub

Private Sub deleterkp_Click(ByVal sender As System.Object, ByVal

e As System.EventArgs) Handles deleterkp.Click

If MessageBox.Show("Anda yakin untuk menghapus Rekap ini?",


Try



drrkp.Delete()

darkp.DeleteCommand = cbhapus.GetDeleteCommand

darkp.Update(dtrkp)


darkp.DeleteCommand.Connection.Close()

MsgBox("Rekap berhasil dihapus")



End Try

End If

norkp.Focus()

kosong()

End Sub

End Class

2.2.7 Form Rekap Aset Non Bergerak

Source Code Form Rekap Aset Non Bergerak:

Public Class Form9

Dim darekapnb As OleDb.OleDbDataAdapter



Dim con As New





base.mdb")

Dim dtrekapnb As New DataTable()



Dim drrekapnb As DataRow









base.mdb"


Return kalimat

End Function

Private Sub saverekapnb_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles saverekapnb.Click

If kdrekapnb.Text = "" Or kdasetnb.Text = "" Or

hrgrekapnb.Text = "" Or wrrekapnb.Text = "" Or jmlrekapnb.Text = ""

Or ketrekapnb.Text = "" Then


kdrekapnb.Focus()

Else

Try


OleDb.OleDbCommandBuilder(darekapnb)

drrekapnb = dtrekapnb.NewRow

drrekapnb("No_rekap") = kdrekapnb.Text

drrekapnb("Kd_Aset") = kdasetnb.Text

drrekapnb("Kd_pemegang") = kdpegangnb.Text

drrekapnb("Warna") = hrgrekapnb.Text

drrekapnb("Harga") = wrrekapnb.Text

drrekapnb("Jumlah") = jmlrekapnb.Text

drrekapnb("Keterangan") = ketrekapnb.Text

dtrekapnb.Rows.Add(drrekapnb)

con.Open()

darekapnb.Update(dtrekapnb)

dtrekapnb.AcceptChanges()

con.Close()




End Try

End If

kdrekapnb.Focus()

kosong()

End Sub

Sub kosong()

kdrekapnb.Text = ""

hrgrekapnb.Text = ""

wrrekapnb.Text = ""

jmlrekapnb.Text = ""

ketrekapnb.Text = ""

End Sub

Private Sub changerekapnb_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles changerekapnb.Click



Try



drrekapnb("No_rekap") = kdrekapnb.Text

drrekapnb("Kd_Aset") = kdasetnb.Text

drrekapnb("Kd_pemegang") = kdpegangnb.Text

drrekapnb("Harga") = hrgrekapnb.Text

drrekapnb("Warna") = wrrekapnb.Text

drrekapnb("Jumlah") = jmlrekapnb.Text

drrekapnb("Keterangan") = ketrekapnb.Text

con.Open()



con.Close()




End Try

End If

kosong()

kdrekapnb.Focus()

End Sub

Private Sub btlrekapnb_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles btlrekapnb.Click

kosong()

End Sub

Private Sub kdasetnb_SelectedIndexChanged(ByVal sender As


kdasetnb.SelectedIndexChanged

Try


draset = dtaset.Rows.Find(kdasetnb.Text)

mrasetnb.Text = draset("Merk").ToString

srasetnb.Text = draset("Seri").ToString


End Try

End Sub

Private Sub crrekapnb_Click(ByVal sender As System.Object, ByVal

e As System.EventArgs) Handles crrekapnb.Click

Try

drrekapnb = dtrekapnb.Rows.Find(kdrekapnb.Text)

kdrekapnb.Text = drrekapnb("No_rekap").ToString

kdasetnb.Text = drrekapnb("Kd_Aset").ToString

kdpegangnb.Text = drrekapnb("Kd_pemegang").ToString

hrgrekapnb.Text = drrekapnb("Harga").ToString

wrrekapnb.Text = drrekapnb("Warna").ToString

jmlrekapnb.Text = drrekapnb("Jumlah").ToString

ketrekapnb.Text = drrekapnb("Keterangan").ToString




End Try

End Sub

Private Sub delrekapnb_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles delrekapnb.Click



Try



drrekapnb.Delete()

darekapnb.DeleteCommand = cbhapus.GetDeleteCommand



darekapnb.DeleteCommand.Connection.Close()




End Try

End If

kdrekapnb.Focus()

kosong()

End Sub

Private Sub kdpegangnb_SelectedIndexChanged(ByVal sender As


kdpegangnb.SelectedIndexChanged

Try


drpeg = dtpeg.Rows.Find(kdpegangnb.Text)

namanb.Text = drpeg("Nama").ToString


End Try

End Sub




Try


formaset where Bentuk = 'Alat Tulis Kantor'", con)


formaset where Bentuk = 'Rumah Tangga'", con)


formaset where Bentuk = 'Elektronik'", con)

daaset.Fill(dtaset)



With kdasetnb

.DataSource = dtaset

.DisplayMember = "Kd_Aset"

.ValueMember = "Kd_Aset"

End With


formpemegang", con)

dapeg.Fill(dtpeg)



With kdpegangnb

.DataSource = dtpeg



End With

darekapnb = New OleDb.OleDbDataAdapter("select * from

formrekapasetnb", con)

darekapnb.Fill(dtrekapnb)

dc(0) = dtrekapnb.Columns("No_rekap")

dtrekapnb.PrimaryKey = dc

dgrekapnb.DataSource = dtrekapnb



End Try

End Sub

End Class

2.2.8 Form Rekap Komputer

Source Code Form Rekap Komputer:

Public Class Form10




Dim con As New





base.mdb")









kalimat = "Provider=Microsoft.Jet.OLEDB.4.0;"


Return kalimat

End Function




Try


formaset where Bentuk = 'Komputer' ", con)

daaset.Fill(dtaset)



With kdasetkomp




End With


formpemegang", con)

dapeg.Fill(dtpeg)



With kdpegangkomp

.DataSource = dtpeg



End With


form_rekapkomp", con)


dc(0) = dtrekapnb.Columns("no_rekapkomp")


dgkomp.DataSource = dtrekapnb



End Try

End Sub

Sub kosong()

no.Text = ""

kdasetkomp.Text = ""

kdpegangkomp.Text = ""

monitor.Text = ""

keyboard.Text = ""

mouse.Text = ""

vga.Text = ""

sncard.Text = ""

hdd.Text = ""

power.Text = ""

rom.Text = ""

End Sub

Private Sub savekomp_Click(ByVal sender As System.Object, ByVal

e As System.EventArgs) Handles savekomp.Click

If no.Text = "" Or kdasetkomp.Text = "" Or kdpegangkomp.Text

= "" Or monitor.Text = "" Or keyboard.Text = "" Or mouse.Text = ""

Or sncard.Text = "" Or hdd.Text = "" Or power.Text = "" Or rom.Text

= "" Then


no.Focus()

Else

Try




drrekapnb("no_rekapkomp") = no.Text

drrekapnb("kd_aset") = kdasetkomp.Text

drrekapnb("kd_pemegang") = kdpegangkomp.Text

drrekapnb("Monitor") = monitor.Text

drrekapnb("Keyboard") = keyboard.Text

drrekapnb("Mouse") = mouse.Text

drrekapnb("VGA") = vga.Text

drrekapnb("SoundCard") = sncard.Text

drrekapnb("Harddisk") = hdd.Text

drrekapnb("Power_supply") = power.Text

drrekapnb("ROM_drive") = rom.Text


con.Open()



con.Close()




End Try

End If

no.Focus()

kosong()

End Sub

Private Sub cancelkomp_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles cancelkomp.Click

kosong()

End Sub

Private Sub kdasetkomp_SelectedIndexChanged(ByVal sender As


kdasetkomp.SelectedIndexChanged

Try


draset = dtaset.Rows.Find(kdasetkomp.Text)

jnaset1.Text = draset("Jenis").ToString

mraset1.Text = draset("Merk").ToString

sraset1.Text = draset("Seri").ToString


End Try

End Sub

Private Sub changekomp_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles changekomp.Click



Try



drrekapnb("no_rekapkomp") = no.Text

drrekapnb("kd_aset") = kdasetkomp.Text







drrekapnb("Harddisk") = hdd.Text



con.Open()



con.Close()




End Try

End If

kosong()

no.Focus()

End Sub

Private Sub searchkomp_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles searchkomp.Click

Try

drrekapnb = dtrekapnb.Rows.Find(no.Text)

no.Text = drrekapnb("no_rekapkomp").ToString

kdasetkomp.Text = drrekapnb("kd_aset").ToString

kdpegangkomp.Text = drrekapnb("Kd_pemegang").ToString

monitor.Text = drrekapnb("Monitor").ToString

keyboard.Text = drrekapnb("Keyboard").ToString

mouse.Text = drrekapnb("Mouse").ToString

vga.Text = drrekapnb("VGA").ToString

sncard.Text = drrekapnb("SoundCard").ToString

hdd.Text = drrekapnb("Harddisk").ToString

power.Text = drrekapnb("Power_supply").ToString

rom.Text = drrekapnb("ROM_drive").ToString




End Try

End Sub

Private Sub deletekomp_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs)



Try



drrekapnb.Delete()








End Try

End If

no.Focus()

kosong()

End Sub

Private Sub kdpegangkomp_SelectedIndexChanged(ByVal sender As


kdpegangkomp.SelectedIndexChanged

Try


drpeg = dtpeg.Rows.Find(kdpegangkomp.Text)

nama.Text = drpeg("Nama").ToString

jabatan.Text = drpeg("Jabatan").ToString

struktur.Text = drpeg("Struktur").ToString


End Try

End Sub

End Class

2.2.9 Form Input Pemegang Aset

Source Code Form Input Pemegang Aset:

Public Class Form2


Dim con As New





base.mdb")









base.mdb"


Return kalimat

End Function

Sub bersih()

Kdpemegang.Text = ""

namapemegang.Text = ""

jabatan.Text = ""

struktur.Text = ""

alamat.Text = ""

Kdpemegang.Focus()

End Sub

Private Sub form1_Load(ByVal sender As Object, ByVal e As

System.EventArgs) Handles Me.Load


Try


formpemegang", con)

daaset.Fill(dtaset)

dc(0) = dtaset.Columns("Kd_pemegang")


dgpemegang.DataSource = dtaset



End Try

End Sub

Private Sub savepegang_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles savepegang.Click

If Kdpemegang.Text = "" Or namapemegang.Text = "" Or

jabatan.Text = "" Or struktur.Text = "" Or alamat.Text = "" Then

MsgBox("Database belum lengkap")

Kdpemegang.Focus()

Else

Try



draset = dtaset.NewRow

draset("Kd_pemegang") = Kdpemegang.Text

draset("Nama") = namapemegang.Text

draset("Jabatan") = jabatan.Text

draset("Struktur") = struktur.Text

draset("Alamat") = alamat.Text

dtaset.Rows.Add(draset)

con.Open()



con.Close()

MsgBox("Database berhasil tersimpan")



End Try

End If

Kdpemegang.Focus()

bersih()

End Sub

Private Sub btlpegang_Click(ByVal sender As System.Object, ByVal

e As System.EventArgs) Handles btlpegang.Click

Kdpemegang.Text = ""

namapemegang.Text = ""

jabatan.Text = ""

struktur.Text = ""

alamat.Text = ""

Kdpemegang.Focus()

End Sub

Private Sub crpegang_Click(ByVal sender As System.Object, ByVal

e As System.EventArgs) Handles crpegang.Click

Try

draset = dtaset.Rows.Find(Kdpemegang.Text)

Kdpemegang.Text = draset("Kd_pemegang").ToString

namapemegang.Text = draset("Nama").ToString

jabatan.Text = draset("Jabatan").ToString

struktur.Text = draset("Struktur").ToString

alamat.Text = draset("Alamat").ToString

MsgBox("Database ditemukan")


MsgBox("Database tidak ditemukan")

End Try

End Sub

Private Sub delpegang_Click(ByVal sender As System.Object, ByVal

e As System.EventArgs) Handles delpegang.Click



Then

Try



draset.Delete()

daaset.DeleteCommand = cbhapus.GetDeleteCommand



daaset.DeleteCommand.Connection.Close()




End Try

End If

Kdpemegang.Focus()

bersih()

End Sub

Private Sub changepegang_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles changepegang.Click



Then

Try



draset("Kd_pemegang") = Kdpemegang.Text

draset("Nama") = namapemegang.Text

draset("Jabatan") = jabatan.Text

draset("Struktur") = struktur.Text

draset("Alamat") = alamat.Text

con.Open()



con.Close()




End Try

Kdpemegang.Focus()

bersih()

End If

End Sub

End Class

2.2.10 Form Kontrol Aset Kendaraan

Source Code Form Kontrol Aset Kendaraan: Public Class Form5

Dim dakend As OleDb.OleDbDataAdapter



Dim con As New





base.mdb")

Dim dtkend As New DataTable()



Dim drkend As DataRow









base.mdb"


Return kalimat

End Function




Try



daaset.Fill(dtaset)

dc(0) = dtaset.Columns("kd_aset")


With kdasetkend


.DisplayMember = "kd_aset"

.ValueMember = "kd_aset"

End With


formpemegang", con)

dapeg.Fill(dtpeg)



With kdpegangkend

.DataSource = dtpeg



End With

dakend = New OleDb.OleDbDataAdapter("select * from

form_kontrolkendaraan", con)

dakend.Fill(dtkend)

dc(0) = dtkend.Columns("no_kontrol")

dtkend.PrimaryKey = dc

dgkomp.DataSource = dtkend



End Try

End Sub

Sub kosong()

no.Text = ""

remdepan.Text = ""

rembelakang.Text = ""

kemudi.Text = ""

roda.Text = ""

kerangka.Text = ""

pemuatan.Text = ""

klakson.Text = ""

lampu1.Text = ""

lampu2.Text = ""

lampu3.Text = ""

spion.Text = ""

ban.Text = ""

weeper.Text = ""

no.Focus()

End Sub



If no.Text = "" Or kdasetkend.Text = "" Or kdpegangkend.Text

= "" Or remdepan.Text = "" Or rembelakang.Text = "" Or kemudi.Text =

"" Or roda.Text = "" Or kerangka.Text = "" Or pemuatan.Text = "" Or

klakson.Text = "" Or lampu1.Text = "" Or lampu2.Text = "" Or

lampu3.Text = "" Or spion.Text = "" Or ban.Text = "" Or weeper.Text

= "" Then


no.Focus()

Else

Try


OleDb.OleDbCommandBuilder(dakend)

drkend = dtkend.NewRow

drkend("no_kontrol") = no.Text

drkend("kd_aset") = kdasetkend.Text

drkend("kd_pemegang") = kdpegangkend.Text

drkend("Rem_depan") = remdepan.Text

drkend("Rem_belakang") = rembelakang.Text

drkend("Kemudi") = kemudi.Text

drkend("Roda") = roda.Text

drkend("Kerangka") = kerangka.Text

drkend("Pemuatan") = pemuatan.Text

drkend("Klakson") = klakson.Text

drkend("Lampu_utama") = lampu1.Text

drkend("Lampu_sein") = lampu2.Text

drkend("Lampu_rem") = lampu3.Text

drkend("Spion") = spion.Text

drkend("Ban") = ban.Text

drkend("Penghapus_kaca") = weeper.Text

dtkend.Rows.Add(drkend)

con.Open()

dakend.Update(dtkend)

dtkend.AcceptChanges()

con.Close()




End Try

End If

no.Focus()

kosong()

End Sub



kosong()

End Sub





Try



drkend("no_kontrol") = no.Text

drkend("kd_aset") = kdasetkend.Text

drkend("kd_pemegang") = kdpegangkend.Text

drkend("Rem_depan") = remdepan.Text

drkend("Rem_belakang") = rembelakang.Text

drkend("Kemudi") = kemudi.Text

drkend("Roda") = roda.Text

drkend("Kerangka") = kerangka.Text

drkend("Pemuatan") = pemuatan.Text

drkend("Klakson") = klakson.Text

drkend("Lampu_utama") = lampu1.Text

drkend("Lampu_sein") = lampu2.Text

drkend("Lampu_rem") = lampu3.Text

drkend("Spion") = spion.Text

drkend("Ban") = ban.Text

drkend("Penghapus_kaca") = weeper.Text

con.Open()



con.Close()




End Try

End If

kosong()

no.Focus()

End Sub



Try

drkend = dtkend.Rows.Find(no.Text)

no.Text = drkend("no_kontrol").ToString

kdasetkend.Text = drkend("kd_aset").ToString

kdpegangkend.Text = drkend("Kd_pemegang").ToString

remdepan.Text = drkend("Rem_depan").ToString

rembelakang.Text = drkend("Rem_belakang").ToString

kemudi.Text = drkend("Kemudi").ToString

roda.Text = drkend("Roda").ToString

kerangka.Text = drkend("Kerangka").ToString

pemuatan.Text = drkend("Pemuatan").ToString

klakson.Text = drkend("Klakson").ToString

lampu1.Text = drkend("Lampu_utama").ToString

lampu2.Text = drkend("Lampu_sein").ToString

lampu3.Text = drkend("Lampu_rem").ToString

spion.Text = drkend("Spion").ToString

ban.Text = drkend("Ban").ToString

weeper.Text = drkend("Penghapus_kaca").ToString




End Try

End Sub


ByVal e As System.EventArgs) Handles deletekomp.Click



Try



drkend.Delete()

dakend.DeleteCommand = cbhapus.GetDeleteCommand



dakend.DeleteCommand.Connection.Close()




End Try

End If

no.Focus()

kosong()

End Sub

Private Sub kdasetkend_SelectedIndexChanged(ByVal sender As


kdasetkend.SelectedIndexChanged

Try


draset = dtaset.Rows.Find(kdasetkend.Text)

jnaset1.Text = draset("Jenis_kendaraan").ToString

mraset1.Text = draset("Merk_kendaraan").ToString

sraset1.Text = draset("Seri_kendaraan").ToString


End Try

End Sub

Private Sub kdpegangkend_SelectedIndexChanged(ByVal sender As


kdpegangkend.SelectedIndexChanged

Try


drpeg = dtpeg.Rows.Find(kdpegangkend.Text)





End Try

End Sub

End Class

2.2.11 Form Kontrol Aset Komputer

Source Code Form Kontrol Aset Komputer: Public Class Form8




Dim con As New





base.mdb")













base.mdb"


Return kalimat

End Function




Try


formaset where Bentuk = 'Komputer'", con)

daaset.Fill(dtaset)



With kdasetkomp




End With


formpemegang", con)

dapeg.Fill(dtpeg)



With kdpegangkomp

.DataSource = dtpeg



End With


formkontrolkomp", con)


dc(0) = dtrekapnb.Columns("no_rekap")


dgkomp.DataSource = dtrekapnb



End Try

End Sub

Sub kosong()

no.Text = ""

kdasetkomp.Text = ""

kdpegangkomp.Text = ""

monitor.Text = ""

keyboard.Text = ""

mouse.Text = ""

vga.Text = ""

sncard.Text = ""

hdd.Text = ""

power.Text = ""

rom.Text = ""

End Sub



If no.Text = "" Or kdasetkomp.Text = "" Or kdpegangkomp.Text

= "" Or monitor.Text = "" Or keyboard.Text = "" Or mouse.Text = ""

Or sncard.Text = "" Or hdd.Text = "" Or power.Text = "" Or rom.Text

= "" Then


no.Focus()

Else

Try




drrekapnb("no_rekap") = no.Text

drrekapnb("kd_aset_komputer") = kdasetkomp.Text







drrekapnb("Hardisk") = hdd.Text




con.Open()



con.Close()




End Try

End If

no.Focus()

kosong()

End Sub



kosong()

End Sub

Private Sub kdasetkomp_SelectedIndexChanged(ByVal sender As


kdasetkomp.SelectedIndexChanged

Try


draset = dtaset.Rows.Find(kdasetkomp.Text)

jnaset1.Text = draset("Jenis").ToString

mraset1.Text = draset("Merk").ToString

sraset1.Text = draset("Seri").ToString


End Try

End Sub





Try



drrekapnb("no_rekap") = no.Text

drrekapnb("kd_aset_komputer") = kdasetkomp.Text






drrekapnb("Soundcard") = sncard.Text

drrekapnb("Hardisk") = hdd.Text



con.Open()



con.Close()




End Try

End If

kosong()

no.Focus()

End Sub



Try

drrekapnb = dtrekapnb.Rows.Find(no.Text)

no.Text = drrekapnb("No_rekap").ToString

kdasetkomp.Text = drrekapnb("kd_aset_komputer").ToString

kdpegangkomp.Text = drrekapnb("Kd_pemegang").ToString

monitor.Text = drrekapnb("Monitor").ToString

keyboard.Text = drrekapnb("Keyboard").ToString

mouse.Text = drrekapnb("Mouse").ToString

vga.Text = drrekapnb("VGA").ToString

sncard.Text = drrekapnb("SoundCard").ToString

hdd.Text = drrekapnb("Hardisk").ToString

power.Text = drrekapnb("Power_supply").ToString

rom.Text = drrekapnb("ROM_drive").ToString




End Try

End Sub


ByVal e As System.EventArgs)



Try



drrekapnb.Delete()








End Try

End If

no.Focus()

kosong()

End Sub

Private Sub kdpegangkomp_SelectedIndexChanged(ByVal sender As


kdpegangkomp.SelectedIndexChanged

Try


drpeg = dtpeg.Rows.Find(kdpegangkomp.Text)





End Try

End Sub

End Class

2.2.12 Form Input User dan Admin

Source Code Form Input User Dan Admin: Public Class Form4

Dim dauser As OleDb.OleDbDataAdapter

Dim con As New





base.mdb")

Dim dtuser As New DataTable()

Dim druser As DataRow







base.mdb"


Return kalimat

End Function

Sub bersih()

iduser.Text = ""

namauser.Text = ""

passuser.Text = ""

statuser.Text = ""

iduser.Focus()

End Sub

Private Sub Form4_Load_1(ByVal sender As System.Object, ByVal e

As System.EventArgs) Handles MyBase.Load


Try

dauser = New OleDb.OleDbDataAdapter("select * from

formpassuser", con)

dauser.Fill(dtuser)

dc(0) = dtuser.Columns("ID")

dtuser.PrimaryKey = dc

dguser.DataSource = dtuser



End Try

End Sub

Private Sub saveuser_Click(ByVal sender As System.Object, ByVal

e As System.EventArgs) Handles saveuser.Click

If MessageBox.Show("Anda yakin ingin menyimpan Akun User


Then

Try


OleDb.OleDbCommandBuilder(dauser)

druser = dtuser.NewRow

druser("ID") = iduser.Text

druser("Nama") = namauser.Text

druser("Pasword") = passuser.Text

druser("Status") = statuser.Text

dtuser.Rows.Add(druser)

con.Open()

dauser.Update(dtuser)

dtuser.AcceptChanges()

con.Close()

MsgBox("Akun User berhasil tersimpan")



End Try

End If

iduser.Focus()

bersih()

End Sub

Private Sub btluser_Click(ByVal sender As System.Object, ByVal e

As System.EventArgs) Handles btluser.Click

iduser.Text = ""

namauser.Text = ""

passuser.Text = ""

statuser.Text = ""

iduser.Focus()

End Sub

Private Sub cruser_Click(ByVal sender As System.Object, ByVal e

As System.EventArgs) Handles cruser.Click

Try

druser = dtuser.Rows.Find(iduser.Text)

iduser.Text = druser("ID").ToString

namauser.Text = druser("Nama").ToString

passuser.Text = druser("Pasword").ToString

statuser.Text = druser("Status").ToString

MsgBox("Akun ditemukan")



End Try

End Sub

Private Sub deluser_Click(ByVal sender As System.Object, ByVal e

As System.EventArgs) Handles deluser.Click

If MessageBox.Show("Anda yakin untuk menghapus Database


Then

Try


OleDb.OleDbCommandBuilder(dauser)

druser.Delete()

dauser.DeleteCommand = cbhapus.GetDeleteCommand

dauser.Update(dtuser)

dtuser.AcceptChanges()

dauser.DeleteCommand.Connection.Close()



MsgBox("Akun User berhasil dihapus")

End Try

End If

iduser.Focus()

bersih()

End Sub

End Class

2.2.13 Form Edit Password

Source Code Form Edit Password:


Public Class Form7

Dim Nama As String

Dim pasword As String

Sub GantiPassword()

cmd = New OleDbCommand("select * from formpassuser where

Nama = '" & usernameedit.Text & "' and Pasword = '" &

passlamaedit.Text & "'", con)

rd = cmd.ExecuteReader

rd.Read()

End Sub

Sub bersih()

usernameedit.Text = ""

passlamaedit.Text = ""

passbaruedit.Text = ""

repassedit.Text = ""

End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e

As System.EventArgs) Handles Button1.Click

Call GantiPassword()

If Not rd.HasRows Then

MsgBox("Nama atau Password Salah")

usernameedit.Focus()

bersih()

Else

passbaruedit.Focus()

If passbaruedit.Text = passlamaedit.Text Then

MsgBox("Password baru tidak boleh sama dengan

Password lama")

Else

repassedit.Focus()

If passbaruedit.Text <> repassedit.Text Then

MsgBox("Re-Password Harus Sama Dengan Password

Baru")

Else

If MessageBox.Show("Anda yakin untuk mengubah

Password?", "", MessageBoxButtons.YesNo) =

Windows.Forms.DialogResult.Yes Then

pasword = passbaruedit.Text

cmd = New OleDbCommand(("update formpassuser

set Pasword= '" & pasword & "'where Nama='" & usernameedit.Text &

"'"), con)

cmd.ExecuteNonQuery()

MsgBox("Password Berhasil Dirubah")

bersih()

usernameedit.Focus()

End If

End If

End If

End If

End Sub

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e

As System.EventArgs) Handles Button2.Click

Me.Close()

End Sub

End Class

2.2.14 Form Version

2.2.15 Source Code Module Koneksi Database


Module Module1

Public con As OleDbConnection

Public cmd As OleDbCommand

Public da As OleDbDataAdapter

Public ds As DataSet

Public rd As OleDbDataReader

Public str As String

Sub Koneksi()

str = "provider=microsoft.jet.oledb.4.0;data

source=Database.mdb"

con = New OleDbConnection(str)

If con.State = ConnectionState.Closed Then

con.Open()

End If

End Sub

End Module

BAB III

IMPLEMENTASI

3.1 Spesifikasi Hardware dan Software

Hardware yang digunakan:

1. Sistem Operasi MS Windows XP Professional (5.1,Build 2600) 32-Bit

Service Pack 3

2. Netbook HP (Hewlett-Packard) Mini 110-1169TU

3. Proccesor Intel Atom N280 1.66 GHz

4. RAM 1.0GB Single-Channel DDR2

5. VGA Mobile Intel 945 Express Chipset Family, 128 Mb

6. Hard Drives 160GB FUJITSU MJA2160BH (SATA)

Software yang digunakan:

1. Microsoft Office Enterprise 2007

2. Microsoft Visual Studio 2005 (Visual Basic.NET)

3. Seagate Crystal Report 8.5 Developer Edition

3.2 cara pengoperasian program

Cara pengoperasian program dengan cara Install Setup Aplikasinya terlebih

dahulu,Aplikasi ini memerlukan .NET Framework 2.0 agar bisa berjalan dengan

baik.Setelah terinstall,maka jalankan Aplikasinya yang telah menyediakan Shortcut

pada Desktop dan Startup Program.

Isi Data seperti Aset,Pemegang,Rincian Aset,hingga Kontrol Aset jika

mengalami keruksakan atau perlunya penggantian Spare Part,Dalam Aplikasi

tersebut ada Fitur Login,berfungsi selain sistem keamanan Aplikasi juga untuk

system Hak Akses,Agar tidak sembarang orang bias membuka Form tertentu pada

Aplikasi ini.

BAB IV

KESIMPULAN

Kesimpulan

Dari pembahasan di atas dapat disimpulkan bahwa bahasa pemograman visual

basic merupakan pemograman berbasis Windows. Visual Basic juga merupakan

bahasa pemograman Object Oriented Programming (OOP), yaitu pemograman yang

berorientasi objek. Visual Basic menyediakan objek-objek yang sangat kuat, berguna

dan mudah dipakai. Dengan fasilitas tersebut membuat Visual Basic menjadi begitu

diinginkan oleh programmer. Dengan menggunakan aplikasi Visual Basic dapat

digunakan pada program aplikasi penggajian sehingga dapat mempermudah dalam

proses penggajian para pegawai dalam suatu perusahaan.

Saran

Diharapkan mahasiswa mau mempelajari dan mengembangkan

bahasa pemograman Visual Basic karena merupakan bahasa yang mudah untuk

dipelajari dan sangat menarik maka penulis berharap kepada pembaca

(khususnya pemula), untuk sejak dini mempelajari dan mengembangkan bahasa

pemograman tersebut.

DAFTAR PUSTAKA

Program Aplikasi Inventaris 2012 STMIK JABAR bandung

http://www.konsultasivb.com

http://www.mugi.or.id

http://www.konsultasivb.com/