DATABASE STMIK PRINGSEWU

1

Private Sub Command1_Click()
Dim A, jr, ps, tm, urut, asString
Text5.Text = 20 & Left(Text2.Text, 2)
A = Mid(Text2.Text, 3, 1)
If A = “1” Then
jr = “SISTEM INFORMASI”
ElseIf A = “2” Then
jr = “MANAJEMEN INFORMATIKA”
ElseIf A = “3” Then
jr = “TEHNIK INFORMATIKA”
ElseIf A = “4” Then
jr = “KOMPUTER AKUTANSI”
End If
Text3.Text = jr
A = Mid(Text2.Text, 4, 2)
If A = “01” Then
ps = “STRATA SATU”
ElseIf A = “02” Then
ps = “DIPLOMA EMPAT”
ElseIf A = “03” Then
ps = “DIPLOMA TIGA”
ElseIf A = “04” Then
ps = “DIPLOMA DUA”
End If
Text4.Text = ps
Text6.Text = Right(Text2.Text, 3)
End Sub

Private Sub text1_KeyPress(KEYASCII As Integer)
If KEYASCII = 13 Then
Text2.SetFocus
End If
End Sub

Private Sub Command2_Click()
Data1.Recordset.AddNew
Text1.SetFocus
End Sub

Private Sub Command3_Click()
Data1.Recordset.Update
End Sub

Private Sub Command4_Click()
Data1.Recordset.Delete
End Sub

Private Sub Command5_Click()
End
End Sub

tugasssss

Gambar

Private Sub cmdbatal_Click()
cbokode.SetFocus
cbokode.Text = “”
txtjudul.Text = “”
txtpengarang.Text = “”
txttahun.Text = “”
txtpenerbit.Text = “”
txtharga.Text = “”
End Sub

Private Sub cmdkeluar_Click()
Unload Me
End Sub

Private Sub cmdlagi_Click()
cbokode.SetFocus
cbokode.Text = “”
txtjudul.Text = “”
txtpengarang.Text = “”
txttahun.Text = “”
txtpenerbit.Text = “”
txtharga.Text = “”
End Sub

Private Sub cmdproses_Click()
Dim a As String

a = Left(cbokode.Text, 1)
If a = “A” Then
txtpenerbit.Text = “Andi Offset Yogyakarta”
ElseIf a = “I” Then
txtpenerbit.Text = “Indah Surabaya”
ElseIf a = “S” Then
txtpenerbit.Text = “Salemba Empat”
ElseIf a = “E” Then
txtpenerbit.Text = “Elek Media Komputindo”
ElseIf a = “M” Then
txtpenerbit.Text = “Maxicom”
End If

a = Mid(cbokode.Text, 3, 3)
If kode = “SIM” Then
txtjudul.Text = “Sistem Informasi Manajemen”
txtpengarang.Text = “Yati Nur Oktavia”
txtharga.Text = “75900”
ElseIf a = “EDP” Then
txtjudul.Text = “Elektronik Data Proses”
txtpengarang.Text = “Imam Tarmizi”
txtharga.Text = “62000”
ElseIf a = “MNJ” Then
txtjudul.Text = “Manajemen”
txtpengarang.Text = “M.rizal sobri”
txtharga.Text = “42000”
ElseIf a = “CRD” Then
txtjudul.Text = “Corel Draw”
txtpengarang.Text = “Riyan Suhandi”
txtharga.Text = “453000”
ElseIf a = “RPL” Then
txtjudul.Text = “Rekayasa Perangkat Lunak”
txtpengarang.Text = “Sinta umpu singa”
txtharga.Text = “83000”
End If
txttahun.Text = “20” & Right(cbokode.Text, 2)
End Sub

Private Sub Form_Load()
cbokode.AddItem “A-SIM-01”
cbokode.AddItem “I-EDP-02”
cbokode.AddItem “S-MNJ-03”
cbokode.AddItem “E-CRD-04”
cbokode.AddItem “M-RPL-05”
End Sub

 

tugaas

Gambar

