data base perusahaan distro

DAVID

Private Sub ComDPROSES_Click()

total = TXTXJUMABA.text x txtHARGA.text

End Sub

 

Private Sub Command1_Click()

Data1.Recordset.Update

 

End Sub

 

Private Sub Command2_Click()

Data1.Recordset.AddNew

End Sub

 

Private Sub Command3_Click()

Data1.Recordset.Delete

End Sub

 

Private Sub ComdBATAL_Click()

kosong

End Sub

Public Sub kosong()

TxtKODE.SetFocus

TxtNAMABA.Text = “”

TxtDISKON.Text = “”

TxtJUMABA.Text = “”

TxtHARGA.Text = “”

TxtTOTAL.Text = “”

End Sub

Private Sub ComDKELUAR_Click()

Unload Me

End Sub

 

Private Sub ComdLAGI_Click()

kosong

End Sub

 

 

Private Sub DBGrid1_Click()

 

End Sub

 

 

End Sub

 

Private Sub Text1_Change()

 

End Sub

 

Private Sub TxtKODE_KeyPress(KeyAscii As Integer)

If KeyAscii = 13 Then

TxtNAMA.SetFocus

End If

 

End Sub

Iklan

database pengulangan ksalahannomor 10

data base pengulangan kesalahan no 10

david budianto

 

10

10

 

  1. Private Sub Text3_Change()

 

End Sub

 

Private Sub Text2_Change()

 

End Sub

 

Private Sub Command1_Click()

txtkode.SetFocus

End Sub

 

Private Sub Command2_Click()

txtkode.SetFocus

txtkode.Text = “”

textnb.Text = “”

txthb.Text = “”

txtjb.Text = “”

txtby.Text = “”

txtpot.Text = “”

txtttb.Text = “”

End Sub

 

Private Sub Command3_Click()

txtby.Text = Val(txthb.Text) * Val(txtjb.Text)

If txtjb.Text > 5 Then

txtpot.Text = 2 / 100 * Val(txtby.Text)

ElseIf txtjb.Text < 5 Then

txtpot.Text = 1 * Val(txtby.Text)

End If

txtttb.Text = Val(txtby.Text) – Val(txtpot.Text)

End Sub

 

Private Sub Command4_Click()

Form2.Show

Unload Me

End Sub

 

Private Sub Command5_Click()

Data1.Recordset.AddNew

 

 

End Sub

 

Private Sub Command6_Click()

Dim nama, harga As String

Y = Mid(txtkode.Text, 5, 2)

If Y = “SP” Then

textnb.Text = “SPIDOL”

txthb.Text = “9500”

ElseIf Y = “BT” Then

textnb.Text = “buku tulis”

txthb.Text = “12500”

ElseIf Y = “TP” Then

textnb.Text = “TIPE EX”

txthb.Text = “3000”

ElseIf Y = “PG” Then

textnb.Text = “PENGGARIS”

txthb.Text = “25000”

ElseIf Y = “PT” Then

textnb.Text = “PAPAN TULIS”

txthb.Text = “50000”

 

End If

txtjb.SetFocus

End Sub

 

Private Sub Command1_Click()

Unload Me

End Sub

 

Private Sub Command2_Click()

Form1.Show

End Sub

data base

 

 

 

 

 

 

 

  1. program 1

d1

 

 

 

 

1.Private Sub Cbgolongan_load()

cbogolongan.AddItem “I”

cbogolongan.AddItem “II”

cbogolongan.AddItem “III”

cbogolongan.AddItem “IV”

 

End Sub

 

Private Sub Cbgolongan_Click()

Dim gapok, pajak, tunjangan, total As Variant

Select Case Cbgolongan.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

TxtTUNJA.Text = tunjangan

TxtPAJAK.Text = pajak

TxtTOTAL.Text = total – pajak

End Sub

 

Private Sub Command1_Click()

Data1.Recordset.Update

End Sub

 

Private Sub Command2_Click()

Data1.Recordset.AddNew

End Sub

 

Private Sub Command3_Click()

Data1.Recordset.Delete

End Sub

 

Private Sub ComdBATAL_Click()

kosong

End Sub

Public Sub kosong()

TxtNIDN.SetFocus

TxtNIDN.Text = “”

TxtNAMA.Text = “”

Cbgolongan.Text = “”

TxtGAPOK.Text = “”

TxtTUNJA.Text = “”

TxtPAJAK.Text = “”

TxtTOTAL.Text = “”

End Sub

Private Sub ComDKELUAR_Click()

Unload Me

End Sub

 

Private Sub ComdLAGI_Click()

kosong

End Sub

 

 

Private Sub Form_Load()

Cbgolongan.AddItem “I”

Cbgolongan.AddItem “II”

Cbgolongan.AddItem “III”

Cbgolongan.AddItem “IV”

 

End Sub

 

Private Sub Text1_Change()

 

End Sub

 

Private Sub TxtNIDN_KeyPress(KeyAscii As Integer)

If KeyAscii = 13 Then

TxtNAMA.SetFocus

End If

 

End Sub

 

2.

D2

 

  1. Private Sub cmdbatal_Click()

Textnama.SetFocus

Textnama = “”

Textnpm = “”

Textjur = “”

Textps = “”

Texttm = “”

Textnu = “”

End Sub

 

Private Sub Cmdkeluar_Click()

End

End Sub

 

Private Sub cmdlagi_Click()

Textnama.SetFocus

Textnama = “”

Textnpm = “”

Textjur = “”

Textps = “”

Texttm = “”

Textnu = “”

End Sub

 

Private Sub Cmdproses_Click()

Dim A As String

Texttm = “20” & Left(Textnpm, 2)

A = Mid(Textnpm, 3, 3)

If A = “100” Then

Textjur = “sistem informasi”

Textps = “strata 1”

ElseIf A = “200” Then

Textjur = “manajemen informatika”

Textps = “diploma 3”

ElseIf A = “300” Then

Textjur = “teknik informatika”

Textps = “diploma 4”

ElseIf A = “400” Then

Textjur = “komputer akutansi”

Textps = “diploma 2”

End If

Textnu = Right(Textnpm, 3)

End Sub

 

 

 

Private Sub Command1_Click()

Data1.Recordset.Update

End Sub

 

Private Sub Command2_Click()

Data1.Recordset.AddNew

End Sub

 

Private Sub Command3_Click()

Data1.Recordset.Delete

End Sub

 

Private Sub Textnama_KeyPress(KeyAscii As Integer)

If KeyAscii = 13 Then

Textnpm.SetFocus

End If

End Sub

 

3.

d3

3.

Private Sub cmdbatal_Click()

Textnama.SetFocus

Textnama = “”

Textnpm = “”

Textjur = “”

Textps = “”

Texttm = “”

Textnu = “”

End Sub

 

Private Sub cmdkeluar_Click()

End

End Sub

 

Private Sub cmdlagi_Click()

Textnama.SetFocus

Textnama = “”

Textnpm = “”

Textjur = “”

Textps = “”

Texttm = “”

Textnu = “”

End Sub

 

Private Sub Cmdproses_Click()

Dim jr As String

Dim ps As String

Dim A As String

A = Mid(Textnpm, 3, 1)

If A = 1 Then

jr = “sistem informasi”

ElseIf A = 2 Then

jr = “teknik informatika”

ElseIf A = 3 Then

jr = “menejemen informatika”

ElseIf A = 4 Then

jr = “komputer akuntansi”

End If

Textjur = jr

 

A = Mid(Textnpm, 4, 2)

If A = “01” Then

ps = “strata 1”

ElseIf A = “02” Then

ps = “diploma 4”

ElseIf A = “03” Then

ps = “diploma 3”

ElseIf A = “04” Then

ps = “diploma 2”

End If

Textps = ps

Texttm = “20” & Left(Textnpm, 2)

Textnu = Right(Textnpm, 3)

 

End Sub

 

 

Private Sub Textnama_KeyPress(KeyAscii As Integer)

If KeyAscii = 13 Then

Textnpm.SetFocus

End If

End Sub

 

 

Private Sub Command1_Click()

Data1.Recordset.Update

End Sub

 

Private Sub Command2_Click()

Data1.Recordset.AddNew

End Sub

 

Private Sub Command3_Click()

Data1.Recordset.Delete

End Sub

4.

D4

 

4.Private Sub Combo1_Change()

 

End Sub

 

Private Sub CbKODE_Click()

Dim MERK, HS As Variant

Select Case CbKODE.Text

Case “Apple MC965 MacBook Air”

MERK = “Apple MacBook Air MC965”

HS = 12800000

Case “Apple MC966 MacBook Air”

MERK = “Apple MacBook Air MC966”

