lampiran source code

LAMPIRAN -LAMPIRAN

Lampiran 1

Sourcecode Password

Dim Passs As New ADODB.Connection

Dim rsPass As New ADODB.Recordset

Private Sub cmdbatal_Click()

Dim X

X = MsgBox("Anda yakin ingin membatalkan Log-in ?.", _

vbYesNo + vbQuestion, "Yakin ingin Membatalkan...?")

If X = vbYes Then

End

End If

End Sub

Private Sub cmbbatal_Click()

Unload Me

End Sub

Private Sub cmdOK_Click()

If txtpas = "" Then

MsgBox "Anda belum memasukkan password!!!", vbCritical, "Salah!"

txtuser.Text = ""

txtpas.Text = ""

Else

If txtuser.Text = Label3.Caption Then

Utama.Show

login.Hide

txtuser.Text = ""

txtpas.Text = ""

Else

MsgBox "Password yang anda masukkan tidak sesuai", vbCritical, "Salah"

txtuser.Text = ""

txtuser.SetFocus

txtpas.Text = ""

End If

End If

End Sub

Private Sub Command1_Click()

Unload Me

End Sub

Private Sub Form_Load()

Set Passs = Nothing

Set rsPass = Nothing

Passs.Provider = "microsoft.jet.oledb.4.0"

Passs.CursorLocation = adUseClient

Passs.Open App.Path & "/" & "db_pos.mdb", "admin", ""

txtuser.Text = ""

txtpas.Text = ""

End Sub

Private Sub txtuser_Change()

Set rsPass = Nothing

rsPass.Open "login", Passs, adOpenDynamic, adLockOptimistic

rsPass.Find "user='" + txtuser.Text + "'"

If Not rsPass.EOF Then Label3.Caption = rsPass!User

If txtuser.Text = Label3.Caption Then txtpas.SetFocus

End Sub

Lampiran 2

Sourcecode Menu Utama

Dim strTemp, LenTemp, n

Dim strTmp, LenTmp, u

Private Sub benda_Click()

DataReport1.Show

End Sub

Private Sub BPM_Click()

POSS.Show

Utama.Hide

End Sub

Private Sub Ganti_Click()

gantip.Show

Utama.Hide

End Sub


strTemp = Me.Caption

n = 1

strTmp = Label1.Caption

u = 1

End Sub

Private Sub Prog_Click()

tentang.Show

Utama.Hide

End Sub

Private Sub Timer1_Timer()

LenTemp = Len(strTemp)

Dim Form As String


Me.Caption = Left(strTemp, n) + "_"

n = n + 1

If n > LenTemp Then

n = 1

End If

LenTmp = Len(strTmp)

Dim label As String


Label1.Caption = Left(strTmp, u) + "_"

u = u + 1

If u > LenTmp Then

u = 1

End If

End Sub

Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)

On Error Resume Next

Select Case Button.Index

Case 2

POSS.Show

Utama.Hide

Case 4

DataReport1.Show

Utama.Hide

Case 6

gantip.Show

Utama.Hide

Case 8

Help.Show

Utama.Hide

Case 10

Close

Dim X

X = MsgBox("Apakah anda ingin keluar dari aplikasi ini?", _

vbYesNo + vbQuestion, "Yakin anda ingin Keluar?")

If X = vbYes Then

End

End If

End Select

End Sub

Lampiran 3

Source code POSS

Dim strTemp, LenTemp, n

Dim strTmp, LenTmp, u

Dim POS As New ADODB.Connection

Dim rspos As New ADODB.Recordset

Dim List As ListItem

Private Sub Tampil()

Do While Not rspos.EOF

Set List = tampilkopur.ListItems.Add(, , rspos.Fields!No)

List.SubItems(1) = rspos!Perangko

List.SubItems(2) = rspos!Harga

List.SubItems(3) = rspos!Dipenuhi

List.SubItems(4) = rspos!BSU

List.SubItems(5) = rspos!tanggal

List.SubItems(6) = rspos!Nopen

rspos.MoveNext

Loop

End Sub

Private Sub Reset()

txtnop.Text = ""

txtperangko.Text = ""

cmbhrgperangko.Text = ""