Private Sub Command1_Click()
Dim a, GOLONGAN, KODESTATUS, STATUS, JABATAN, BAGIAN, GAJIPOKOK, TUNJANGAN, totalgaji, asstring
Text4.Text = “” & Left(Text11.Text, 4)
a = Mid(Text11.Text, 5, 1)
If a = “A” Then
GOLONGAN = “A”
ElseIf a = “B” Then
GOLONGAN = “B”
ElseIf a = “C” Then
GOLONGAN = “C”
End If
Text1.Text = GOLONGAN
a = Mid(Text11.Text, 5, 1)
If a = “A” Then
JABATAN = “MANAJER”
ElseIf a = “B” Then
JABATAN = “Ka Seksi”
ElseIf a = “C” Then
JABATAN = “Staff”
End If
Text5.Text = JABATAN
a = Mid(Text11.Text, 5, 1)
If a = “A” Then
GAJIPOKOK = “4000000”
ElseIf a = “B” Then
GAJIPOKOK = “3500000”
ElseIf a = “C” Then
GAJIPOKOK = “3000000”
End If
Text7.Text = GAJIPOKOK
a = Mid(Text11.Text, 5, 1)
If a = “A” Then
TUNJANGAN = “1025000”
ElseIf a = “B” Then
TUNJANGAN = “975000”
ElseIf a = “C” Then
TUNJANGAN = “925000”
End If
Text8.Text = TUNJANGAN
a = Mid(Text11.Text, 7, 1)
If a = “S” Then
KODESTATUS = “S”
ElseIf a = “M” Then
KODESTATUS = “M”
ElseIf a = “J” Then
KODESTATUS = “J”
ElseIf a = “D” Then
KODESTATUS = “D”
End If
Text2.Text = KODESTATUS
a = Mid(Text11.Text, 7, 1)
If a = “S” Then
STATUS = “single”
ElseIf a = “M” Then
STATUS = “menikah”
ElseIf a = “J” Then
STATUS = “janda”
ElseIf a = “D” Then
STATUS = “duda”
End If
Text3.Text = STATUS
a = Right(Text11.Text, 3)
If a = “KEU” Then
BAGIAN = “Accounting”
ElseIf a = “ADM” Then
BAGIAN = “Administrasi”
ElseIf a = “SDM” Then
BAGIAN = “General Affair”
ElseIf a = “EDP” Then
BAGIAN = “IP Unit”
ElseIf a = “SPM” Then
BAGIAN = “Security”
End If
Text6.Text = BAGIAN
Text9.Text = Val(Text7.Text) + Val(Text8.Text)
End Sub

 

Private Sub Command2_Click()
Text10.SetFocus
Text1 = “”
Text2 = “”
Text3 = “”
Text4 = “”
Text5 = “”
Text6 = “”
Text7 = “”
Text8 = “”
Text9 = “”
Text10 = “”
Text11 = “”
End Sub

 

Private Sub Command3_Click()
Text10.SetFocus
Text1 = “”
Text2 = “”
Text3 = “”
Text4 = “”
Text5 = “”
Text6 = “”
Text7 = “”
Text8 = “”
Text9 = “”
Text10 = “”
Text11 = “”
End Sub

 

Private Sub Command4_Click()
Unload Me
End Sub

 

Private Sub Text10_keypress(keyascii As Integer)
If keyascii = 13 Then
Text11.SetFocus
End If
End Sub

 

 Gambar

 

Gambar

Private Sub Command1_Click()
Dim a, judulbuku, pengarang, penerbit, asString
Text4.Text = “20” & Mid(Text1.Text, 5, 2)
a = Left(Text1.Text, 3)
If a = “sim” Then
judulbuku = “sistem informasi menejemen”
ElseIf a = “edp” Then
judulbuku = “elektronik data processing”
ElseIf a = “mnj” Then
judulbuku = “manajemen”
ElseIf a = “cdr” Then
judulbuku = “coreldraw”
ElseIf a = “rpl” Then
judulbuku = “rekayasa perangkat lunak”
End If
Text2.Text = judulbuku
a = Left(Text1, 3)
If a = “sim” Then
pengarang = “rizki ardiansyah”
ElseIf a = “edp” Then
pengarang = “ridho fauji”
ElseIf a = “mnj” Then
pengarang = “m apriyandi”
ElseIf a = “cdr” Then
pengarang = “yuli”
ElseIf a = “rlp” Then
pengarang = “munjir”
End If
Text3.Text = pengarang
a = Left(Text1.Text, 3)
If a = “sim” Then
harga = “87200”
ElseIf a = “edp” Then
harga = “72000”
ElseIf a = “mnj” Then
harga = “43000”
ElseIf a = “cdr” Then
harga = “69000”
ElseIf a = “rlp” Then
harga = “97000”
End If
Text6.Text = harga
a = Right(Text1.Text, 1)
If a = “a” Then
penerbit = “andi offse yogyakarta”
ElseIf a = “i” Then
penerbit = “indah surabaya”
ElseIf a = “s” Then
penerbit = “salemba empat”
ElseIf a = “e” Then
penerbit = “elek media komputindo”
ElseIf a = “m” Then
penerbit = “maxicom”
Text5.Text = penerbit
End If
End Sub

Private Sub Command2_click()
Text1.SetFocus
Text1 = “”
Text1 = “”
Text2 = “”
Text3 = “”
Text4 = “”
Text5 = “”
Text6 = “”
End Sub

Private Sub Command3_click()
Text1.SetFocus
Text1 = “”
Text1 = “”
Text2 = “”
Text3 = “”
Text4 = “”
Text5 = “”
Text6 = “”
End Sub