HS = 15800000

Case “Apple MC968 MacBook Air”

MERK = “Apple MacBook Air MC968”

HS = 9900000

Case “Apple MC969 MacBook Air”

MERK = “Apple MacBook Air MC969”

HS = 11900000

Case “Apple MC700 MacBook Pro”

MERK = “Apple MacBook Pro MC700”

HS = 10800000

Case “Apple MC721 MacBook Pro”

MERK = “Apple MacBook Pro MC721”

HS = 15900000

Case “Apple MC723 MacBook Pro”

MERK = “Apple MacBook Pro MC723”

HS = 19300000

Case “Apple MC724 MacBook Pro”

MERK = “Apple MacBook Pro MC724”

HS = 13700000

Case “Apple MC311 MacBook Pro”

MERK = “Apple MacBook Pro MC311”

HS = 24200000

Case “Apple MC313 MacBook Pro”

MERK = “Apple MacBook Pro MC313”

HS = 11900000

Case “Apple MC314 MacBook Pro”

MERK = “Apple MacBook Pro MC314”

HS = 14700000

Case “Apple MC318 MacBook Pro”

MERK = “Apple MacBook Pro MC318”

HS = 17600000

Case “Apple MC322 MacBook Pro”

MERK = “Apple MacBook Pro MC322”

HS = 21300000

Case “Apple MC965 MacBook Air”

MERK = “Apple MacBook Air MC965”

HS = 12800000

Case “Apple MC966 MacBook Air”

MERK = “Apple MacBook Air MC966”

HS = 15800000

End Select

TxtMERK.Text = MERK

TxtHS.Text = HS

 

End Sub

 

Private Sub ComdEXIT_Click()

Unload Me

End Sub

 

Private Sub ComdLAGI_Click()

CbKODE.SetFocus

CbKODE.Text = “”

TxtMERK.Text = “”

TxtHS.Text = “”

TxtJUAL.Text = “”

TxtPENJU.Text = “”

Txtdisco.Text = “”

TxtTOTAL.Text = “”

End Sub

 

Private Sub ComdPROSES_Click()

TxtPENJU.Text = Val(TxtJUAL.Text) * Val(TxtHS.Text)

If Val(TxtPENJU.Text) > 140000000 Then

Txtdisco.Text = Val(TxtPENJU.Text) * 15 / 100

ElseIf Val(TxtPENJU.Text) > 135000000 Then

Txtdisco.Text = 10 / 100 * Val(TxtPENJU.Text)

ElseIf Val(TxtPENJU.Text) > “130000000” Then

Txtdisco.Text = 5 / 100 * Val(TxtPENJU.Text)

ElseIf Val(TxtPENJU.Text) > “125000000” Then

Txtdisco.Text = 2 / 100 * Val(TxtPENJU.Text)

 

End If

TxtTOTAL.Text = Val(TxtPENJU.Text) – Val(Txtdisco.Text)

 

End Sub

 

Private Sub Command1_Click()

Data1.Recordset.Update

Data1.Recordset.MoveNext

End Sub

 

Private Sub Command2_Click()

Data1.Recordset.AddNew

Data1.Recordset.MoveNext

End Sub

 

Private Sub Command3_Click()

Data1.Recordset.Delete

End Sub

 

Private Sub Form_Load()

CbKODE.AddItem “Apple MC965 MacBook Air”

CbKODE.AddItem “Apple MC966 MacBook Air”

CbKODE.AddItem “Apple MC968 MacBook Air”

CbKODE.AddItem “Apple MC969 MacBook Air”

CbKODE.AddItem “Apple MC700 MacBook Pro”

CbKODE.AddItem “Apple MC721 MacBook Pro”

CbKODE.AddItem “Apple MC723 MacBook Pro”

CbKODE.AddItem “Apple MC724 MacBook Pro”

CbKODE.AddItem “Apple MC311 MacBook Pro”

CbKODE.AddItem “Apple MC313 MacBook Pro”

CbKODE.AddItem “Apple MC314 MacBook Pro”

CbKODE.AddItem “Apple MC318 MacBook Pro”

CbKODE.AddItem “Apple MC322 MacBook Pro”

CbKODE.AddItem “Apple MC965 MacBook Air”

CbKODE.AddItem “Apple MC966 MacBook Air”

End Sub

 

5.

D5

 

 

  1. 5. Private Sub Combo1_Change()

 

End Sub

 

Private Sub CbKODE_Click()

Dim JK, HS, JJ, HP, DISCO, TOTAL As Variant

Select Case CbKODE.Text

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

TxtJK.Text = JK

TxtHS.Text = HS

TxtJJ.SetFocus

 

End Sub

 

Private Sub ComdEXIT_Click()

Unload Me

End Sub

 

Private Sub ComdLAGI_Click()

CbKODE.SetFocus

CbKODE.Text = “”

TxtJK.Text = “”

TxtHS.Text = “”

TxtJJ.Text = “”

TxtHP.Text = “”

TxtDISCO.Text = “”

TxtTOTAL.Text = “”

 

End Sub

 

Private Sub ComdPROSES_Click()

TxtHP.Text = Val(TxtHS) * Val(TxtJJ.Text)

If Val(TxtHP.Text) > 30000000 Then

TxtDISCO.Text = Val(TxtHP.Text) * 15 / 100

ElseIf Val(TxtHP.Text) > 25000000 Then

TxtDISCO.Text = 10 / 100 * Val(TxtHP.Text)

ElseIf Val(TxtHP.Text) > “20000000” Then

TxtDISCO.Text = 5 / 100 * Val(TxtHP.Text)

ElseIf Val(TxtHP.Text) > “15000000” Then

TxtDISCO.Text = 2 / 100 * Val(TxtHP.Text)

End If

TxtTOTAL.Text = Val(TxtHP.Text) – Val(TxtDISCO)

 

End Sub

 

Private Sub Command1_Click()

Data1.Recordset.Update

End Sub

 

Private Sub Command2_Click()

Data1.Recordset.AddNew

End Sub

 

Private Sub Command3_Click()

Data1.Recordset.Delete

End Sub

 

Private Sub Form_Load()

CbKODE.AddItem “P205”

CbKODE.AddItem “P308”

CbKODE.AddItem “P310”

CbKODE.AddItem “P415”

CbKODE.AddItem “P417”

CbKODE.AddItem “P419”

End Sub

6.

D6

6.Private Sub ComdBATAL_Click()

Cbkode.SetFocus

Cbkode.Text = “”

Textjudul.Text = “”

Textpeng.Text = “”

TextTT.Text = “”

Textpene.Text = “”

Textharga.Text = “”

End Sub

 

Private Sub ComdKELUAR_Click()

Unload Me

End Sub

 

Private Sub ComdLAGI_Click()

Cbkode.SetFocus

Cbkode.Text = “”

Textjudul.Text = “”

Textpeng.Text = “”

TextTT.Text = “”

Textpene.Text = “”

Textharga.Text = “”

End Sub

 

Private Sub ComdPROSES_Click()

Dim judul, pengarang, harga As String

Y = Mid(Cbkode.Text, 3, 3)

If Y = “SIM” Then

Textjudul.Text = “Sistem Informasi Manajeme”

Textpeng.Text = “Yati Nur Oktavia”

Textharga.Text = “75900”

ElseIf Y = “EDP” Then

Textjudul.Text = “Elektronik Data Processing”

Textpeng.Text = “Imam Tarmizi”

Textharga.Text = “62000”

ElseIf Y = “CDR” Then

Textjudul.Text = “Corel Draw”

Textpeng.Text = “Riyan Suhandi”

Textharga.Text = “53000”

ElseIf Y = “MNJ” Then

Textjudul.Text = “Manajemen”

Textpeng.Text = “Valentina Mariana Adiwianti”

Textharga.Text = “42000”

ElseIf Y = “RPL” Then

Textjudul.Text = “Rekayasa Perangkat Lunak”

Textpeng.Text = “Sinta Umpu Singa”

Textharga.Text = “83000”

End If

TextTT.Text = “20” & Right(Cbkode.Text, 2)

Dim S As String

S = Left(Cbkode.Text, 1)

If S = “A” Then

Textpene.Text = “Andi Offset Yogyakarta”

ElseIf S = “I” Then

Textpene.Text = “Indah Surabaya”

S = Left(Cbkode.Text, 1)

ElseIf S = “S” Then

Textpene.Text = “Salemba Empat”

ElseIf S = “M” Then

Textpene.Text = “Maxicom”

ElseIf S = “E” Then

Textpene.Text = “Elek Media Komputindo”

 

End If

 

End Sub

 

Private Sub Command1_Click()

Data1.Recordset.AddNew