txtdipenuhi1.Text = ""

'txtkalper1.Text = ""

tanggal.Value = ""

Txtnopenp.Text = ""

End Sub

Private Sub hubung()

rspos!No = txtnop.Text

rspos!Perangko = txtperangko.Text

rspos!Harga = cmbhrgperangko.Text

rspos!Dipenuhi = txtdipenuhi1.Text

rspos!BSU = txtkalper1.Text

rspos!tanggal = tanggal.Value

rspos!Nopen = Txtnopenp.Text

End Sub

Private Sub Ktemu()

txtnop.Text = rspos!No

txtperangko.Text = rspos!Perangko

cmbhrgperangko.Text = rspos!Harga

txtdipenuhi1.Text = rspos!Dipenuhi

txtkalper1.Text = rspos!BSU

tanggal.Value = rspos!tanggal

Txtnopenp.Text = rspos!Nopen

End Sub

Private Sub cmdbatalkon_Click()

Set rspos = Nothing

Resetk

txtcari.Text = ""

'bersih.Enabled = False

cmdsimpankon.Caption = "&Simpan"

End Sub

Private Sub cmdBatalp_Click(Index As Integer)

Set rspos = Nothing

Reset

txtcari.Text = ""


cmdsimpanp.Caption = "&Simpan"

End Sub

Private Sub cmdbersihk_Click(Index As Integer)

If txtnok.Text = "" Then

MsgBox "Tidak ada data yang akan dihapus" _

+ vbLf + "Click pada data yang ada di daftar" + vbLf + _

"Kemudian click hapus", vbInformation, "Salah"

Else

rspos.Delete adAffectCurrent

Reset

Set rspos = Nothing

rspos.Open "Tambahan", POS, adOpenDynamic, adLockOptimistic

tampilkonsinyasi.ListItems.Clear

Tampilk

End If

End Sub

Private Sub cmdbersihn_Click()

If txtkode.Text = "" Then




Else


Resetno

Set rspos = Nothing

rspos.Open "KoNopen", POS, adOpenDynamic, adLockOptimistic

TampilNopen.ListItems.Clear

tampilno

End If

End Sub

Private Sub cmdbersihp_Click(Index As Integer)

If txtnop.Text = "" Then




Else


Reset

Set rspos = Nothing

rspos.Open "kopur", POS, adOpenDynamic, adLockOptimistic

tampilkopur.ListItems.Clear

Tampil

End If

End Sub

Private Sub cmdKeluark_Click(Index As Integer)

Unload Me

End Sub

Private Sub cmdkeluar_Click()

Utama.Show

POSS.Hide

End Sub

Private Sub cmdkeluarkon_Click(Index As Integer)

Utama.Show

POSS.Hide

End Sub

Private Sub cmdKeluarp_Click(Index As Integer)

Utama.Show

POSS.Hide

End Sub

Private Sub cmdsimpanm_Click()

If cmdsimpanm.Caption = "&Simpan" Then

Set rspos = Nothing

rspos.Open "materai", POS, adOpenDynamic, adLockOptimistic

rspos.Find "Nomor like '" + txtnom.Text + "'"

'If Not rspos.EOF Then

'MsgBox "No yang anda masukkan sudah terdapat dalam daftar" + vbLf + _

'" ulangi pemasukkan data", vbExclamation, "Peringatan"

'Combok.Text = ""

'Combok.SetFocus

'Else

Set rspos = Nothing

rspos.Open "materai", POS, adOpenDynami, adLockOptimistic

rspos.AddNew

hubungm

rspos.Update

End If

If cmdsimpanm.Caption = "&Edit" Then

hubungm

rspos.Update

cmdsimpanm.Caption = "&Simpan"

End If

Set rspos = Nothing


tampilmmaterai.ListItems.Clear

Tampilm

Resetm

txtnom.SetFocus

End Sub

Private Sub tampilno()


Set List = TampilNopen.ListItems.Add(, , rspos.Fields!KodeNopen)

List.SubItems(1) = rspos!Nopen

rspos.MoveNext

Loop

End Sub

Private Sub Resetno()

txtkode.Text = ""

Txtnopen.Text = ""