Private Sub Command4_click()
End
End Sub

 Gambar

 

Gambar

Private Sub Command1_Click()
Dim a, judulbuku, pengarang, penerbit, asString
Text4.Text = “20” & Mid(Text1.Text, 5, 2)
a = Left(Text1.Text, 3)
If a = “sim” Then
judulbuku = “sistem informasi menejemen”
ElseIf a = “edp” Then
judulbuku = “elektronik data processing”
ElseIf a = “mnj” Then
judulbuku = “manajemen”
ElseIf a = “cdr” Then
judulbuku = “coreldraw”
ElseIf a = “rpl” Then
judulbuku = “rekayasa perangkat lunak”
End If
Text2.Text = judulbuku
a = Left(Text1, 3)
If a = “sim” Then
pengarang = “rizki ardiansyah”
ElseIf a = “edp” Then
pengarang = “ridho fauji”
ElseIf a = “mnj” Then
pengarang = “m apriyandi”
ElseIf a = “cdr” Then
pengarang = “yuli”
ElseIf a = “rlp” Then
pengarang = “munjir”
End If
Text3.Text = pengarang
a = Mid(Text1.Text, 3)
If a = “sim” Then
harga = “87200”
ElseIf a = “edp” Then
harga = “72000”
ElseIf a = “mnj” Then
harga = “43000”
ElseIf a = “cdr” Then
harga = “69000”
ElseIf a = “rlp” Then
harga = “97000”
End If
Text6.Text = harga
a = Right(Text1.Text, 1)
If a = “a” Then
penerbit = “andi offse yogyakarta”
ElseIf a = “i” Then
penerbit = “indah surabaya”
ElseIf a = “s” Then
penerbit = “salemba empat”
ElseIf a = “e” Then
penerbit = “elek media komputindo”
ElseIf a = “m” Then
penerbit = “maxicom”
Text5.Text = penerbit
End If
End Sub

Private Sub Command2_click()
Text1.SetFocus
Text1 = “”
Text1 = “”
Text2 = “”
Text3 = “”
Text4 = “”
Text5 = “”
Text6 = “”
End Sub

Private Sub Command3_click()
Text1.SetFocus
Text1 = “”
Text1 = “”
Text2 = “”
Text3 = “”
Text4 = “”
Text5 = “”
Text6 = “”
End Sub

Private Sub Command4_click()
End
End Sub

 Gambar

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

TUGAS VB.I

5

TUGAS

Private Sub Cmdhitung_Click()
Dim A, B, C As String
txtb.Text = Val(txta.Text) * 0.1
txtc.Text = Val(txta.Text) – Val(txtb.Text)
End Sub

 

Private Sub cmdquit_Click()
End
End Sub

 

Private Sub cmdulangi_ClICK()
txta.SetFocus
txta.Text = “”
txtb.Text = “”
txtc.Text = “”
End Sub

 

 

 

tugas VB.I

Gambar

tugas 2

Private Sub command3_Click()
text1.SetFocus
text1.Text = “”
text2.Text = “”
text3.Text = “”
text4.Text = “”
text5.Text = “”
text6.Text = “”

 

End Sub

 

Private Sub command4_Click()
Unload Me
End Sub

 

Private Sub command2_Click()
text1.SetFocus
text1.Text = “”
text2.Text = “”
text3.Text = “”
text4.Text = “”
text5.Text = “”
text6.Text = “”

 

End Sub

 

Private Sub command1_Click()
Dim S As String
Dim Total As Long
text5.Text = “20” & Left(text2.Text, 2)

 

S = Mid(text2.Text, 3, 1)
If S = “1” Then
text3.Text = “sistem Informasi”
ElseIf S = “2” Then
text3.Text = “Manajemen Informatika”
ElseIf S = “3” Then
text3.Text = “Tehnik Informatika”
ElseIf S = “04” Then
text3.Text = “Manajemen Komp. Akuntansi”
End If

 

text4.Text = Mid(text2.Text, 5, 2)
If S = “1” Then
text4.Text = “strata satu”
ElseIf S = “2” Then
text4.Text = “diploma tiga”
ElseIf S = “3” Then
text4.Text = “Diploma Empat”
ElseIf S = “4” Then
text4.Text = “Diploma Dua”
End If

 

text6.Text = text4
text6.Text = Right(text2.Text, 3)

 

 

 

End Sub

 

Private Sub Form_Activate()
text1.SetFocus
text1.Text = “”
text2.Text = “”
text3.Text = “”
text4.Text = “”
text5.Text = “”
text6.Text = “”

 

End Sub

 

Private Sub text1_Keypress(KeyAscii As Integer)
If KeyAscii = 13 Then
text2.SetFocus
End If
End Sub