End Sub

 

Private Sub Command2_Click()

Data1.Recordset.Update

End Sub

 

Private Sub Command3_Click()

Data1.Recordset.Delete

End Sub

 

Private Sub Form_Load()

Cbkode.AddItem “A-SIM-01”

Cbkode.AddItem “I-EDP-02”

Cbkode.AddItem “S-MNJ-03”

Cbkode.AddItem “E-CDR-04”

Cbkode.AddItem “M-RPL-05”

 

End Sub

 

7.

D7

 

7.Private Sub ComdKELUAR_Click()

Unload Me

End Sub

 

Private Sub ComdLAGI_Click()

TextKODE.SetFocus

TextKODE.Text = “”

TextHARGA.Text = “”

TextJK.Text = “”

TextJB.Text = “”

TextJT.Text = “”

TextTOTAL.Text = “”

End Sub

 

Private Sub ComdPROSES_Click()

Dim harga, A, jk, jb, jt As Variant

A = Left(TextKODE.Text, 3)

If A = “BIM” Then

TextHARGA.Text = “750000”

TextJK = “BIMA pringsewu”

TextJB.Text = “16:00”

ElseIf A = “EKO” Then

TextHARGA.Text = “40000”

TextJK = “EKONOMI Pringsewu”

TextJB.Text = “19:00”

ElseIf A = “MUT” Then

TextHARGA.Text = “1000000”

TextJK = “MUTIARA pringsewu”

TextJB.Text = “17:00”

ElseIf A = “SEN” Then

TextHARGA.Text = “85000”

TextJK = “SENJA pringsewu”

TextJB.Text = “20:00”

End If

TextJT.SetFocus

End Sub

 

Private Sub Command1_Click()

Data1.Recordset.Update

End Sub

 

Private Sub Command2_Click()

Data1.Recordset.AddNew

End Sub

 

Private Sub Command3_Click()

Data1.Recordset.Delete

End Sub

 

Private Sub TextJT_KeyPress(KeyAscii As Integer)

If KeyAscii = 13 Then

TextTOTAL.Text = Val(TextJT) * Val(TextHARGA)

End If

End Sub

 

8.

D8

8.Private Sub ComdKELUAR_Click()

Unload Me

End Sub

 

Private Sub ComdLAGI_Click()

TextKODE.SetFocus

TextKODE.Text = “”

TextHARGA.Text = “”

TextpENG.Text = “”

Textpene.Text = “”

TextTT.Text = “”

TextJB.Text = “”

End Sub

 

Private Sub ComdPROSES_Click()

Dim A As String

A = Left(TextKODE.Text, 3)

If A = “SIM” Then

TextJB.Text = “Sistem Informasi Manajemen”

TextpENG.Text = “RIYAN ALFARIZI”

TextHARGA.Text = “75900”

ElseIf A = “EDP” Then

TextJB.Text = “Elektronik Data Processing”

TextpENG.Text = “LAILATULROHMAH”

TextHARGA.Text = “62000”

ElseIf A = “MNJ” Then

TextJB.Text = “Manajemen”

TextpENG.Text = “DAVID BUDIANTO”

TextHARGA.Text = “82000”

ElseIf A = “CDR” Then

TextJB.Text = “Corel Draw”

TextpENG.Text = “GILBERT ALEX”

TextHARGA.Text = “53000”

ElseIf A = “RPL” Then

TextJB.Text = “Rekayasa Perangkat Lunak”

TextpENG.Text = “Winda Erlianti”

TextHARGA.Text = “83000”

End If

M = Right(TextKODE.Text, 1)

If M = “A” Then

Textpene.Text = “Andi Offset Yogyakarta”””

ElseIf M = “I” Then

Textpene.Text = “Indah Surabaya”

ElseIf M = “S” Then

Textpene.Text = “Salemba Empat”

ElseIf M = “E” Then

Textpene.Text = “Elek Media Komputindo”

ElseIf M = “M” Then

Textpene.Text = “Maxicom”

End If

TextTT.Text = “20” & Mid(TextKODE.Text, 5, 2)

End Sub

 

Private Sub Command1_Click()

Data1.Recordset.Update

End Sub

 

Private Sub Command2_Click()

Data1.Recordset.AddNew

End Sub

 

Private Sub Command3_Click()

Data1.Recordset.Delete

End Sub

 

9.

D9

 

Private Sub ComdBATAL_Click()

TextNAMA.SetFocus

TextNAMA.Text = “”

TextNIK.Text = “”

TextGOL.Text = “”

TextKODE.Text = “”

TextSTAT.Text = “”

TextTAHU.Text = “”

TextJABA.Text = “”

TextBAGI.Text = “”

TextGAPOK.Text = “”

TextTUNJA.Text = “”

TextTOTAL.Text = “”

End Sub

 

Private Sub ComdKELUAR_Click()

Unload Me

End Sub

 

Private Sub ComdLAGI_Click()

TextNAMA.SetFocus

TextNAMA.Text = “”

TextNIK.Text = “”

TextGOL.Text = “”

TextKODE.Text = “”

TextSTAT.Text = “”

TextTAHU.Text = “”

TextJABA.Text = “”

TextBAGI.Text = “”

TextGAPOK.Text = “”

TextTUNJA.Text = “”

TextTOTAL.Text = “”

End Sub

 

Private Sub ComdPROSES_Click()

Dim GOL, KODE, GAPOK, TOTAL, Y, TUNJA As Variant

TextTAHU.Text = Left(TextNIK.Text, 4)

Y = Mid(TextNIK.Text, 5, 1)

If Y = “A” Then

TextGOL.Text = “A”

TextJABA.Text = “MANAJER”

TextGAPOK.Text = “4000000”

TextTUNJA.Text = “1025000”

ElseIf Y = “B” Then

TextGOL.Text = “B”

TextJABA.Text = “KA.SEKSI”

Text.GAPOK.Text = “3500000”

TextTUNJA.Text = “975000”

ElseIf Y = “C” Then

TextGOL.Text = “C”

TextJABA.Text = “STAFF”

TextTUNJA.Text = “925000”

TextGAPOK.Text = “3000000”

End If

Y = Right(TextNIK.Text, 3)

If Y = “ADM” Then

TextBAGI.Text = “Administrasi”

ElseIf Y = “KEU” Then

TextBAGI.Text = “Accounting”

ElseIf Y = “SDM” Then

TextBAGI.Text = “General Affair”

ElseIf Y = “EDP” Then

TextBAGI.Text = “IT Unit”

ElseIf Y = “SPM” Then

TextBAGI.Text = “Security”

End If

Y = Mid(TextNIK.Text, 7, 1)

If Y = “S” Then

TextKODE.Text = “S”

TextSTAT.Text = “Single”

ElseIf Y = “M” Then

TextKODE.Text = “M”

TextSTAT.Text = “Menikah”

ElseIf Y = “J” Then

TextKODE.Text = “”

TextSTAT.Text = “Janda”

ElseIf Y = “D” Then

TextKODE.Text = “D”

TextSTAT.Text = “Duda”

End If

TextTOTAL.Text = Val(TextGAPOK) + Val(TextTUNJA)

 

End Sub

 

Private Sub Command1_Click()

Data1.Recordset.Update

End Sub

 

Private Sub Command2_Click()

Data1.Recordset.AddNew

End Sub

 

Private Sub Command3_Click()

Data1.Recordset.Delete

End Sub

 

Private Sub TextNAMA_KeyPress(KeyAscii As Integer)

If KeyAscii = 13 Then

TextNIK.SetFocus

End If

End Sub

 

10.

DATA 10

  1. Private Sub Text3_Change()

End Sub

Private Sub Text2_Change()

 

End Sub

 

Private Sub Command1_Click()

txtkode.SetFocus

End Sub

 

Private Sub Command2_Click()

txtkode.SetFocus

txtkode.Text = “”

textnb.Text = “”

txthb.Text = “”

txtjb.Text = “”

txtby.Text = “”

txtpot.Text = “”

txtttb.Text = “”

End Sub

 

Private Sub Command3_Click()

txtby.Text = Val(txthb.Text) * Val(txtjb.Text)

If txtjb.Text > 5 Then

txtpot.Text = 2 / 100 * Val(txtby.Text)

ElseIf txtjb.Text < 5 Then

txtpot.Text = 1 * Val(txtby.Text)

End If

txtttb.Text = Val(txtby.Text) – Val(txtpot.Text)

End Sub

 

Private Sub Command4_Click()

Form2.Show

Unload Me

End Sub

 

Private Sub Command5_Click()

Data1.Recordset.AddNew

 

 

End Sub

 

Private Sub Command6_Click()

Dim nama, harga As String