End Sub

Private Sub hubungno()

rspos!KodeNopen = txtkode.Text

rspos!Nopen = Txtnopen.Text

End Sub

Private Sub Ktemuno()

txtkode.Text = rspos!KodeNopen

Txtnopen.Text = rspos!Nopen

End Sub

Private Sub cmdbataln_Click()

Set rspos = Nothing

Resetno

txtcari.Text = ""


cmdsimpann.Caption = "&Simpan"

End Sub

Private Sub tampilnopen_BeforeLabelEdit(Cancel As Integer)

Set rspos = Nothing


txtkode.Text = TampilNopen.SelectedItem

rspos.Find "KodeNopen='" + txtkode.Text + "'"

Ktemuno

cmdsimpann.Caption = "&Edit"

cmdbersihn.Enabled = True

End Sub

Private Sub cmdkeluarn_Click()

Utama.Show

POSS.Hide

End Sub

Private Sub cmdsimpann_Click()

If cmdsimpann.Caption = "&Simpan" Then

Set rspos = Nothing


rspos.Find "Kodenopen like '" + txtkode.Text + "'"




'txtkode.SetFocus

'Else

Set rspos = Nothing

rspos.Open "KoNopen", POS, adOpenDynami, adLockOptimistic

rspos.AddNew

hubungno

rspos.Update

End If

If cmdsimpann.Caption = "&Edit" Then

hubungno

rspos.Update

cmdsimpann.Caption = "&Simpan"

End If

Set rspos = Nothing



tampilno

Resetno

End Sub

Private Sub tampilkonsinyasi_BeforeLabelEdit(Cancel As Integer)

Set rspos = Nothing

rspos.Open "tambahan", POS, adOpenDynamic, adLockOptimistic

txtnok.Text = tampilkonsinyasi.SelectedItem

rspos.Find "Nok='" + txtnok.Text + "'"

Ktemuk

cmdsimpankon.Caption = "&Edit"

'cmdbersihk.Enabled = True

End Sub

Private Sub Text1_Change()

txtkalper1.Text = Val(Text1.Text) + Val(txtbsu1.Text)

End Sub


txtmat.Text = Val(Text2.Text) + Val(txtbsum.Text)

End Sub


txtkalkon.Text = Val(Text3.Text) + Val(txtbsukon.Text)

End Sub

Private Sub Timer1_Timer()


Dim Form As String


Me.Caption = Left(strTemp, n) + "_"

n = n + 1

If n > LenTemp Then

n = 1

End If


Dim label As String


Label3.Caption = Left(strTmp, u) + "_"

u = u + 1

If u > LenTmp Then

u = 1

End If

End Sub

Private Sub txtdipenuhim_Change()

Text2.Text = Val(cmbhrgmaterai.Text) * Val(txtdipenuhim.Text)

txtbsum.Text = Val(cmbhrgmaterai.Text) * Val(txtdipenuhim.Text)

End Sub

Private Sub cmdsimpanp_Click()

If cmdsimpanp.Caption = "&Simpan" Then

Set rspos = Nothing


rspos.Find "No like '" + txtnop.Text + "'"




'Combok.Text = ""

'Combok.SetFocus

'Else

Set rspos = Nothing

rspos.Open "kopur", POS, adOpenDynami, adLockOptimistic

rspos.AddNew

hubung

rspos.Update

End If

If cmdsimpanp.Caption = "&Edit" Then

hubung

rspos.Update

cmdsimpanp.Caption = "&Simpan"

End If

Set rspos = Nothing



Tampil

Reset

txtnop.SetFocus

End Sub


strTemp = Me.Caption

n = 1

strTmp = Label3.Caption

u = 1

Set POS = Nothing

Set rspos = Nothing

POS.Provider = "microsoft.jet.oledb.4.0"

POS.CursorLocation = adUseClient

POS.Open App.Path & "/" & "db_pos.mdb", "admin", ""



Tampil

Set POS = Nothing

Set rspos = Nothing






Tampilm

Set POS = Nothing

Set rspos = Nothing






Tampilk

Set POS = Nothing

Set rspos = Nothing






tampilno

cmbhrgperangko.AddItem 1000