Y = Mid(txtkode.Text, 5, 2)

If Y = “SP” Then

textnb.Text = “SPIDOL”

txthb.Text = “9500”

ElseIf Y = “BT” Then

textnb.Text = “buku tulis”

txthb.Text = “12500”

ElseIf Y = “TP” Then

textnb.Text = “TIPE EX”

txthb.Text = “3000”

ElseIf Y = “PG” Then

textnb.Text = “PENGGARIS”

txthb.Text = “25000”

ElseIf Y = “PT” Then

textnb.Text = “PAPAN TULIS”

txthb.Text = “50000”

 

End If

txtjb.SetFocus

End Sub

 

Private Sub Command1_Click()

Unload Me

End Sub

 

Private Sub Command2_Click()

Form1.Show

End Sub

15100053_DAVID BUDIANTO

TUGAS PROGRAM 1 SAMPAI 9

 

PROGRAM 1

program 1

Private Sub Cbgolongan_load()
cbogolongan.AddItem “I”
cbogolongan.AddItem “II”
cbogolongan.AddItem “III”
cbogolongan.AddItem “IV”

End Sub

Private Sub Cbgolongan_Click()
Dim gapok, pajak, tunjangan, total As Variant
Select Case Cbgolongan.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
TxtTUNJA.Text = tunjangan
TxtPAJAK.Text = pajak
TxtTOTAL.Text = total – pajak
End Sub
Private Sub Command3_Click()
Unload Me
End Sub

Private Sub ComdBATAL_Click()
kosong
End Sub
Public Sub kosong()
TxtNIDN.SetFocus
TxtNIDN.Text = “”
TxtNAMA.Text = “”
Cbgolongan.Text = “”
TxtGAPOK.Text = “”
TxtTUNJA.Text = “”
TxtPAJAK.Text = “”
TxtTOTAL.Text = “”
End Sub
Private Sub ComDKELUAR_Click()
Unload Me
End Sub

Private Sub ComdLAGI_Click()
kosong
End Sub
Private Sub Form_Load()
Cbgolongan.AddItem “I”
Cbgolongan.AddItem “II”
Cbgolongan.AddItem “III”
Cbgolongan.AddItem “IV”

End Sub
Private Sub TxtNIDN_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
TxtNAMA.SetFocus
End If

End Sub

PROGRAM 2

PROGRAM 2
Private Sub cmdbatal_Click()
Textnama.SetFocus
Textnama = “”
Textnpm = “”
Textjur = “”
Textps = “”
Texttm = “”
Textnu = “”
End Sub

Private Sub cmdkeluar_Click()
End
End Sub

Private Sub cmdlagi_Click()
Textnama.SetFocus
Textnama = “”
Textnpm = “”
Textjur = “”
Textps = “”
Texttm = “”
Textnu = “”
End Sub

Private Sub Cmdproses_Click()
Dim jr As String
Dim ps As String
Dim A As String
A = Mid(Textnpm, 3, 1)
If A = 1 Then
jr = “sistem informasi”
ElseIf A = 2 Then
jr = “teknik informatika”
ElseIf A = 3 Then
jr = “menejemen informatika”
ElseIf A = 4 Then
jr = “komputer akuntansi”
End If
Textjur = jr

A = Mid(Textnpm, 4, 2)
If A = “01” Then
ps = “strata 1”
ElseIf A = “02” Then
ps = “diploma 4”
ElseIf A = “03” Then
ps = “diploma 3”
ElseIf A = “04” Then
ps = “diploma 2”
End If
Textps = ps
Texttm = “20” & Left(Textnpm, 2)
Textnu = Right(Textnpm, 3)

End Sub
Private Sub Textnama_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Textnpm.SetFocus
End If
End Sub
Private Sub Form_Load()

End Sub

 

 

 

 

PROGRAM 3

program 3

Private Sub cmdbatal_Click()
Textnama.SetFocus
Textnama = “”
Textnpm = “”
Textjur = “”
Textps = “”
Texttm = “”
Textnu = “”
End Sub

Private Sub Cmdkeluar_Click()
End
End Sub

Private Sub cmdlagi_Click()
Textnama.SetFocus
Textnama = “”
Textnpm = “”
Textjur = “”
Textps = “”
Texttm = “”
Textnu = “”
End Sub

Private Sub Cmdproses_Click()
Dim A As String
Texttm = “20” & Left(Textnpm, 2)
A = Mid(Textnpm, 3, 3)
If A = “100” Then
Textjur = “sistem informasi”
Textps = “strata 1”
ElseIf A = “200” Then
Textjur = “manajemen informatika”
Textps = “diploma 3”
ElseIf A = “300” Then
Textjur = “teknik informatika”
Textps = “diploma 4”
ElseIf A = “400” Then
Textjur = “komputer akutansi”
Textps = “diploma 2”
End If
Textnu = Right(Textnpm, 3)
End Sub

Private Sub Textnama_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Textnpm.SetFocus
End If
End Sub

 

 

PROGRAM 4

program 4

Private Sub Combo1_Change()

End Sub

Private Sub CbKODE_Click()
Dim MERK, HS As Variant
Select Case CbKODE.Text
Case “MC965”
MERK = “Apple MacBook Air MC965”
HS = 12800000
Case “MC966”
MERK = “Apple MacBook Air MC966”
HS = 15800000
Case “MC968”
MERK = “Apple MacBook Air MC968”
HS = 9900000
Case “MC969”
MERK = “Apple MacBook Air MC969”
HS = 11900000
Case “MC700”
MERK = “Apple MacBook Pro MC700”
HS = 10800000
Case “MC721”
MERK = “Apple MacBook Pro MC721”
HS = 15900000
Case “MC723”
MERK = “Apple MacBook Pro MC723”
HS = 19300000
Case “MC724”
MERK = “Apple MacBook Pro MC724”
HS = 13700000
Case “MC311”
MERK = “Apple MacBook Pro MC311”
HS = 24200000
Case “MC313”
MERK = “Apple MacBook Pro MC313”
HS = 11900000
Case “MC314”
MERK = “Apple MacBook Pro MC314”
HS = 14700000
Case “MC318”
MERK = “Apple MacBook Pro MC318”
HS = 17600000
Case “MC322”
MERK = “Apple MacBook Pro MC322”
HS = 21300000
Case “MC965”
MERK = “Apple MacBook Air MC965”
HS = 12800000
Case “MC966”
MERK = “Apple MacBook Air MC966”
HS = 15800000
End Select
TxtMERK.Text = MERK
TxtHS.Text = HS

End Sub

Private Sub ComdEXIT_Click()
Unload Me
End Sub

Private Sub ComdLAGI_Click()
CbKODE.SetFocus
CbKODE.Text = “”
TxtMERK.Text = “”
TxtHS.Text = “”
TxtJUAL.Text = “”
TxtPENJU.Text = “”
Txtdisco.Text = “”
TxtTOTAL.Text = “”
End Sub

Private Sub ComdPROSES_Click()
TxtPENJU.Text = Val(TxtJUAL.Text) * Val(TxtHS.Text)
If Val(TxtPENJU.Text) > 140000000 Then
Txtdisco.Text = Val(TxtPENJU.Text) * 15 / 100
ElseIf Val(TxtPENJU.Text) > 135000000 Then
Txtdisco.Text = 10 / 100 * Val(TxtPENJU.Text)
ElseIf Val(TxtPENJU.Text) > “130000000” Then
Txtdisco.Text = 5 / 100 * Val(TxtPENJU.Text)
ElseIf Val(TxtPENJU.Text) > “125000000” Then
Txtdisco.Text = 2 / 100 * Val(TxtPENJU.Text)

End If
TxtTOTAL.Text = Val(TxtPENJU.Text) – Val(Txtdisco.Text)

End Sub

Private Sub Form_Load()
CbKODE.AddItem “MC965”
CbKODE.AddItem “MC966”
CbKODE.AddItem “MC968”
CbKODE.AddItem “MC969”
CbKODE.AddItem “MC700”
CbKODE.AddItem “MC721”
CbKODE.AddItem “MC723”
CbKODE.AddItem “MC724”
CbKODE.AddItem “MC311”
CbKODE.AddItem “MC313”
CbKODE.AddItem “MC314”
CbKODE.AddItem “MC318”
CbKODE.AddItem “MC322”
CbKODE.AddItem “MC965”
CbKODE.AddItem “MC966”
End Sub

 

 

PROGRAM 5

program 5

Private Sub Combo1_Change()

End Sub

Private Sub CbKODE_Click()
Dim JK, HS, JJ, HP, DISCO, TOTAL As Variant
Select Case CbKODE.Text
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
TxtJK.Text = JK
TxtHS.Text = HS
TxtJJ.SetFocus

End Sub

Private Sub ComdEXIT_Click()
Unload Me
End Sub

Private Sub ComdLAGI_Click()
CbKODE.SetFocus
CbKODE.Text = “”
TxtJK.Text = “”
TxtHS.Text = “”
TxtJJ.Text = “”
TxtHP.Text = “”
TxtDISCO.Text = “”
TxtTOTAL.Text = “”

End Sub

Private Sub ComdPROSES_Click()
TxtHP.Text = Val(TxtHS) * Val(TxtJJ.Text)
If Val(TxtHP.Text) > 30000000 Then
TxtDISCO.Text = Val(TxtHP.Text) * 15 / 100
ElseIf Val(TxtHP.Text) > 25000000 Then
TxtDISCO.Text = 10 / 100 * Val(TxtHP.Text)
ElseIf Val(TxtHP.Text) > “20000000” Then
TxtDISCO.Text = 5 / 100 * Val(TxtHP.Text)
ElseIf Val(TxtHP.Text) > “15000000” Then
TxtDISCO.Text = 2 / 100 * Val(TxtHP.Text)
End If
TxtTOTAL.Text = Val(TxtHP.Text) – Val(TxtDISCO)

End Sub

Private Sub Form_Load()
CbKODE.AddItem “P205”
CbKODE.AddItem “P308”
CbKODE.AddItem “P310”
CbKODE.AddItem “P415”
CbKODE.AddItem “P417”
CbKODE.AddItem “P419”
End Sub

 

PROGRAM 6

program 6

Private Sub ComdBATAL_Click()
Cbkode.SetFocus
Cbkode.Text = “”
Textjudul.Text = “”
Textpeng.Text = “”
TextTT.Text = “”
Textpene.Text = “”
Textharga.Text = “”
End Sub

Private Sub ComdKELUAR_Click()
Unload Me
End Sub

Private Sub ComdLAGI_Click()
Cbkode.SetFocus
Cbkode.Text = “”
Textjudul.Text = “”
Textpeng.Text = “”
TextTT.Text = “”
Textpene.Text = “”
Textharga.Text = “”
End Sub

Private Sub ComdPROSES_Click()
Dim judul, pengarang, harga As String
Y = Mid(Cbkode.Text, 3, 3)
If Y = “SIM” Then
Textjudul.Text = “Sistem Informasi Manajeme”
Textpeng.Text = “Yati Nur Oktavia”
Textharga.Text = “75900”
ElseIf Y = “EDP” Then
Textjudul.Text = “Elektronik Data Processing”
Textpeng.Text = “Imam Tarmizi”
Textharga.Text = “62000”
ElseIf Y = “CDR” Then
Textjudul.Text = “Corel Draw”
Textpeng.Text = “Riyan Suhandi”
Textharga.Text = “53000”
ElseIf Y = “MNJ” Then
Textjudul.Text = “Manajemen”
Textpeng.Text = “Valentina Mariana Adiwianti”
Textharga.Text = “42000”
ElseIf Y = “RPL” Then
Textjudul.Text = “Rekayasa Perangkat Lunak”
Textpeng.Text = “Sinta Umpu Singa”
Textharga.Text = “83000”
End If
TextTT.Text = “20” & Right(Cbkode.Text, 2)
Dim S As String
S = Left(Cbkode.Text, 1)
If S = “A” Then
Textpene.Text = “Andi Offset Yogyakarta”
ElseIf S = “I” Then
Textpene.Text = “Indah Surabaya”
S = Left(Cbkode.Text, 1)
ElseIf S = “S” Then
Textpene.Text = “Salemba Empat”
ElseIf S = “M” Then
Textpene.Text = “Maxicom”
ElseIf S = “E” Then
Textpene.Text = “Elek Media Komputindo”

End If

End Sub

Private Sub Form_Load()
Cbkode.AddItem “A-SIM-01”
Cbkode.AddItem “I-EDP-0 2”
Cbkode.AddItem “S-MNJ-03”
Cbkode.AddItem “E-CDR-04”
Cbkode.AddItem “M-RPL-05”
End Sub

PROGRAM 7

program 7

Private Sub ComdKELUAR_Click()
Unload Me
End Sub

Private Sub ComdLAGI_Click()
TextKODE.SetFocus
TextKODE.Text = “”
TextHARGA.Text = “”
TextJK.Text = “”
TextJB.Text = “”
TextJT.Text = “”
TextTOTAL.Text = “”
End Sub

Private Sub ComdPROSES_Click()
Dim harga, A, jk, jb, jt As Variant
A = Left(TextKODE.Text, 3)
If A = “BIM” Then
TextHARGA.Text = “750000”
TextJK = “BIMA pringsewu”
TextJB.Text = “16:00”
ElseIf A = “EKO” Then
TextHARGA.Text = “40000”
TextJK = “EKONOMI Pringsewu”
TextJB.Text = “19:00”
ElseIf A = “MUT” Then
TextHARGA.Text = “1000000”
TextJK = “MUTIARA pringsewu”
TextJB.Text = “17:00”
ElseIf A = “SEN” Then
TextHARGA.Text = “85000”
TextJK = “SENJA pringsewu”
TextJB.Text = “20:00”
End If
TextJT.SetFocus
End Sub

Private Sub TextJT_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
TextTOTAL.Text = Val(TextJT) * Val(TextHARGA)
End If
End Sub

PROGRAM 8

program 8

Private Sub ComdKELUAR_Click()
Unload Me
End Sub

Private Sub ComdLAGI_Click()
TextKODE.SetFocus
TextKODE.Text = “”
TextHARGA.Text = “”
TextpENG.Text = “”
Textpene.Text = “”
TextTT.Text = “”
TextJB.Text = “”
End Sub

Private Sub ComdPROSES_Click()
Dim A As String
A = Left(TextKODE.Text, 3)
If A = “SIM” Then
TextJB.Text = “Sistem Informasi Manajemen”
TextpENG.Text = “Fadiya Ulfa”
TextHARGA.Text = “75900”
ElseIf A = “EDP” Then
TextJB.Text = “Elektronik Data Processing”
TextpENG.Text = “Nurul Agustinaa”
TextHARGA.Text = “62000”
ElseIf A = “MNJ” Then
TextJB.Text = “Manajemen”
TextpENG.Text = “Rian Hidayat”
TextHARGA.Text = “82000”
ElseIf A = “CDR” Then
TextJB.Text = “Corel Draw”
TextpENG.Text = “Siti Nur Khotimah”
TextHARGA.Text = “53000”
ElseIf A = “RPL” Then
TextJB.Text = “Rekayasa Perangkat Lunak”
TextpENG.Text = “Winda Erlianti”
TextHARGA.Text = “83000”
End If
M = Right(TextKODE.Text, 1)
If M = “A” Then
Textpene.Text = “Andi Offset Yogyakarta”””
ElseIf M = “I” Then
Textpene.Text = “Indah Surabaya”
ElseIf M = “S” Then
Textpene.Text = “Salemba Empat”
ElseIf M = “E” Then
Textpene.Text = “Elek Media Komputindo”
ElseIf M = “M” Then
Textpene.Text = “Maxicom”
End If
TextTT.Text = “20” & Mid(TextKODE.Text, 5, 2)
End Sub

Private Sub Form_Load()

End Sub

PROGRAM 9

PROGRAM 9

 

Private Sub ComdBATAL_Click()
TextNAMA.SetFocus
TextNAMA.Text = “”
TextNIK.Text = “”
TextGOL.Text = “”
TextKODE.Text = “”
TextSTAT.Text = “”
TextTAHU.Text = “”
TextJABA.Text = “”
TextBAGI.Text = “”
TextGAPOK.Text = “”
TextTUNJA.Text = “”
TextTOTAL.Text = “”
End Sub

Private Sub ComdKELUAR_Click()
Unload Me
End Sub

Private Sub ComdLAGI_Click()
TextNAMA.SetFocus
TextNAMA.Text = “”
TextNIK.Text = “”
TextGOL.Text = “”
TextKODE.Text = “”
TextSTAT.Text = “”
TextTAHU.Text = “”
TextJABA.Text = “”
TextBAGI.Text = “”
TextGAPOK.Text = “”
TextTUNJA.Text = “”
TextTOTAL.Text = “”
End Sub