cmbthn.AddItem 2005

cmbthn.AddItem 2006

cmbthn.AddItem 2007

cmbthn.AddItem 2008

cmbthn.AddItem 2009

cmbthn.AddItem 2010

cmbthn.AddItem 2011

cmbhrgmaterai.AddItem "3000"

cmbhrgmaterai.AddItem "6000"

cmbkon.AddItem "Kartu Perdana Shar'e"

cmbkon.AddItem "Sampul"

cmbkon.AddItem "Kartu Takaf"

End Sub

Private Sub Form_Unload(Cancel As Integer)

Do

Me.Top = Me.Top + 300

Me.Move Me.Left, Me.Top

DoEvents

Loop Until Me.Top > Screen.Height - 500

End Sub

Private Sub tampilkopur_BeforeLabelEdit(Cancel As Integer)

Set rspos = Nothing


txtnop.Text = tampilkopur.SelectedItem

rspos.Find "No='" + txtnop.Text + "'"

Ktemu

cmdsimpanp.Caption = "&Edit"

'bersih.Enabled = True

End Sub

Private Sub Tutup_Click(Index As Integer)

Unload POS

End Sub

Private Sub txtcari_Change()

Set rspos = Nothing

If txtcari.Text = "" Then


Else


rspos.Filter = "Tahun like '*" + txtcari.Text + "*'"

End If


Tampil

End Sub

Private Sub txtdipenm_Change()

txtkalper1.Text = Val(cmbhrgperangko.Text) * Val(txtdipenuhi1.Text)

txtbsu1.Text = Val(cmbhrgperangko.Text) * Val(txtdipenuhi1.Text)

End Sub

Private Sub tampilmmaterai_BeforeLabelEdit(Cancel As Integer)

Set rspos = Nothing


txtnom.Text = tampilmmaterai.SelectedItem

rspos.Find "Nomor='" + txtnom.Text + "'"

Ktemum

cmdsimpanm.Caption = "&Edit"

'bersih.Enabled = True

End Sub

Private Sub txtdipenkon_Change()

Text3.Text = Val(txthrgkon.Text) * Val(txtdipenkon.Text)

txtbsukon.Text = Val(txthrgkon.Text) * Val(txtdipenkon.Text)

End Sub

Private Sub txtdipenuhi1_Change()

Text1.Text = Val(cmbhrgperangko.Text) * Val(txtdipenuhi1.Text)

txtbsu1.Text = Val(cmbhrgperangko.Text) * Val(txtdipenuhi1.Text)

End Sub

Private Sub Tampilm()


Set List = tampilmmaterai.ListItems.Add(, , rspos.Fields!Nomor)

List.SubItems(1) = rspos!Materai_Tahun

List.SubItems(2) = rspos!Hargam

List.SubItems(3) = rspos!Dipenuhim

List.SubItems(4) = rspos!Bsum

List.SubItems(5) = rspos!tanggalm

List.SubItems(6) = rspos!Nopenm

rspos.MoveNext

Loop

End Sub

Private Sub Resetm()

txtnom.Text = ""

cmbthn.Text = ""

cmbhrgmaterai.Text = ""

txtdipenuhim.Text = ""

txtbsum.Text = ""

tanggalm.Value = ""

Txtnopenm.Text = ""

End Sub

Private Sub Ktemum()

txtnom.Text = rspos!Nomor

cmbthn.Text = rspos!Materai_Tahun

cmbhrgmaterai.Text = rspos!Hargam

txtdipenuhim.Text = rspos!Dipenuhim

txtbsum.Text = rspos!Bsum

tanggalm.Value = rspos!tanggalm

Txtnopenm.Text = rspos!Nopenm

End Sub

Private Sub hubungm()

rspos!Nomor = txtnom.Text

rspos!Materai_Tahun = cmbthn.Text

rspos!Hargam = cmbhrgmaterai.Text

rspos!Dipenuhim = txtdipenuhim.Text

rspos!Bsum = txtbsum.Text

rspos!tanggalm = tanggalm.Value

rspos!Nopenm = Txtnopenm.Text

End Sub

Private Sub cmdbatalm_Click(Index As Integer)