Private Sub ComdPROSES_Click()
Dim GOL, KODE, GAPOK, TOTAL, Y, TUNJA As Variant
TextTAHU.Text = Left(TextNIK.Text, 4)
Y = Mid(TextNIK.Text, 5, 1)
If Y = “A” Then
TextGOL.Text = “A”
TextJABA.Text = “MANAJER”
TextGAPOK.Text = “4000000”
TextTUNJA.Text = “1025000”
ElseIf Y = “B” Then
TextGOL.Text = “B”
TextJABA.Text = “KA.SEKSI”
Text.APOK.Text = “3500000”
TextTUNJA.Text = “975000”
ElseIf Y = “C” Then
TextGOL.Text = “C”
TextJABA.Text = “STAFF”
TextTUNJA.Text = “925000”
TextGAPOK.Text = “3000000”
End If
Y = Right(TextNIK.Text, 3)
If Y = “ADM” Then
TextBAGI.Text = “Administrasi”
ElseIf Y = “KEU” Then
TextBAGI.Text = “Accounting”
ElseIf Y = “SDM” Then
TextBAGI.Text = “General Affair”
ElseIf Y = “EDP” Then
TextBAGI.Text = “IT Unit”
ElseIf Y = “SPM” Then
TextBAGI.Text = “Security”
End If
Y = Mid(TextNIK.Text, 7, 1)
If Y = “S” Then
TextKODE.Text = “S”
TextSTAT.Text = “Single”
ElseIf Y = “M” Then
TextKODE.Text = “M”
TextSTAT.Text = “Menikah”
ElseIf Y = “J” Then
TextKODE.Text = “”
TextSTAT.Text = “Janda”
ElseIf Y = “D” Then
TextKODE.Text = “D”
TextSTAT.Text = “Duda”
End If
TextTOTAL.Text = Val(TextGAPOK) + Val(TextTUNJA)

End Sub

Private Sub TextNAMA_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
TextNIK.SetFocus
End If
End Sub

 

 

 

 

 

 

 

 

 

 

 

 

 

program 3

program 3

 

Private Sub cmdbatal_Click()
Textnama.SetFocus
Textnama = “”
Textnpm = “”
Textjur = “”
Textps = “”
Texttm = “”
Textnu = “”
End Sub

Private Sub Cmdkeluar_Click()
End
End Sub

Private Sub cmdlagi_Click()
Textnama.SetFocus
Textnama = “”
Textnpm = “”
Textjur = “”
Textps = “”
Texttm = “”
Textnu = “”
End Sub

Private Sub Cmdproses_Click()
Dim A As String
Texttm = “20” & Left(Textnpm, 2)
A = Mid(Textnpm, 3, 3)
If A = “100” Then
Textjur = “sistem informasi”
Textps = “strata 1”
ElseIf A = “200” Then
Textjur = “manajemen informatika”
Textps = “diploma 3”
ElseIf A = “300” Then
Textjur = “teknik informatika”
Textps = “diploma 4”
ElseIf A = “400” Then
Textjur = “komputer akutansi”
Textps = “diploma 2”
End If
Textnu = Right(Textnpm, 3)
End Sub

Private Sub Form_Load()

End Sub

Private Sub Textnama_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Textnpm.SetFocus
End If
End Sub

 

program 2

PROGRAM 2
Private Sub cmdbatal_Click()
Textnama.SetFocus
Textnama = “”
Textnpm = “”
Textjur = “”
Textps = “”
Texttm = “”
Textnu = “”
End Sub

Private Sub cmdkeluar_Click()
End
End Sub

Private Sub cmdlagi_Click()
Textnama.SetFocus
Textnama = “”
Textnpm = “”
Textjur = “”
Textps = “”
Texttm = “”
Textnu = “”
End Sub

Private Sub Cmdproses_Click()
Dim jr As String
Dim ps As String
Dim A As String
A = Mid(Textnpm, 3, 1)
If A = 1 Then
jr = “sistem informasi”
ElseIf A = 2 Then
jr = “teknik informatika”
ElseIf A = 3 Then
jr = “menejemen informatika”
ElseIf A = 4 Then
jr = “komputer akuntansi”
End If
Textjur = jr

A = Mid(Textnpm, 4, 2)
If A = “01” Then
ps = “strata 1”
ElseIf A = “02” Then
ps = “diploma 4”
ElseIf A = “03” Then
ps = “diploma 3”
ElseIf A = “04” Then
ps = “diploma 2”
End If
Textps = ps
Texttm = “20” & Left(Textnpm, 2)
Textnu = Right(Textnpm, 3)

End Sub
Private Sub Form_Load()

End Sub

Private Sub Textnama_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Textnpm.SetFocus
End If
End Sub

 

program 1

program 1

 

Private Sub Cbgolongan_load()
cbogolongan.AddItem “I”
cbogolongan.AddItem “II”
cbogolongan.AddItem “III”
cbogolongan.AddItem “IV”

End Sub

Private Sub Cbgolongan_Click()
Dim gapok, pajak, tunjangan, total As Variant
Select Case Cbgolongan.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
TxtTUNJA.Text = tunjangan
TxtPAJAK.Text = pajak
TxtTOTAL.Text = total – pajak
End Sub
Private Sub Command3_Click()
Unload Me
End Sub

Private Sub ComdBATAL_Click()
kosong
End Sub
Public Sub kosong()
TxtNIDN.SetFocus
TxtNIDN.Text = “”
TxtNAMA.Text = “”
Cbgolongan.Text = “”
TxtGAPOK.Text = “”
TxtTUNJA.Text = “”
TxtPAJAK.Text = “”
TxtTOTAL.Text = “”
End Sub
Private Sub ComDKELUAR_Click()
Unload Me
End Sub

Private Sub ComdLAGI_Click()
kosong
End Sub
Private Sub Form_Load()
Cbgolongan.AddItem “I”
Cbgolongan.AddItem “II”
Cbgolongan.AddItem “III”
Cbgolongan.AddItem “IV”

End Sub
Private Sub TxtNIDN_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
TxtNAMA.SetFocus
End If

End Sub

 

PROGRAM 9

 

Private Sub Cmdbatal_Click()
Textnama.SetFocus
Textnama = “”
Textnik = “”
Textgol = “”
Textks = “”
Textstt = “”
Textt = “”
Textjab = “”
Textbag = “”
Textgp = “”
Texttun = “”
Texttg = “”
End Sub

Private Sub cmdkeluar_Click()
End
End Sub

Private Sub Cmdlagi_Click()
Textnama.SetFocus
Textnama = “”
Textnik = “”
Textgol = “”
Textks = “”
Textstt = “”
Textt = “”
Textjab = “”
Textbag = “”
Textgp = “”
Texttun = “”
Texttg = “”
End Sub

Private Sub Cmdproses_Click()
Dim r As String
r = Mid(Textnik.Text, 5, 1)
If r = “A” Then
Textgol = “A”
Textjab.Text = “MANAGER”
Textgp.Text = “4000000”
Texttun.Text = “1025000”
ElseIf r = “B” Then
Textgol.Text = “B”
Textjab.Text = “Ka.SEKSI”
Textgp.Text = “3500000”
Texttun.Text = “975000”
ElseIf r = “C” Then
Textgol.Text = “C”
Textjab.Text = “STAFF”
Textgp.Text = “3000000”
Texttun.Text = “925000”
End If
r = Right(Textnik.Text, 3)
If r = “KEU” Then
Textbag.Text = “ACCOUNTING”
ElseIf r = “ADM” Then
Textbag.Text = “ADMINISTRASI”
ElseIf r = “SDM” Then
Textbag.Text = “GENERAL AFFAIR”
ElseIf r = “EDP” Then
Textbag.Text = “IT UNIT”
ElseIf r = “SPM” Then
Textbag.Text = “SECURITY”
End If
r = Mid(Textnik.Text, 7, 1)
If r = “S” Then
ks = “S”
Stt = “SINGLE”
ElseIf r = “M” Then
ks = “M”
Stt = “MENIKAH”
ElseIf r = “J” Then
ks = “J”
Stt = “JANDA”
ElseIf r = “D” Then
ks = “D”
Stt = “DUDA”
End If
Textks.Text = ks
Textstt.Text = Stt
Textt.Text = Left(Textnik.Text, 4)
Texttg.Text = Val(Textgp.Text) + Val(Texttun.Text)
End Sub
Private Sub Form_Activate()
Textnama.SetFocus
End Sub

Private Sub Textnama_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Textnik.SetFocus
End If
End Sub

 

program 8

program 8

 

Private Sub ComdKELUAR_Click()
Unload Me
End Sub

Private Sub ComdLAGI_Click()
TextKODE.SetFocus
TextKODE.Text = “”
TextHARGA.Text = “”
TextpENG.Text = “”
Textpene.Text = “”
TextTT.Text = “”
TextJB.Text = “”
End Sub

Private Sub ComdPROSES_Click()
Dim A As String
A = Left(TextKODE.Text, 3)
If A = “SIM” Then
TextJB.Text = “Sistem Informasi Manajemen”
TextpENG.Text = “Fadiya Ulfa”
TextHARGA.Text = “75900”
ElseIf A = “EDP” Then
TextJB.Text = “Elektronik Data Processing”
TextpENG.Text = “Nurul Agustinaa”
TextHARGA.Text = “62000”
ElseIf A = “MNJ” Then
TextJB.Text = “Manajemen”
TextpENG.Text = “Rian Hidayat”
TextHARGA.Text = “82000”
ElseIf A = “CDR” Then
TextJB.Text = “Corel Draw”
TextpENG.Text = “Siti Nur Khotimah”
TextHARGA.Text = “53000”
ElseIf A = “RPL” Then
TextJB.Text = “Rekayasa Perangkat Lunak”
TextpENG.Text = “Winda Erlianti”
TextHARGA.Text = “83000”
End If
M = Right(TextKODE.Text, 1)
If M = “A” Then
Textpene.Text = “Andi Offset Yogyakarta”””
ElseIf M = “I” Then
Textpene.Text = “Indah Surabaya”
ElseIf M = “S” Then
Textpene.Text = “Salemba Empat”
ElseIf M = “E” Then
Textpene.Text = “Elek Media Komputindo”
ElseIf M = “M” Then
Textpene.Text = “Maxicom”
End If
TextTT.Text = “20” & Mid(TextKODE.Text, 5, 2)
End Sub

Private Sub Form_Load()

End Sub

 

program 7

program 7

Private Sub Cmdkeluar_Click()
End
End Sub

Private Sub cmdlagi_Click()
Textkt.SetFocus
Textkt = “”
Textht = “”
Textjk = “”
Textjb = “”
Textjt = “”
Texttp = “”
End Sub

Private Sub cmdproses_Click()
Dim S As String
S = Left(Textkt.Text, 3)
If S = “BIM” Or S = “bim” Then
Textjk.Text = “BIMA”
Textht.Text = “50000”
Textjb.Text = “16.00 WIB”
ElseIf S = “EKO” Or S = “eko” Then
Textjk.Text = “EKONOMI”
Textht.Text = “35000”
Textjb.Text = “19.00 WIB”
ElseIf S = “MUT” Or S = “mut” Then
Textjk.Text = “MUTIARA”
Textht.Text = “23000”
Textjb.Text = “17.00 WIB”
ElseIf S = “SEN” Or S = “sen” Then
Textjk.Text = “SENJA”
Textht.Text = “15000”
Textjb.Text = “20.00 WIB”
End If
Textjt.SetFocus
End Sub
Private Sub Form_Load()

End Sub

Private Sub Textjt_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Texttp = Val(Textht) * Val(Textjt)
End If
End Sub

 

program 6

program 6

 

Private Sub ComdBATAL_Click()
Cbkode.SetFocus
Cbkode.Text = “”
Textjudul.Text = “”

Private Sub ComdBATAL_Click()
Cbkode.SetFocus
Cbkode.Text = “”
Textjudul.Text = “”
Textpeng.Text = “”
TextTT.Text = “”
Textpene.Text = “”
Textharga.Text = “”
End Sub

Private Sub ComdKELUAR_Click()
Unload Me
End Sub

Private Sub ComdLAGI_Click()
Cbkode.SetFocus
Cbkode.Text = “”
Textjudul.Text = “”
Textpeng.Text = “”
TextTT.Text = “”
Textpene.Text = “”
Textharga.Text = “”
End Sub

Private Sub ComdPROSES_Click()
Dim judul, pengarang, harga As String
Y = Mid(Cbkode.Text, 3, 3)
If Y = “SIM” Then
Textjudul.Text = “Sistem Informasi Manajeme”
Textpeng.Text = “Yati Nur Oktavia”
Textharga.Text = “75900”
ElseIf Y = “EDP” Then
Textjudul.Text = “Elektronik Data Processing”
Textpeng.Text = “Imam Tarmizi”
Textharga.Text = “62000”
ElseIf Y = “CDR” Then
Textjudul.Text = “Corel Draw”
Textpeng.Text = “Riyan Suhandi”
Textharga.Text = “53000”
ElseIf Y = “MNJ” Then
Textjudul.Text = “Manajemen”
Textpeng.Text = “Valentina Mariana Adiwianti”
Textharga.Text = “42000”
ElseIf Y = “RPL” Then
Textjudul.Text = “Rekayasa Perangkat Lunak”
Textpeng.Text = “Sinta Umpu Singa”
Textharga.Text = “83000”
End If
TextTT.Text = “20” & Right(Cbkode.Text, 2)
Dim S As String
S = Left(Cbkode.Text, 1)
If S = “A” Then
Textpene.Text = “Andi Offset Yogyakarta”
ElseIf S = “I” Then
Textpene.Text = “Indah Surabaya”
S = Left(Cbkode.Text, 1)
ElseIf S = “S” Then
Textpene.Text = “Salemba Empat”
ElseIf S = “M” Then
Textpene.Text = “Maxicom”
ElseIf S = “E” Then
Textpene.Text = “Elek Media Komputindo”

End If

End Sub

Private Sub Form_Load()
Cbkode.AddItem “A-SIM-01”
Cbkode.AddItem “I-EDP-0 2”
Cbkode.AddItem “S-MNJ-03”
Cbkode.AddItem “E-CDR-04”
Cbkode.AddItem “M-RPL-05”
End Sub

Private Sub Frame1_DragDrop(Source As Control, X As Single, Y As Single)

End Sub
Textpeng.Text = “”
TextTT.Text = “”
Textpene.Text = “”
Textharga.Text = “”
End Sub

Private Sub ComdKELUAR_Click()
Unload Me
End Sub

Private Sub ComdLAGI_Click()
Cbkode.SetFocus
Cbkode.Text = “”
Textjudul.Text = “”
Textpeng.Text = “”
TextTT.Text = “”
Textpene.Text = “”
Textharga.Text = “”
End Sub

Private Sub ComdPROSES_Click()
Dim judul, pengarang, harga As String
Y = Mid(Cbkode.Text, 3, 3)
If Y = “SIM” Then
Textjudul.Text = “Sistem Informasi Manajeme”
Textpeng.Text = “Yati Nur Oktavia”
Textharga.Text = “75900”
ElseIf Y = “EDP” Then
Textjudul.Text = “Elektronik Data Processing”
Textpeng.Text = “Imam Tarmizi”
Textharga.Text = “62000”
ElseIf Y = “CDR” Then
Textjudul.Text = “Corel Draw”
Textpeng.Text = “Riyan Suhandi”
Textharga.Text = “53000”
ElseIf Y = “MNJ” Then
Textjudul.Text = “Manajemen”
Textpeng.Text = “Valentina Mariana Adiwianti”
Textharga.Text = “42000”
ElseIf Y = “RPL” Then
Textjudul.Text = “Rekayasa Perangkat Lunak”
Textpeng.Text = “Sinta Umpu Singa”
Textharga.Text = “83000”
End If
TextTT.Text = “20” & Right(Cbkode.Text, 2)
Dim S As String
S = Left(Cbkode.Text, 1)
If S = “A” Then
Textpene.Text = “Andi Offset Yogyakarta”
ElseIf S = “I” Then
Textpene.Text = “Indah Surabaya”
S = Left(Cbkode.Text, 1)
ElseIf S = “S” Then
Textpene.Text = “Salemba Empat”
ElseIf S = “M” Then
Textpene.Text = “Maxicom”
ElseIf S = “E” Then
Textpene.Text = “Elek Media Komputindo”

End If

End Sub

Private Sub Form_Load()
Cbkode.AddItem “A-SIM-01”
Cbkode.AddItem “I-EDP-0 2”
Cbkode.AddItem “S-MNJ-03”
Cbkode.AddItem “E-CDR-04”
Cbkode.AddItem “M-RPL-05”
End Sub

Private Sub Frame1_DragDrop(Source As Control, X As Single, Y As Single)

End Sub

 

 

DAVID BUDIANTO 15100053

program 5

program 5

Private Sub Combo1_Change()

End Sub

Private Sub CbKODE_Click()
Dim JK, HS, JJ, HP, DISCO, TOTAL As Variant
Select Case CbKODE.Text
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
TxtJK.Text = JK
TxtHS.Text = HS
TxtJJ.SetFocus

End Sub

Private Sub ComdEXIT_Click()
Unload Me
End Sub

Private Sub ComdLAGI_Click()
CbKODE.SetFocus
CbKODE.Text = “”
TxtJK.Text = “”
TxtHS.Text = “”
TxtJJ.Text = “”
TxtHP.Text = “”
TxtDISCO.Text = “”
TxtTOTAL.Text = “”