Set rspos = Nothing

Resetm

txtcari.Text = ""


cmdsimpanm.Caption = "&Simpan"

End Sub

Private Sub cmdbersihm_Click()

If txtnom.Text = "" Then




Else


Resetm

Set rspos = Nothing



Tampilm

End If

End Sub

Private Sub cmdkeluarm_Click()

Utama.Show

BPM.Hide

End Sub

Private Sub Tampilk()


Set List = tampilkonsinyasi.ListItems.Add(, , rspos.Fields!Nok)

List.SubItems(1) = rspos!Konsinyasik

List.SubItems(2) = rspos!Hargak

List.SubItems(3) = rspos!Dipenuhik

List.SubItems(4) = rspos!Bsuk

List.SubItems(5) = rspos!BSUTOTAL

List.SubItems(6) = rspos!tanggalk

List.SubItems(7) = rspos!Nopenk

rspos.MoveNext

Loop

End Sub

Private Sub Resetk()

txtnok.Text = ""

cmbkon.Text = ""

txthrgkon.Text = ""

txtdipenkon.Text = ""

txtbsukon.Text = ""

txtkaltotal1.Text = ""

tgl3.Value = ""

Txtnopenkon.Text = ""

End Sub

Private Sub hubungk()

rspos!Nok = txtnok.Text

rspos!Konsinyasik = cmbkon.Text

rspos!Hargak = txthrgkon.Text

rspos!Dipenuhik = txtdipenkon.Text

rspos!Bsuk = txtbsukon.Text

rspos!BSUTOTAL = txtkaltotal1.Text

rspos!tanggalk = tgl3.Value

rspos!Nopenk = Txtnopenkon.Text

End Sub

Private Sub Ktemuk()

txtnok.Text = rspos!Nok

cmbkon.Text = rspos!Konsinyasik

txthrgkon.Text = rspos!Hargak

txtdipenkon.Text = rspos!Dipenuhik

txtbsukon.Text = rspos!Bsuk

txtkaltotal1.Text = rspos!BSUTOTAL

tgl3.Value = rspos!tanggalk

Txtnopenkon.Text = rspos!Nopenk

End Sub

Private Sub cmdbatalk_Click(Index As Integer)

Set rspos = Nothing

Resetk

txtcari.Text = ""



End Sub

Private Sub cmdsimpankon_Click()

If cmdsimpankon.Caption = "&Simpan" Then

Set rspos = Nothing


rspos.Find "Nok like '" + txtnok.Text + "'"




'Combok.Text = ""

'Combok.SetFocus

'Else

Set rspos = Nothing

rspos.Open "tambahan", POS, adOpenDynami, adLockOptimistic

rspos.AddNew

hubungk

rspos.Update

End If

If cmdsimpankon.Caption = "&Edit" Then

hubungk

rspos.Update


End If

Set rspos = Nothing



Tampilk

Resetk

txtnok.SetFocus

End Sub

Private Sub txtkalkon_Change()

txtkaltotal1.Text = Val(txtkalper1.Text) + Val(txtmat.Text) + Val(txtkalkon.Text)

End Sub

Private Sub txtkalper1_Change()


End Sub

Private Sub txtkode_KeyPress(KeyAscii As Integer)

KeyAscii = Asc(UCase(Chr(KeyAscii)))

End Sub

Private Sub Txtkodenop_Change()

Set rspos = Nothing


rspos.Find "KodeNopen='" + Txtkodenop.Text + "'"

If Not rspos.EOF Then Txtnopenp.Text = rspos!Nopen

If Txtkodenop.Text = "" Then

Txtnopenp.Text = ""

End If

End Sub

Private Sub txtmat_Change()


End Sub

Private Sub txtnok1_Change()

Set rspos = Nothing


rspos.Find "KodeNopen='" + txtnok1.Text + "'"

If Not rspos.EOF Then Txtnopenkon.Text = rspos!Nopen

If txtnok1.Text = "" Then

Txtnopenkon.Text = ""

End If

End Sub

Private Sub txtnom1_Change()

Set rspos = Nothing


rspos.Find "KodeNopen='" + txtnom1.Text + "'"