End Sub

Private Sub ComdPROSES_Click()
TxtHP.Text = Val(TxtHS) * Val(TxtJJ.Text)
If Val(TxtHP.Text) > 30000000 Then
TxtDISCO.Text = Val(TxtHP.Text) * 15 / 100
ElseIf Val(TxtHP.Text) > 25000000 Then
TxtDISCO.Text = 10 / 100 * Val(TxtHP.Text)
ElseIf Val(TxtHP.Text) > “20000000” Then
TxtDISCO.Text = 5 / 100 * Val(TxtHP.Text)
ElseIf Val(TxtHP.Text) > “15000000” Then
TxtDISCO.Text = 2 / 100 * Val(TxtHP.Text)
End If
TxtTOTAL.Text = Val(TxtHP.Text) – Val(TxtDISCO)

End Sub

Private Sub Form_Load()
CbKODE.AddItem “P205”
CbKODE.AddItem “P308”
CbKODE.AddItem “P310”
CbKODE.AddItem “P415”
CbKODE.AddItem “P417”
CbKODE.AddItem “P419”
End Sub

Private Sub Frame1_DragDrop(Source As Control, X As Single, Y As Single)

End Sub

program 4

 

 

program 4

Private Sub Combo1_Change()

End Sub

Private Sub CbKODE_Click()
Dim MERK, HS As Variant
Select Case CbKODE.Text
Case “MC965”
MERK = “Apple MacBook Air MC965”
HS = 12800000
Case “MC966”
MERK = “Apple MacBook Air MC966”
HS = 15800000
Case “MC968”
MERK = “Apple MacBook Air MC968”
HS = 9900000
Case “MC969”
MERK = “Apple MacBook Air MC969”
HS = 11900000
Case “MC700”
MERK = “Apple MacBook Pro MC700”
HS = 10800000
Case “MC721”
MERK = “Apple MacBook Pro MC721”
HS = 15900000
Case “MC723”
MERK = “Apple MacBook Pro MC723”
HS = 19300000
Case “MC724”
MERK = “Apple MacBook Pro MC724”
HS = 13700000
Case “MC311”
MERK = “Apple MacBook Pro MC311”
HS = 24200000
Case “MC313”
MERK = “Apple MacBook Pro MC313”
HS = 11900000
Case “MC314”
MERK = “Apple MacBook Pro MC314”
HS = 14700000
Case “MC318”
MERK = “Apple MacBook Pro MC318”
HS = 17600000
Case “MC322”
MERK = “Apple MacBook Pro MC322”
HS = 21300000
Case “MC965”
MERK = “Apple MacBook Air MC965”
HS = 12800000
Case “MC966”
MERK = “Apple MacBook Air MC966”
HS = 15800000
End Select
TxtMERK.Text = MERK
TxtHS.Text = HS

End Sub

Private Sub ComdEXIT_Click()
Unload Me
End Sub

Private Sub ComdLAGI_Click()
CbKODE.SetFocus
CbKODE.Text = “”
TxtMERK.Text = “”
TxtHS.Text = “”
TxtJUAL.Text = “”
TxtPENJU.Text = “”
Txtdisco.Text = “”
TxtTOTAL.Text = “”
End Sub

Private Sub ComdPROSES_Click()
TxtPENJU.Text = Val(TxtJUAL.Text) * Val(TxtHS.Text)
If Val(TxtPENJU.Text) > 140000000 Then
Txtdisco.Text = Val(TxtPENJU.Text) * 15 / 100
ElseIf Val(TxtPENJU.Text) > 135000000 Then
Txtdisco.Text = 10 / 100 * Val(TxtPENJU.Text)
ElseIf Val(TxtPENJU.Text) > “130000000” Then
Txtdisco.Text = 5 / 100 * Val(TxtPENJU.Text)
ElseIf Val(TxtPENJU.Text) > “125000000” Then
Txtdisco.Text = 2 / 100 * Val(TxtPENJU.Text)

End If
TxtTOTAL.Text = Val(TxtPENJU.Text) – Val(Txtdisco.Text)

End Sub

Private Sub Form_Load()
CbKODE.AddItem “MC965”
CbKODE.AddItem “MC966”
CbKODE.AddItem “MC968”
CbKODE.AddItem “MC969”
CbKODE.AddItem “MC700”
CbKODE.AddItem “MC721”
CbKODE.AddItem “MC723”
CbKODE.AddItem “MC724”
CbKODE.AddItem “MC311”
CbKODE.AddItem “MC313”
CbKODE.AddItem “MC314”
CbKODE.AddItem “MC318”
CbKODE.AddItem “MC322”
CbKODE.AddItem “MC965”
CbKODE.AddItem “MC966”
End Sub

program 3

program 3

Private Sub cmdbatal_Click()
Textnama.SetFocus
Textnama = “”
Textnpm = “”
Textjur = “”
Textps = “”
Texttm = “”
Textnu = “”
End Sub

Private Sub Cmdkeluar_Click()
End
End Sub

Private Sub cmdlagi_Click()
Textnama.SetFocus
Textnama = “”
Textnpm = “”
Textjur = “”
Textps = “”
Texttm = “”
Textnu = “”
End Sub

Private Sub Cmdproses_Click()
Dim A As String
Texttm = “20” & Left(Textnpm, 2)
A = Mid(Textnpm, 3, 3)
If A = “100” Then
Textjur = “sistem informasi”
Textps = “strata 1”
ElseIf A = “200” Then
Textjur = “manajemen informatika”
Textps = “diploma 3”
ElseIf A = “300” Then
Textjur = “teknik informatika”
Textps = “diploma 4”
ElseIf A = “400” Then
Textjur = “komputer akutansi”
Textps = “diploma 2”
End If
Textnu = Right(Textnpm, 3)
End Sub

Private Sub Textjur_Change()

End Sub

Private Sub Textnama_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Textnpm.SetFocus
End If
End Sub

program 2

PROGRAM 2
Private Sub cmdbatal_Click()
Textnama.SetFocus
Textnama = “”
Textnpm = “”
Textjur = “”
Textps = “”
Texttm = “”
Textnu = “”
End Sub

Private Sub cmdkeluar_Click()
End
End Sub

Private Sub cmdlagi_Click()
Textnama.SetFocus
Textnama = “”
Textnpm = “”
Textjur = “”
Textps = “”
Texttm = “”
Textnu = “”
End Sub

Private Sub Cmdproses_Click()
Dim jr As String
Dim ps As String
Dim A As String
A = Mid(Textnpm, 3, 1)
If A = 1 Then
jr = “sistem informasi”
ElseIf A = 2 Then
jr = “teknik informatika”
ElseIf A = 3 Then
jr = “menejemen informatika”
ElseIf A = 4 Then
jr = “komputer akuntansi”
End If
Textjur = jr

A = Mid(Textnpm, 4, 2)
If A = “01” Then
ps = “strata 1”
ElseIf A = “02” Then
ps = “diploma 4”
ElseIf A = “03” Then
ps = “diploma 3”
ElseIf A = “04” Then
ps = “diploma 2”
End If
Textps = ps
Texttm = “20” & Left(Textnpm, 2)
Textnu = Right(Textnpm, 3)

End Sub
Private Sub Textnama_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Textnpm.SetFocus
End If
End Sub

program 1

program 1Private Sub Cbgolongan_load()
cbogolongan.AddItem “I”
cbogolongan.AddItem “II”
cbogolongan.AddItem “III”
cbogolongan.AddItem “IV”

End Sub

Private Sub Cbgolongan_Click()
Dim gapok, pajak, tunjangan, total As Variant
Select Case Cbgolongan.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
TxtTUNJA.Text = tunjangan
TxtPAJAK.Text = pajak
TxtTOTAL.Text = total – pajak
End Sub
Private Sub Command3_Click()
Unload Me
End Sub

Private Sub ComdBATAL_Click()
kosong
End Sub
Public Sub kosong()
TxtNIDN.SetFocus
TxtNIDN.Text = “”
TxtNAMA.Text = “”
Cbgolongan.Text = “”
TxtGAPOK.Text = “”
TxtTUNJA.Text = “”
TxtPAJAK.Text = “”
TxtTOTAL.Text = “”
End Sub
Private Sub ComDKELUAR_Click()
Unload Me
End Sub

Private Sub ComdLAGI_Click()
kosong
End Sub
Private Sub Form_Load()
Cbgolongan.AddItem “I”
Cbgolongan.AddItem “II”
Cbgolongan.AddItem “III”
Cbgolongan.AddItem “IV”

End Sub
Private Sub TxtNIDN_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
TxtNAMA.SetFocus
End If

End Sub