If Not rspos.EOF Then Txtnopenm.Text = rspos!Nopen

If txtnom1.Text = "" Then

Txtnopenm.Text = ""

End If

End Sub

Private Sub Txtnopen_KeyPress(KeyAscii As Integer)


End Sub

Lampiran 4

Sourcecode Ganti Passoword

Dim Ganti As New ADODB.Connection

Dim rsGanti As New ADODB.Recordset

Private Sub cmdbatal_Click()

Utama.Show

gantip.Hide

End Sub

Private Sub cmdOK_Click()

If Label4.Caption = "" Then

MsgBox "Anda tidak berhak untuk mengganti password", vbCritical, "Informasi "

txtpl.Text = ""

txtbru1.Text = ""

txtbru2.Text = ""

txtpl.SetFocus

Else

If txtbru1.Text = txtbru2.Text Then

rsGanti!Password = txtbru1.Text

rsGanti.Update

Utama.Show

MsgBox "Password telah diganti", vbInformation, "Information"

Else

MsgBox "Password yang anda masukkan tidak sesuai" + vbLf + _

"Masukkan password baru sekali lagi", vbInformation, "Konfirmasi"

txtbru1.Text = ""

txtbru2.Text = ""

txtbru1.SetFocus

End If

End If

txtpl.Text = ""

txtbru1.Text = ""

txtbru2.Text = ""

Label4.Caption = ""

End Sub

Private Sub Command2_Click()

Menu.Show

GantiF.Hide

End Sub

Private Sub Commandbatal_Click()

Utama.Show

gantip.Hide

'GantiF.Hide

End Sub

Private Sub Commandok_Click()

If Label9.Caption = "" Then

MsgBox "Anda tidak berhak untuk mengganti User Name", vbCritical, "Informasi "

txtus.Text = ""

txtus1.Text = ""

txtus2.Text = ""

txtus.SetFocus

Else

If txtus1.Text = txtus2.Text Then

rsGanti!User = txtus1.Text

rsGanti.Update

Utama.Show

gantip.Hide

MsgBox "User Name telah diganti", vbInformation, "Information"

Else

MsgBox "User Name yang anda masukkan tidak sesuai" + vbLf + _

"Masukkan User Name baru sekali lagi", vbInformation, "Konfirmasi"

txtus1.Text = ""

txtus2.Text = ""

txtus1.SetFocus

End If

End If

txtus.Text = ""

txtus1.Text = ""

txtus2.Text = ""

Label9.Caption = ""

End Sub

Private Sub Form_KeyPress(KeyAscii As Integer)


End Sub


Ganti.Provider = "microsoft.jet.oledb.4.0"

Ganti.CursorLocation = adUseClient

Ganti.Open App.Path & "/" & "db_pos.mdb", "admin", ""

Label4.Caption = ""

Label9.Caption = ""

Frame1.Visible = False


Label5.Visible = False


End Sub

Private Sub pas_Click(Index As Integer)

Frame1.Visible = True


Label11.Visible = True


End Sub

Private Sub txtbru1_KeyPress(KeyAscii As Integer)


End Sub

Private Sub txtbru2_KeyPress(KeyAscii As Integer)


End Sub

Private Sub txtpl_Change()

Set rsGanti = Nothing

rsGanti.Open "Login", Ganti, adOpenDynamic, adLockOptimistic

rsGanti.Find "Password='" + txtpl.Text + "'"

If Not rsGanti.EOF Then Label4.Caption = rsGanti!Password

End Sub

Private Sub txtus_Change()

Set rsGanti = Nothing

rsGanti.Open "Login", Ganti, adOpenDynamic, adLockOptimistic

rsGanti.Find "User='" + txtus.Text + "'"

If Not rsGanti.EOF Then Label9.Caption = rsGanti!User

End Sub

Private Sub txtus_KeyPress(KeyAscii As Integer)


End Sub

Private Sub txtus1_KeyPress(KeyAscii As Integer)


End Sub

Private Sub txtus2_KeyPress(KeyAscii As Integer)


End Sub

Private Sub User_Click(Index As Integer)


Frame2.Visible = True


Label5.Visible = True

End Sub

lampiran source code

Education