sistem informasi akademik dengan vb

73
Programer by : Rudy Kurniawan 1 SQL – SERVER 2005 (Sistem Informasi Akademik) 1. Gambaran singkat program Program Sistem Informasi Akademik (SIA) ini dirancang dan dibuat untuk memudahkan pendataan dalam pemasukan proses dan keluaran data akademik politehnik negri Jakarta bekerja sama dengan cevest bekasi. Program sudah dirancang agar data yang rangkap atau tidak falid dapat disaring terlebih dahulu. Program ini meliputi pendataan kejuruan, program studi, nilai, marksheet, mahasiswa, dosen, belajar, dan mengajar. Seluruh form atau table memiliki saling keterkaitan satu sama lain , sehingga jika ada perubahan disalah satu table dapat mempengaruihi table lainnya 2. Manual Operation Program Pada dasarnya pengoprasian yang ada di program SIA ini sangad sederhana karena perintah – perintah didalam program ini teridiri dari bahasa Indonesia. a. Saat program baru dijalankan akan tampil form login, form ini berfungsi untuk menyaring user yang akan menggunakan anggota, terdiri dari 2 keanggotaan yaitu : Ø Adimistrator Ø User Administraor : memiliki hak penuh atas program SIA ini , yaitu bisa memasukan, mengedit, menghapus, dan mencetak laporan. User : memiliki hak untuk melihat dan mencetak data yang ada di database SIA Masukan Id dan Password anda jika sudah benar akan terbuka form berikutnya sesuai keanggotaan anda. Gambar 1 : Tampilan Form Login

Upload: luntang

Post on 18-Nov-2014

121 views

Category:

Documents


3 download

TRANSCRIPT

Page 1: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 1

SQL – SERVER 2005 (Sistem Informasi Akademik)

1. Gambaran singkat program

Program Sistem Informasi Akademik (SIA) ini dirancang dan dibuat untuk memudahkan pendataan dalam pemasukan proses dan keluaran data akademik politehnik negri Jakarta bekerja sama dengan cevest bekasi. Program sudah dirancang agar data yang rangkap atau tidak falid dapat disaring terlebih dahulu. Program ini meliputi pendataan kejuruan, program studi, nilai, marksheet, mahasiswa, dosen, belajar, dan mengajar. Seluruh form atau table memiliki saling keterkaitan satu sama lain , sehingga jika ada perubahan disalah satu table dapat mempengaruihi table lainnya

2. Manual Operation Program

Pada dasarnya pengoprasian yang ada di program SIA ini sangad sederhana karena perintah – perintah didalam program ini teridiri dari bahasa Indonesia.

a. Saat program baru dijalankan akan tampil form login, form ini berfungsi untuk menyaring user yang akan menggunakan anggota, terdiri dari 2 keanggotaan yaitu : Ø Adimistrator Ø User

Administraor : memiliki hak penuh atas program SIA ini , yaitu bisa memasukan, mengedit, menghapus, dan mencetak laporan. User : memiliki hak untuk melihat dan mencetak data yang ada di database SIA Masukan Id dan Password anda jika sudah benar akan terbuka form berikutnya sesuai keanggotaan anda.

Gambar 1 : Tampilan Form Login

Page 2: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 2

b. Form Untuk Administrator

Untuk form administrator terdapat beberapa menu utama yaitu Ø Belajar : Untuk masuk kedalam Form kegiatan belajar mahasiswa Ø Mengajar : Untuk masuk kedalam form kegitan mangajar dosen Ø Matakuliah : Untuk masuk kedalam form matakuliah Ø Mahasiswa : Untuk masuk kedalam form mahasiswa Ø Dosen : Untuk masuk kedalam form dosen Ø Marksheet : Untuk masuk kedalam form marksheet Ø Nilai : Untuk masuk kedalam form nilai Ø Program studi : Untuk masuk kedalam form Program studi Ø Jurusan : Untuk masuk kedalam form jurusan Ø Laporan : Untuk Mengeprint Hasil Pendataan yang terdapat pada

database

Gambar 2 : Tampilan form administrator

Form Administrator Memiliki beberapa fungsi berupa Tambah, Simpan, Edit, Hapus.

Ø Tambah : Berfungsi untuk membuka textbox yang terkunci jika anda ingin memasukan data.

Ø Simpan : Pada saat form dibuka maka tombol simpan tidak akan

bisa di klik, untuk bisa mengaktifkannya tekan tombol tambah terlebih dahulu. Tombol simpan berfungsi untuk menyimpan data kedalam database jika data yang diminta telah terpenuhi maka data akan disimpan dan akan diberi pemberitahuan didalam programnya. Jika data belum lengkap maka maka program akan memberitahukan pesan kesalahan dan anda diminta untuk memperbaiki kesalahan tersebut agar data tersebut bisa di simpan

Page 3: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 3

Ø Edit : Sama seperti tombol simpan, pada saat dibuka tombol edit

tidak akan berfungsi, maka untuk mengatfikannya anda harus menklik data yang akan anda edit di dalam data gridnya. Setelah itu tombol edit akan terbuka dan jika anda menekannya maka textbox yang ada di form akan otomatis terisi data yang akan diubah, silahkan memasukan data yang ingin dirubah, setelah itu tekan simpan

Catatan : ada beberapa textbox yang datanya tidak dapat diubah, ini menunjukan bahwa memang data tersebut tidak boleh diubah

Ø Hapus : seperti tombol edit dan simpan tombol hapus juga tidak

akan muncul saat form baru dijalankan, tombol hapus baru akan muncul saat datagrid di klik, tombol hapus berfungsi untuk menghapus data yang ada didalam database.

Catatan : Ada beberapa data yang tidak bisa dihapus dikarenakan data masih digunakan di table lainnya Untuk menghapus data tersebut hapus terlebih dahulu menghapus data yang ada ditable lainnya

Ø Tutup : menutup Form Yang sudah dibuka

Gambar 3 : Tamilan Form Mahasiswa

Catatan : Jika sudah memilih salah satu menu di form administrator untuk dapat pindah ke form yang lainnya harus menekan tombol tutup terlebih dahulu

Page 4: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 4

3. Kamus Data

Tabel : Jurusan

No Field Name Data Type Field Size CONSTRAINT 1 Jurusan Varchar 30 PK 2 No_SK_Berdiri Varchar 25 3 Tgl_SK Datetime

Tabel : Program_Studi

No Field Name Data Type Field Size CONSTRAINT 1 Jurusan Varchar 30 FK Relasi ke tabel jurusan 2 Program_studi Varchar 30 PK 3 No_SK_berdiri Varchar 25 4 Tgl_SK Datetimr

Tabel : Mahasiswa

No Field Name Data Type Field Size CONSTRAINT 1 NIM Varchar 10 PK 2 Nama Varchar 35 3 Tempat_lahir Varchar 25 4 Tanggal_lahir Datetime 5 Jenis_kelamin Varchar 6 6 Agama Varchar 9 7 Warga_negara Varchar 15 8 Jurusan Varchar 30 FK Relasi Ke tabel program_studi 9 Program_studi Varchar 30 10 Alamat_Rumah Varchar 200 11 No_Telp_rumah Varchar 12 12 No_HP Varchar 12 13 Nama_ortu Varchar 35 14 Pekerjaan_Ortu Varchar 25 15 Alamat_Ortu Varchar 200 Tabel : Dosen No Field Name Data Type Field Size CONSTRAINT 1 NIP Varchar 9 PK 2 Nama Varchar 35 3 Tempat_lahir Varchar 25 4 Tanggal_lahir Datetime 5 Jenis_kelamin Varchar 6 6 Agama Varchar 9 7 Alamat_Rumah Varchar 200 8 No_Telp_rumah Varchar 12 9 No_HP Varchar 12

Page 5: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 5

Tabel : Mata_Kuliah No Field Name Data Type Field Size CONSTRAINT 1 Kode_mata_kuliah Varchar 15 PK 2 Mata_kuliah Varchar 35 3 SKS Smallint 4 Jumlah_jam_teori Int 5 Jumlah_jam_praktek Int 6 Semester Varchar 9 Tabel : Mengajar No Field Name Data Type Field Size CONSTRAINT 1 Hari Varchar 9 PK 2 Tanggal Varchar 35 3 Minggu_Ke Varchar 25 4 NIP Varchar 9 5 Jurusan Varchar 30 6 Program_studi Varchar 30 7 Kode_mata_kuliah Varchar 15 8 Tempat Varchar 15 9 Jam_teori Smallint 10 Jam_praktek Smallint 11 Jam_ke Smallint 12 Sd_jam_ke Smallint 13 Topik_materi Varchar 200 Tabel : Belajar No Field Name Data Type Field

Size CONSTRAINT

1 NIM Varchar 9 2 Kode_mata_kuliah Varchar 15 3 Jam_absensi_ijin Int 4 Jam_absensi_sakit Int 5 Jam_absensi_tanpa_keterangan Int Tabel : Nilai No Field Name Data Type Field Size CONSTRAINT

1 Hruf_mutu Varchar 2 PK 2 Angka_mutu Decimal 5,2 3 Predikat Varchar 15 Tabel : Marksheet No Field Name Data Type Field Size CONSTRAINT 1 Tahun_Akademik Varchar 11 2 NIM Varchar 9 Fk Relasi Ke Belajar 3 Kode_Mata_kuliah Varchar 15 Fk Relasi Ke Belajar 4 Huruf_mutu Varchar 2 Fk Relasi Ke tabel nilai

Page 6: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 6

4. Tampilan Program

Gambar Form Login

Gambar Form Administrator

Page 7: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 7

Gambar Form User

Gambar Form Belajar

Page 8: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 8

Gambar Form Mengajar

Gambar Form Mata Kuliah

Page 9: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 9

Gambar Form Mahasiswa

Gambar Form Dosen

Page 10: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 10

Gambar Form MarkSheet

Gambar Form Nilai

Page 11: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 11

Gambar Form Program Studi

Gambar Form Kejuruan

Page 12: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 12

Gambar : Form User

Page 13: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 13

5. Coding Program Ø Form Login Private Sub cmdcancel_Click() End End Sub Private Sub cmdlogin_Click() If txtname.Text = "admin" And txtpass.Text = "admin123" Then frm_admin2.Show Unload Me Else Dim rsperiksa As Recordset Set rsperiksa = New Recordset rsperiksa.Open "select nama,nim from mahasiswa where nama = '" & Trim(txtname.Text) & "' and nim = '" & Trim(txtpass.Text) & "'", cn If Not rsperiksa.EOF Then varnim = Trim(txtpass.Text) frm_user2.Show Unload Me Else MsgBox "Username atau password yang ada masukan salah !!!", vbCritical, "Login Gagal" txtname.Text = "" txtpass.Text = "" txtname.SetFocus End If End If End Sub Private Sub Form_Load() koneksi lhSysMenu = GetSystemMenu(Me.hwnd, False) lRetVal = RemoveMenu(lhSysMenu, SC_MOVE, MF_BYCOMMAND) End Sub Private Sub Form_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Label4.ForeColor = &H80000012 End Sub Private Sub Label4_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Label4.ForeColor = &HFF& End Sub Private Sub txtpass_KeyPress(KeyAscii As Integer) If KeyAscii = 13 Then cmdlogin_Click End If End Sub Ø Form Administrator

Page 14: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 14

Dim Counter As Integer Private Sub Form_Load() Counter = 0 Timer1.Interval = 100 '<-- Atur kecepatannya di sini With StatusBar1 .Panels(1).Width = 4000 .Panels(1).Alignment = sbrRight End With End Sub Private Sub Form_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) lblbelajar.ForeColor = &H80000012 laporan.ForeColor = &H80000012 LBLMENGAJAR.ForeColor = &H80000012 LBLMATAKULIAH.ForeColor = &H80000012 LBLMAHASISWA.ForeColor = &H80000012 LBLDOSEN.ForeColor = &H80000012 LBLMARKSHEET.ForeColor = &H80000012 LBLNILAI.ForeColor = &H80000012 LBLPRODI.ForeColor = &H80000012 LBLJURUSAN.ForeColor = &H80000012 LBLLOGOUT.ForeColor = &H80000012 End Sub Private Sub laporan_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) laporan.ForeColor = &HFF& frm_laporanadmin.Show End Sub Private Sub lblbelajar_Click() Frm_Belajar.Show 1 End Sub Private Sub lblbelajar_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Unload frm_laporanadmin lblbelajar.ForeColor = &HFF& End Sub Private Sub LBLDOSEN_Click() Frm_Dosen.Show 1 End Sub Private Sub LBLDOSEN_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Unload frm_laporanadmin

Page 15: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 15

LBLDOSEN.ForeColor = &HFF& End Sub Private Sub LBLJURUSAN_Click() Frm_Kejuruan.Show 1 End Sub Private Sub LBLJURUSAN_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Unload frm_laporanadmin LBLJURUSAN.ForeColor = &HFF& End Sub Private Sub LBLLOGOUT_Click() Frm_login2.Show Unload Me End Sub Private Sub LBLLOGOUT_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) LBLLOGOUT.ForeColor = &HFF& End Sub Private Sub LBLMAHASISWA_Click() Frm_Mahasiswa.Show 1 End Sub Private Sub LBLMAHASISWA_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Unload frm_laporanadmin LBLMAHASISWA.ForeColor = &HFF& End Sub Private Sub LBLMARKSHEET_Click() Frm_Marksheet.Show 1 End Sub Private Sub LBLMARKSHEET_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Unload frm_laporanadmin LBLMARKSHEET.ForeColor = &HFF& End Sub Private Sub LBLMATAKULIAH_Click() Frm_MataKuliah.Show 1 End Sub Private Sub LBLMATAKULIAH_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Unload frm_laporanadmin

Page 16: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 16

LBLMATAKULIAH.ForeColor = &HFF& End Sub Private Sub LBLMENGAJAR_Click() Frm_Mengajar.Show 1 End Sub Private Sub LBLMENGAJAR_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) LBLMENGAJAR.ForeColor = &HFF& Unload frm_laporanadmin End Sub Private Sub LBLNILAI_Click() Frm_Nilai.Show 1 End Sub Private Sub LBLNILAI_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Unload frm_laporanadmin LBLNILAI.ForeColor = &HFF& End Sub Private Sub LBLPRODI_Click() Frm_Prodi.Show 1 End Sub Private Sub LBLPRODI_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Unload frm_laporanadmin LBLPRODI.ForeColor = &HFF& End Sub Private Sub Timer1_Timer() Dim Kalimat As String Dim pnlX1 As Panel Set pnlX1 = StatusBar1.Panels(1) Kalimat = "Selamat Datang Di Sistem Informasi Akademik BBPLKLN - Bekasi Bekerja Sama Dengan Politehnik Negri Jakarta - Depok" Counter = Counter + 1 DoEvents pnlX1.Text = TulisJalan(Counter, Kalimat, 150) End Sub Public Function TulisJalan(Hitung As Integer, _ strKalimat As String, _ Panjang As Integer)

Page 17: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 17

If Hitung = Len(strKalimat) + Panjang Then Hitung = 0 ElseIf Hitung > Len(strKalimat) Then TulisJalan = strKalimat & Space(Hitung - Len(strKalimat)) Else TulisJalan = Mid(strKalimat, 1, Hitung) End If End Function Ø Form User

Page 18: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 18

Dim Counter As Integer Private Sub Command1_Click() Form1.Show 1 End Sub Private Sub Command8_Click() lpr_jurusan.Show End Sub Private Sub Form_Load() koneksi ambilmahasiswa lhSysMenu = GetSystemMenu(Me.hwnd, False) lRetVal = RemoveMenu(lhSysMenu, SC_MOVE, MF_BYCOMMAND) Frm_user.Caption = lblnama.Caption Counter = 0 Timer1.Interval = 100 '<-- Atur kecepatannya di sini With StatusBar1 .Panels(1).Width = 4000 .Panels(1).Alignment = sbrRight End With End Sub Private Sub ambilmahasiswa() Dim rsjmahasiswa As Recordset Set rsjmahasiswa = New Recordset rsjmahasiswa.Open "select * from mahasiswa where nama='" &

Trim(Frm_login2.txtname.Text) & "' ", cn lblnama.Caption = rsjmahasiswa.Fields("nama") lblnim.Caption = rsjmahasiswa.Fields("nim") lbltempat.Caption = rsjmahasiswa.Fields("tempat_lahir") lbltanggal.Caption = rsjmahasiswa.Fields("tanggal_lahir") lblsex.Caption = rsjmahasiswa.Fields("jenis_kelamin") lblagama.Caption = rsjmahasiswa.Fields("agama") lblnegara.Caption = rsjmahasiswa.Fields("warga_negara") lbljurusan.Caption = rsjmahasiswa.Fields("jurusan") lblprodi.Caption = rsjmahasiswa.Fields("program_studi") Label19.Caption = rsjmahasiswa.Fields("nama") End Sub Private Sub Form_MouseMove(Button As Integer, Shift As Integer, X As

Single, Y As Single) Label17.ForeColor = &H80000012 Label21.ForeColor = &H80000012 Label23.ForeColor = &H80000012 Label22.ForeColor = &H80000012 Label20.ForeColor = &H80000012 Label24.ForeColor = &H80000012 Label25.ForeColor = &H80000012

Page 19: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 19

Label26.ForeColor = &H80000012 End Sub Private Sub Label17_Click() Frm_login2.Show Unload Me End Sub Private Sub Label17_MouseMove(Button As Integer, Shift As Integer, X

As Single, Y As Single) Label17.ForeColor = &HFF& End Sub Private Sub Label20_Click() lpr_mengajardosen.Show End Sub Private Sub Label20_MouseMove(Button As Integer, Shift As Integer, X

As Single, Y As Single) Label20.ForeColor = &HFF& End Sub Private Sub Label21_Click() lpr_jadwalkuliah.Show End Sub Private Sub Label21_MouseMove(Button As Integer, Shift As Integer, X

As Single, Y As Single) Label21.ForeColor = &HFF& End Sub Private Sub Label22_Click() Form1.Show End Sub Private Sub Label22_MouseMove(Button As Integer, Shift As Integer, X

As Single, Y As Single) Label22.ForeColor = &HFF& End Sub Private Sub Label23_Click() Lpr_nilai.Show End Sub Private Sub Label23_MouseMove(Button As Integer, Shift As Integer, X

As Single, Y As Single) Label23.ForeColor = &HFF& End Sub Private Sub Label24_Click()

Page 20: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 20

lpr_mahasiswa.Show End Sub Private Sub Label24_MouseMove(Button As Integer, Shift As Integer, X

As Single, Y As Single) Label24.ForeColor = &HFF& End Sub Private Sub Label25_Click() lpr_dosen.Show End Sub Private Sub Label25_MouseMove(Button As Integer, Shift As Integer, X

As Single, Y As Single) Label25.ForeColor = &HFF& End Sub Private Sub Label26_MouseMove(Button As Integer, Shift As Integer, X

As Single, Y As Single) Label26.ForeColor = &HFF& End Sub Private Sub Timer1_Timer() Dim Kalimat As String Dim pnlX1 As Panel Set pnlX1 = StatusBar1.Panels(1) Kalimat = "Selamat Datang Di Sistem Informasi Akademik

BBPLKLN - Bekasi Bekerja Sama Dengan Politehnik Negri Jakarta - Depok"

Counter = Counter + 1 DoEvents pnlX1.Text = TulisJalan(Counter, Kalimat, 150) End Sub Public Function TulisJalan(Hitung As Integer, _ strKalimat As String, _ Panjang As Integer) If Hitung = Len(strKalimat) + Panjang Then Hitung = 0 ElseIf Hitung > Len(strKalimat) Then TulisJalan = strKalimat & Space(Hitung - Len(strKalimat)) Else TulisJalan = Mid(strKalimat, 1, Hitung) End If End Function Ø Form Belajar Private Sub cmbkode_GotFocus()

Page 21: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 21

If cmbnim.Text = "" Then MsgBox "Pilih NIM Terlebih Dahulu", vbInformation, "Infomasi" End If End Sub Private Sub cmbkode_KeyPress(KeyAscii As Integer) If InStr("", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub Private Sub cmbkode_LostFocus() ambilnamamatakuliah End Sub Private Sub cmbnim_KeyPress(KeyAscii As Integer) If InStr("", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub Private Sub cmbnim_LostFocus() ambilmahasiswa End Sub Private Sub cmdedit_Click() If cmdedit.Caption = "&Edit" Then bukakunci cmbnim.Enabled = False cmbkode.Enabled = False cmdsimpan.Visible = False cmdedit.Caption = "&Simpan" cmdedit.Enabled = True ElseIf cmdedit.Caption = "&Simpan" Then Dim rsedit As Recordset Dim edit As String Set rsedit = New Recordset edit = "update belajar set jam_absensi_ijin='" & Trim(txtijin.Text) & "',jam_absensi_sakit='" & Trim(txtsakit.Text) & "',jam_absensi_tanpa_keterangan='" & Trim(txtabsen.Text) & "' where kode_mata_kuliah='" & Trim(cmbkode.Text) & "' and nim= '" & Trim(cmbnim.Text) & "'" rsedit.Open edit, cn cmdedit.Caption = "&Edit": cmdsimpan.Visible = True cmdtambah.Enabled = True

Page 22: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 22

MsgBox "Data Berhasil Di Edit", vbInformation, "Data Diedit" bersih kunci End If lihatdata aturgrid cmdsimpan.Enabled = False End Sub Private Sub cmdhapus_Click() If MsgBox("Yakin Data Ini Akan Dihapus?...", vbQuestion + vbYesNo, "Hapus Data?...") = vbYes Then Dim rshapus As Recordset Set rshapus = New Recordset rshapus.Open "Delete from belajar where nim = '" & Trim(cmbnim.Text) & "'", cn MsgBox "Data Berhasil Dihapus", vbInformation, "Penghapusan Data.." Else MsgBox "Data Batal Dihapus...", vbInformation, "Penghapusan Batal..." End If lihatdata aturgrid bersih kunci cmdtambah.Enabled = True cmdsimpan.Enabled = False End Sub Private Sub cmdsimpan_Click() If cmbnim.Text = "" And cmbkode.Text = "" Then MsgBox "NIM dan Kode Mata Kuliah Tidak Boleh Kosong", vbCritical, "Kesalahan" Else Dim rsperiksa As Recordset Set rsperiksa = New Recordset rsperiksa.Open "select * from belajar where nim = '" & Trim(cmbnim.Text) & "' and kode_mata_kuliah= '" & Trim(cmbkode.Text) & "'", cn If Not rsperiksa.EOF Then MsgBox "Data Sudah ada !!", vbInformation, "Data Ditemukan..." bersih Else Dim rsinsert As Recordset Set rsinsert = New Recordset rsinsert.Open "insert into Belajar(nim,kode_mata_kuliah,jam_absensi_ijin,jam_absensi_sakit,jam_absensi_tanpa_keterangan) values('" & Trim(cmbnim.Text) & "','" & Trim(cmbkode.Text) & "','" & Trim(txtijin.Text) & "','" & Trim(txtsakit.Text) & "','" & Trim(txtabsen.Text) & "')", cn MsgBox "Data Sudah Disimpan ", vbInformation, "Berhasil Disimpan"

Page 23: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 23

bersih kunci lihatdata aturgrid cmdtambah.Caption = "&Tambah" cmdsimpan.Enabled = False End If End If End Sub Private Sub cmdtambah_Click() If cmdtambah.Caption = "&Tambah" Then bukakunci cmdtambah.Caption = "&Cancel" ElseIf cmdtambah.Caption = "&Cancel" Then bersih kunci cmdtambah.Caption = "&Tambah" cmdsimpan.Enabled = False End If End Sub Private Sub cmdtutup_Click() Frm_admin.Enabled = True Unload Me End Sub Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer) cmbnim.Enabled = False cmdhapus.Enabled = True: cmdedit.Enabled = True With DataGrid1 cmbnim = Trim(.Columns(0).Text) End With Dim rscari As Recordset Dim strcari As String Set rscari = New Recordset strcari = "select * from belajar where nim= '" & Trim(DataGrid1.Columns(0).Text) & "'" rscari.Open strcari, cn If Not rscari.EOF Then cmbkode.Text = rscari.Fields("kode_mata_kuliah") txtsakit.Text = rscari.Fields("jam_absensi_sakit") txtijin.Text = rscari.Fields("jam_absensi_ijin") txtabsen.Text = rscari.Fields("jam_absensi_tanpa_keterangan") End If End Sub Private Sub Form_Activate() lihatdata

Page 24: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 24

aturgrid lhSysMenu = GetSystemMenu(Me.hwnd, False) lRetVal = RemoveMenu(lhSysMenu, SC_MOVE, MF_BYCOMMAND) End Sub Private Sub Form_Load() koneksi ambilmatakuliah ambilnim lihatdata aturgrid kunci cmdsimpan.Enabled = False End Sub Private Sub Timer1_Timer() Label4.Caption = Time Label3.Caption = Date End Sub Sub kunci() cmbnim.Enabled = False cmbkode.Enabled = False txtijin.Enabled = False txtsakit.Enabled = False txtabsen.Enabled = False cmdsimpan.Enabled = True cmdhapus.Enabled = False cmdedit.Enabled = False cmdtambah.Enabled = True End Sub Sub bukakunci() cmbnim.Enabled = True cmbkode.Enabled = True txtijin.Enabled = True txtsakit.Enabled = True txtabsen.Enabled = True cmdsimpan.Enabled = True cmdhapus.Enabled = False cmdedit.Enabled = False End Sub Sub bersih() cmbnim.Text = "" cmbkode.Text = "" txtijin.Text = "" txtsakit.Text = "" txtabsen.Text = "" End Sub

Page 25: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 25

Private Sub lihatdata() Dim rs As Recordset Set rs = New Recordset rs.Open "select * from belajar", cn Set DataGrid1.DataSource = rs.DataSource aturgrid End Sub Private Sub aturgrid() With DataGrid1 .Columns(0).Caption = "NIM": .Columns(0).Width = 1500 .Columns(1).Caption = "Kode Mata Kuliah": .Columns(1).Width = 1500 .Columns(2).Caption = "Absensi Ijin": .Columns(2).Width = 950 .Columns(3).Caption = "Absensi Sakit": .Columns(3).Width = 1100 .Columns(4).Caption = "Absensi Tanpa Keterangan": .Columns(4).Width = 2050 End With End Sub Private Sub ambilmatakuliah() Dim rsmatakuliah As Recordset Set rsmatakuliah = New Recordset rsmatakuliah.Open "select kode_mata_kuliah from mengajar group by kode_mata_kuliah", cn cmbkode.Clear For i = 1 To rsmatakuliah.RecordCount cmbkode.AddItem rsmatakuliah.Fields("kode_mata_kuliah") rsmatakuliah.MoveNext Next i End Sub Private Sub ambilnamamatakuliah() Dim rsnamamatakuliah As Recordset Set rsnamamatakuliah = New Recordset rsnamamatakuliah.Open "select * from mata_kuliah where kode_mata_kuliah='" & Trim(cmbkode.Text) & "'", cn Label21.Caption = rsnamamatakuliah.Fields("mata_kuliah") End Sub Private Sub ambilnim() Dim rsnim As Recordset Set rsnim = New Recordset rsnim.Open "select * from mahasiswa", cn cmbnim.Clear For i = 1 To rsnim.RecordCount cmbnim.AddItem rsnim.Fields("nim") rsnim.MoveNext Next i End Sub

Page 26: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 26

Private Sub ambilmahasiswa() Dim rsmahasiswa As Recordset Set rsmahasiswa = New Recordset rsmahasiswa.Open "select * from mahasiswa where NIM='" & Trim(cmbnim.Text) & "'", cn LBLMAHASISWA.Caption = rsmahasiswa.Fields("nama") End Sub Private Sub Form_Unload(Cancel As Integer) Frm_admin.Enabled = True End Sub Private Sub txtabsen_KeyPress(KeyAscii As Integer) If InStr("0123456789", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub Private Sub txtijin_KeyPress(KeyAscii As Integer) If InStr("0123456789", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub Private Sub txtsakit_KeyPress(KeyAscii As Integer) If InStr("0123456789", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub

Ø Form Dosen Private Sub cmdedit_Click() If cmdedit.Caption = "&Edit" Then bukakunci

Page 27: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 27

txtnim.Enabled = False: txtnama.SetFocus cmdsimpan.Visible = False cmdedit.Caption = "&Simpan" cmdedit.Enabled = True ElseIf cmdedit.Caption = "&Simpan" Then Dim rsedit As Recordset Dim edit As String Set rsedit = New Recordset edit = "update dosen set nama = '" & Trim(txtnama.Text) & "',tempat_lahir='" & Trim(txttempatlahir.Text) & "',tanggal_lahir='" & Trim(DTPicker1.Value) & "',alamat_rumah='" & Trim(txtalamat.Text) & "',no_telp_rumah='" & Trim(txtnotelp.Text) & "',no_hp='" & Trim(txthp.Text) & "',jenis_kelamin='" & Trim(cmbkelamin.Text) & "',agama='" & Trim(cmbagama.Text) & "' where nip='" & Trim(txtnim.Text) & "'" rsedit.Open edit, cn cmdedit.Caption = "&Edit": cmdsimpan.Visible = True cmdtambah.Enabled = True MsgBox "Data Dengan NIP : " & Trim(txtnim.Text) & " Berhasil Di Edit", vbInformation, "Data Diedit" bersih kunci End If lihatdata aturgrid End Sub Private Sub cmdhapus_Click() Dim rsperiksa As Recordset Set rsperiksa = New Recordset rsperiksa.Open " select * from mengajar where nip = '" & Trim(txtnim.Text) & "'", cn If Not rsperiksa.EOF Then MsgBox "Dosen : " & Trim(txtnama.Text) & " Tidak bisa dihapus Karena Data Masih Digunakan Di Mengajar !! ", vbInformation, "Informasi..." ElseIf MsgBox("Yakin Data Ini Akan Dihapus?...", vbQuestion + vbYesNo, "Hapus Data?...") = vbYes Then Dim rshapus As Recordset Set rshapus = New Recordset rshapus.Open "Delete from dosen where nip = '" & Trim(txtnim.Text) & "'", cn MsgBox "Data Berhasil Dihapus", vbInformation, "Penghapusan Data.." Else MsgBox "Data Batal Dihapus...", vbInformation, "Penghapusan Batal..." End If lihatdata aturgrid bersih kunci

Page 28: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 28

cmdtambah.Enabled = True End Sub Private Sub cmdsimpan_Click() If txtnim.Text = "" Then MsgBox "NIP Tidak Boleh Kosong", vbCritical, "Kesalahan" Else Dim rsperiksa As Recordset Set rsperiksa = New Recordset rsperiksa.Open "select * from dosen where NIP = '" & Trim(txtnim.Text) & "'", cn If Not rsperiksa.EOF Then MsgBox "NIP : " & Trim(txtnim.Text) & " Sudah ada !!", vbInformation, "Data Ditemukan..." bersih Else Dim rsinsert As Recordset Set rsinsert = New Recordset rsinsert.Open "insert into Dosen(NIP,nama,tempat_lahir,tanggal_lahir,jenis_kelamin,agama,alamat_rumah,no_telp_rumah,no_hp)" _ & " values('" & Trim(txtnim.Text) & "','" & Trim(txtnama.Text) & "','" & Trim(txttempatlahir.Text) & "','" & Trim(DTPicker1.Value) & "','" & Trim(cmbkelamin.Text) & "','" & Trim(cmbagama.Text) & "','" & Trim(txtalamat.Text) & "','" & Trim(txtnotelp.Text) & "','" & Trim(txthp.Text) & "')", cn MsgBox "Data Dosen " & txtnama.Text & " Sudah Disimpan ", vbInformation, "Berhasil Disimpan" bersih kunci lihatdata aturgrid DTPicker1.Value = Now cmdtambah.Caption = "&Tambah" End If End If End Sub Private Sub cmdtambah_Click() If cmdtambah.Caption = "&Tambah" Then bukakunci cmdtambah.Caption = "&Cancel" ElseIf cmdtambah.Caption = "&Cancel" Then kunci cmdtambah.Caption = "&Tambah" bersih End If End Sub Private Sub cmdtutup_Click()

Page 29: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 29

Frm_admin.Enabled = True Unload Me End Sub Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer) cmdtambah.Enabled = False: cmdsimpan.Enabled = False cmdhapus.Enabled = True: cmdedit.Enabled = True With DataGrid1 txtnim = Trim(.Columns(0).Text) End With Dim rscari As Recordset Dim strcari As String Set rscari = New Recordset strcari = "select * from dosen where nip= '" & Trim(DataGrid1.Columns(0).Text) & "'" rscari.Open strcari, cn If Not rscari.EOF Then txtnama.Text = rscari.Fields("nama") txttempatlahir.Text = rscari.Fields("tempat_lahir") DTPicker1.Value = rscari.Fields("Tanggal_lahir") txtalamat.Text = rscari.Fields("Alamat_rumah") txtnotelp.Text = rscari.Fields("no_telp_rumah") txthp.Text = rscari.Fields("no_hp") cmbkelamin.Text = rscari.Fields("jenis_kelamin") cmbagama.Text = rscari.Fields("agama") End If End Sub Private Sub Form_Load() koneksi kunci lihatdata aturgrid lhSysMenu = GetSystemMenu(Me.hwnd, False) lRetVal = RemoveMenu(lhSysMenu, SC_MOVE, MF_BYCOMMAND) End Sub Private Sub Timer1_Timer() Label4.Caption = Time Label3.Caption = Date End Sub Sub bersih() txtnim.Text = "" txtnama.Text = "" txtnama.Text = "" txttempatlahir.Text = ""

Page 30: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 30

txtalamat.Text = "" txtnotelp.Text = "" txthp.Text = "" cmbkelamin.Text = "" cmbagama.Text = "" End Sub Sub kunci() txtnim.Enabled = False txtnama.Enabled = False DTPicker1.Enabled = False txtnama.Enabled = False txttempatlahir.Enabled = False txtalamat.Enabled = False txtnotelp.Enabled = False txthp.Enabled = False cmbkelamin.Enabled = False cmbagama.Enabled = False cmdsimpan.Enabled = False cmdedit.Enabled = False cmdhapus.Enabled = False End Sub Sub bukakunci() txtnim.Enabled = True txtnama.Enabled = True DTPicker1.Enabled = True txtnama.Enabled = True txttempatlahir.Enabled = True txtalamat.Enabled = True txtnotelp.Enabled = True txthp.Enabled = True cmbkelamin.Enabled = True cmbagama.Enabled = True cmdsimpan.Enabled = True End Sub Private Sub lihatdata() Dim rs As New Recordset Set rs = New Recordset rs.Open "Select * From dosen", cn Set DataGrid1.DataSource = rs.DataSource aturgrid End Sub Private Sub aturgrid() With DataGrid1 .Columns(0).Caption = "Nip": .Columns(0).Width = 1200 .Columns(1).Caption = "Nama": .Columns(1).Width = 1500 .Columns(2).Caption = "Tempat Lahir": .Columns(2).Width = 1500

Page 31: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 31

.Columns(3).Caption = "Tanggal Lahir": .Columns(3).Width = 1200

.Columns(3).NumberFormat = "dd-mm-yyyy"

.Columns(4).Caption = "Jenis Kelamin": .Columns(4).Width = 1100

.Columns(5).Caption = "Agama": .Columns(5).Width = 1000 End With End Sub Private Sub Form_Unload(Cancel As Integer) Frm_admin.Enabled = True End Sub Private Sub txthp_KeyPress(KeyAscii As Integer) If InStr("0123456789,", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub Private Sub txtnotelp_KeyPress(KeyAscii As Integer) If InStr("0123456789,", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub

Ø Form Kejuruan Private Sub cmdedit_Click() If cmdedit.Caption = "&Edit" Then bukakunci txtjurusan.Enabled = False

Page 32: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 32

txtsk.SetFocus cmdsimpan.Visible = False cmdedit.Caption = "&Simpan" ElseIf cmdedit.Caption = "&Simpan" Then Dim rsedit As Recordset Dim edit As String Set rsedit = New Recordset edit = "update jurusan set no_sk_berdiri ='" & Trim(txtsk.Text) & "',tgl_sk='" & Trim(DTPicker1.Value) & "' where jurusan ='" & Trim(txtjurusan.Text) & "'" rsedit.Open edit, cn cmdedit.Caption = "&Edit" cmdsimpan.Visible = True bersih kunci cmdtambah.Enabled = True End If lihatdata aturgridjurusan End Sub Private Sub cmdhapus_Click() Dim rsperiksa As Recordset Set rsperiksa = New Recordset rsperiksa.Open " select * from program_studi where jurusan = '" & Trim(txtjurusan.Text) & "'", cn If Not rsperiksa.EOF Then MsgBox "Jurusan : " & Trim(txtjurusan.Text) & " Tidak bisa dihapus Karena Data Masih Digunakan Di Program Studi !! ", vbInformation, "Informasi..." ElseIf MsgBox("Yakin Ingin Menghapus Data Ini ?", vbQuestion + vbYesNo, "Hapus data..") = vbYes Then Dim rshapus As Recordset Set rshapus = New Recordset rshapus.Open "delete from jurusan where jurusan = '" & Trim(txtjurusan.Text) & "'", cn Else MsgBox "Data Tidak Jadi Dihapus", vbInformation, "Informasi.." End If lihatdata aturgridjurusan bersih kunci End Sub Private Sub cmdsimpan_Click() If txtjurusan.Text = "" Then MsgBox "Jurusan Tidak Boleh Kosong", vbCritical, "Informasi" txtjurusan.SetFocus bersih

Page 33: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 33

Else Dim rsperiksa As Recordset Set rsperiksa = New Recordset rsperiksa.Open " select * from jurusan where jurusan = '" & Trim(txtjurusan.Text) & "'", cn If Not rsperiksa.EOF Then MsgBox "Jurusan : " & Trim(txtjurusan.Text) & " Sudah ada !! ", vbInformation, "Data Ditemukan..." txtjurusan.SetFocus bersih Else Dim rsinsert As Recordset Set rsinsert = New Recordset rsinsert.Open "insert Into Jurusan(Jurusan,No_sk_berdiri,tgl_SK) values ('" & txtjurusan.Text & "','" & Trim(txtsk.Text) & "','" & Trim(DTPicker1.Value) & "')", cn MsgBox "Data Berhasil DiSimpan", vbInformation, "Informasi" lihatdata aturgridjurusan bersih kunci cmdtambah.Caption = "&Tambah" End If End If End Sub Private Sub cmdtambah_Click() If cmdtambah.Caption = "&Tambah" Then bukakunci txtjurusan.SetFocus cmdtambah.Caption = "&Cancel" ElseIf cmdtambah.Caption = "&Cancel" Then bersih kunci cmdtambah.Caption = "&Tambah" End If End Sub Private Sub cmdtutup_Click() Frm_admin.Enabled = True Unload Me End Sub Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer) cmdtambah.Enabled = False cmdsimpan.Enabled = False cmdhapus.Enabled = True

Page 34: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 34

cmdedit.Enabled = True With DataGrid1 txtjurusan = Trim(.Columns(0).Text) End With Dim rscari As Recordset Dim strcari As String Set rscari = New Recordset strcari = "select * from Jurusan where jurusan = '" & Trim(DataGrid1.Columns(0).Text) & "'" rscari.Open strcari, cn If Not rscari.EOF Then txtjurusan.Text = rscari.Fields("Jurusan") txtsk.Text = rscari.Fields("No_SK_Berdiri") DTPicker1.Value = rscari.Fields("Tgl_Sk") End If End Sub Private Sub Form_Activate() lihatdata aturgridjurusan lhSysMenu = GetSystemMenu(Me.hwnd, False) lRetVal = RemoveMenu(lhSysMenu, SC_MOVE, MF_BYCOMMAND) End Sub Private Sub Form_Load() txtjurusan.TabIndex = 0: txtsk.TabIndex = 1 koneksi bersih kunci End Sub Private Sub Timer1_Timer() Label4.Caption = Time Label3.Caption = Date End Sub Private Sub lihatdata() Dim rs As New Recordset Set rs = New Recordset rs.Open "select * from jurusan", cn Set DataGrid1.DataSource = rs.DataSource aturgridjurusan End Sub Private Sub aturgridjurusan() With DataGrid1 .Columns(0).Caption = "Jurusan": .Columns(0).Width = 3000 .Columns(1).Caption = "Nomor SK Berdiri": .Columns(1).Width = 2500 .Columns(2).Caption = "Tanggal SK": .Columns(2).Width = 2000 .Columns(2).NumberFormat = "dd-mm-yyyy"

Page 35: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 35

End With End Sub Sub bersih() txtjurusan.Text = "" txtsk.Text = "" End Sub Sub kunci() txtjurusan.Enabled = False txtsk.Enabled = False DTPicker1.Enabled = False cmdsimpan.Enabled = False cmdhapus.Enabled = False cmdedit.Enabled = False cmdtambah.Enabled = True End Sub Sub bukakunci() txtjurusan.Enabled = True txtsk.Enabled = True DTPicker1.Enabled = True cmdsimpan.Enabled = True End Sub Private Sub Form_Unload(Cancel As Integer) Frm_admin.Enabled = True End Sub Ø Form Laporan Admin Private Sub biodosen_Click() lpr_dosen.Show End Sub

Page 36: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 36

Private Sub biodosen_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) biodosen.ForeColor = &HFF& End Sub Private Sub biomahasiswa_Click() lpr_mahasiswa.Show End Sub Private Sub biomahasiswa_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) biomahasiswa.ForeColor = &HFF& End Sub Private Sub dosen_Click() lpr_dosen.Show End Sub Private Sub dosen_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) dosen.ForeColor = &HFF& End Sub Private Sub Form_LostFocus() Unload Me End Sub Private Sub Form_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) kuliah.ForeColor = &H80000012 mahasiswa.ForeColor = &H80000012 dosen.ForeColor = &H80000012 nilai.ForeColor = &H80000012 biomahasiswa.ForeColor = &H80000012 biodosen.ForeColor = &H80000012 kurikulum.ForeColor = &H80000012 End Sub Private Sub kuliah_Click() lpr_jadwalkuliah.Show End Sub Private Sub kuliah_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) kuliah.ForeColor = &HFF& End Sub

Page 37: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 37

Private Sub kurikulum_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) kurikulum.ForeColor = &HFF& End Sub Private Sub mahasiswa_Click() Form1.Show End Sub Private Sub mahasiswa_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) mahasiswa.ForeColor = &HFF& End Sub Private Sub nilai_Click() Lpr_nilai.Show End Sub Private Sub nilai_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) nilai.ForeColor = &HFF& End Sub Ø From mahasiswa Private Sub cmbjurusan_LostFocus() ambilprodi End Sub

Page 38: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 38

Private Sub cmbprodi_GotFocus() If cmbjurusan.Text = "" Then MsgBox "Pilih Jurusan Terlebih Dahulu", vbInformation, "Infomasi" End If End Sub Private Sub cmdedit_Click() If cmdedit.Caption = "&Edit" Then bukakunci txtnim.Enabled = False: txtnama.SetFocus cmdsimpan.Visible = False cmdedit.Caption = "&Simpan" cmdedit.Enabled = True ElseIf cmdedit.Caption = "&Simpan" Then Dim rsedit As Recordset Dim edit As String Set rsedit = New Recordset edit = "update mahasiswa set nama = '" & Trim(txtnama.Text) & "',tempat_lahir='" & Trim(txttempatlahir.Text) & "',tanggal_lahir='" & Trim(DTPicker1.Value) & "',warga_negara='" & Trim(txtnegara.Text) & "',alamat_rumah='" & Trim(txtalamat.Text) & "',no_telp_rumah='" & Trim(txttelp.Text) & "',no_hp='" & Trim(txthp.Text) & "',jenis_kelamin='" & Trim(cmbkelamin.Text) & "',agama='" & Trim(cmbagama.Text) & "',jurusan='" & Trim(cmbjurusan.Text) & "',program_studi='" & Trim(cmbprodi.Text) & "',nama_ortu='" & Trim(txtnamaortu.Text) & "',pekerjaan_ortu='" & Trim(txtpekerjaanortu.Text) & "',alamat_ortu='" & Trim(txtalamatortu.Text) & "' where nim='" & Trim(txtnim.Text) & "'" rsedit.Open edit, cn cmdedit.Caption = "&Edit": cmdsimpan.Visible = True cmdtambah.Enabled = True MsgBox "Data Dengan NIM : " & Trim(txtnim.Text) & " Berhasil Di Edit", vbInformation, "Data Diedit" bersih kunci End If lihatdata aturgrid End Sub Private Sub cmdhapus_Click() Dim rsperiksa As Recordset Set rsperiksa = New Recordset Dim rsperiksa2 As Recordset Set rsperiksa2 = New Recordset

Page 39: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 39

rsperiksa.Open " select * from belajar where nim = '" & Trim(txtnim.Text) & "'", cn rsperiksa2.Open " select * from marksheet where nim = '" & Trim(txtnim.Text) & "'", cn If Not rsperiksa.EOF Or Not rsperiksa2.EOF Then MsgBox "mahasiswa : " & Trim(txtnama.Text) & " Tidak bisa dihapus Karena Data Masih Digunakan Di Belajar atau marksheet!! ", vbInformation, "Informasi..." ElseIf MsgBox("Yakin Data Ini Akan Dihapus?...", vbQuestion + vbYesNo, "Hapus Data?...") = vbYes Then Dim rshapus As Recordset Set rshapus = New Recordset rshapus.Open "Delete from mahasiswa where nim = '" & Trim(txtnim.Text) & "'", cn MsgBox "Data Berhasil Dihapus", vbInformation, "Penghapusan Data.." Else MsgBox "Data Batal Dihapus...", vbInformation, "Penghapusan Batal..." End If lihatdata aturgrid bersih kunci End Sub Private Sub cmdsimpan_Click() If txtnim.Text = "" Or cmbjurusan.Text = "" Or cmbprodi.Text = "" Then MsgBox "Data NIM,Jurusan dan Program Studi Tidak Boleh Kosong", vbCritical, "Kesalahan" Else Dim rsperiksa As Recordset Set rsperiksa = New Recordset rsperiksa.Open "select * from Mahasiswa where NIM = '" & Trim(txtnim.Text) & "'", cn If Not rsperiksa.EOF Then MsgBox "NIM : " & Trim(txtnim.Text) & " Sudah ada !!", vbInformation, "Data Ditemukan..." bersih Else Dim rsinsert As Recordset Set rsinsert = New Recordset rsinsert.Open "insert into mahasiswa(nim,nama,tempat_lahir,tanggal_lahir,jenis_Kelamin,agama,warga_negara,jurusan,program_studi,alamat_rumah,no_Telp_rumah,no_hp,nama_ortu,pekerjaan_ortu,alamat_ortu)" _ & " values('" & Trim(txtnim.Text) & "','" & Trim(txtnama.Text) & "','" & Trim(txttempatlahir.Text) & "','" & Trim(DTPicker1.Value) & "','" & Trim(cmbkelamin.Text) & "','" & Trim(cmbagama.Text) & "','" & Trim(txtnegara.Text) & "','" & Trim(cmbjurusan.Text) & "','" & Trim(cmbprodi.Text) & "','" & Trim(txtalamat.Text) & "','" &

Page 40: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 40

Trim(txttelp.Text) & "','" & Trim(txthp.Text) & "','" & Trim(txtnamaortu.Text) & "','" & Trim(txtpekerjaanortu.Text) & "','" & Trim(txtalamatortu.Text) & "')", cn MsgBox "Data Mahasiswa " & txtnama.Text & " Sudah Disimpan ", vbInformation, "Berhasil Disimpan" bersih kunci lihatdata aturgrid cmdtambah.Caption = "&Tambah" DTPicker1.Value = Now End If End If End Sub Private Sub cmdtambah_Click() If cmdtambah.Caption = "&Tambah" Then bukakunci cmdtambah.Caption = "&Cancel" ElseIf cmdtambah.Caption = "&Cancel" Then kunci cmdtambah.Caption = "&Tambah" bersih End If End Sub Private Sub cmdtutup_Click() Frm_admin.Enabled = True Unload Me End Sub Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer) cmdtambah.Enabled = False: cmdsimpan.Enabled = False cmdhapus.Enabled = True: cmdedit.Enabled = True With DataGrid1 txtnim = Trim(.Columns(0).Text) End With Dim rscari As Recordset Dim strcari As String Set rscari = New Recordset strcari = "select * from mahasiswa where nim= '" & Trim(DataGrid1.Columns(0).Text) & "'" rscari.Open strcari, cn If Not rscari.EOF Then txtnama.Text = rscari.Fields("nama") txttempatlahir.Text = rscari.Fields("tempat_lahir") DTPicker1.Value = rscari.Fields("Tanggal_lahir") txtnegara.Text = rscari.Fields("warga_negara") cmbjurusan.Text = rscari.Fields("jurusan")

Page 41: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 41

cmbprodi.Text = rscari.Fields("Program_studi") txtalamat.Text = rscari.Fields("Alamat_rumah") txttelp.Text = rscari.Fields("no_telp_rumah") txthp.Text = rscari.Fields("no_hp") txtnamaortu.Text = rscari.Fields("nama_ortu") txtpekerjaanortu.Text = rscari.Fields("pekerjaan_ortu") txtalamatortu.Text = rscari.Fields("Alamat_ortu") cmbkelamin.Text = rscari.Fields("jenis_kelamin") cmbagama.Text = rscari.Fields("agama") End If End Sub Private Sub Form_Activate() lihatdata ambiljurusan aturgrid lhSysMenu = GetSystemMenu(Me.hwnd, False) lRetVal = RemoveMenu(lhSysMenu, SC_MOVE, MF_BYCOMMAND) End Sub Private Sub Form_Load() koneksi kunci End Sub Private Sub Timer1_Timer() Label4.Caption = Time Label3.Caption = Date End Sub Private Sub lihatdata() Dim rs As Recordset Set rs = New Recordset rs.Open "select * from mahasiswa", cn Set DataGrid1.DataSource = rs.DataSource End Sub Private Sub ambiljurusan() Dim rsjurusan As Recordset Set rsjurusan = New Recordset rsjurusan.Open "select jurusan from program_studi group by jurusan", cn cmbjurusan.Clear For i = 1 To rsjurusan.RecordCount cmbjurusan.AddItem rsjurusan.Fields("jurusan") rsjurusan.MoveNext Next i End Sub Private Sub ambilprodi()

Page 42: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 42

Dim rsjurusan2 As Recordset Set rsjurusan2 = New Recordset rsjurusan2.Open "select * from program_studi where jurusan = '" & Trim(cmbjurusan.Text) & "'", cn cmbprodi.Clear For i = 1 To rsjurusan2.RecordCount cmbprodi.AddItem rsjurusan2.Fields("program_studi") rsjurusan2.MoveNext Next i End Sub Private Sub aturgrid() With DataGrid1 .Columns(0).Caption = "Nim": .Columns(0).Width = 1200 .Columns(1).Caption = "Nama": .Columns(1).Width = 1500 .Columns(2).Caption = "Tempat Lahir": .Columns(2).Width = 1500 .Columns(3).Caption = "Tanggal Lahir": .Columns(3).Width = 1200 .Columns(3).NumberFormat = "dd-mm-yyyy" .Columns(4).Caption = "Jenis Kelamin": .Columns(4).Width = 1100 .Columns(5).Caption = "Agama": .Columns(5).Width = 1000 .Columns(6).Caption = "Negara": .Columns(6).Width = 1000 .Columns(7).Caption = "Jurusan": .Columns(7).Width = 1100 .Columns(8).Caption = "Program Studi": .Columns(8).Width = 1300 End With End Sub Sub kunci() txtnim.Enabled = False txtnama.Enabled = False txttempatlahir.Enabled = False DTPicker1.Enabled = False txtnegara.Enabled = False txtalamat.Enabled = False txttelp.Enabled = False txthp.Enabled = False cmbkelamin.Enabled = False cmbagama.Enabled = False cmbjurusan.Enabled = False cmbprodi.Enabled = False txtnamaortu.Enabled = False txtpekerjaanortu.Enabled = False txtalamatortu.Enabled = False cmdsimpan.Enabled = False cmdhapus.Enabled = False cmdedit.Enabled = False cmdtambah.Enabled = True End Sub Sub bukakunci() txtnim.Enabled = True

Page 43: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 43

txtnama.Enabled = True txttempatlahir.Enabled = True DTPicker1.Enabled = True txtnegara.Enabled = True txtalamat.Enabled = True txttelp.Enabled = True txthp.Enabled = True cmbkelamin.Enabled = True cmbagama.Enabled = True cmbjurusan.Enabled = True cmbprodi.Enabled = True txtnamaortu.Enabled = True txtpekerjaanortu.Enabled = True txtalamatortu.Enabled = True cmdsimpan.Enabled = True cmdhapus.Enabled = False cmdedit.Enabled = False End Sub Sub bersih() txtnim.Text = "" txtnama.Text = "" txttempatlahir.Text = "" txtnegara.Text = "" txtalamat.Text = "" txttelp.Text = "" txthp.Text = "" cmbkelamin.Text = "" cmbagama.Text = "" cmbjurusan.Text = "" cmbprodi.Text = "" txtnamaortu.Text = "" txtpekerjaanortu.Text = "" txtalamatortu.Text = "" End Sub Private Sub Form_Unload(Cancel As Integer) Frm_admin.Enabled = True End Sub Private Sub txthp_KeyPress(KeyAscii As Integer) If InStr("0123456789,", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If

Page 44: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 44

End Sub Private Sub txttelp_KeyPress(KeyAscii As Integer) If InStr("0123456789,", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub Ø Form MarkSheet Private Sub cmbhuruf_KeyPress(KeyAscii As Integer) If InStr("", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0

Page 45: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 45

End If End If End Sub Private Sub cmbhuruf_LostFocus() ambilkode End Sub Private Sub cmbkode_KeyPress(KeyAscii As Integer) If InStr("", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub Private Sub cmbmutu_KeyPress(KeyAscii As Integer) If InStr("", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub Private Sub cmdedit_Click() If cmdedit.Caption = "&Edit" Then bukakunci cmbhuruf.Enabled = False cmdsimpan.Visible = False cmdedit.Caption = "&Simpan" cmdedit.Enabled = True ElseIf cmdedit.Caption = "&Simpan" Then Dim rsedit As Recordset Dim edit As String Set rsedit = New Recordset edit = "update marksheet set tahun_akademik='" & Trim(txttahun.Text) & "',kode_mata_kuliah='" & Trim(cmbkode.Text) & "',huruf_mutu='" & Trim(cmbmutu.Text) & "' where nim='" & Trim(cmbhuruf.Text) & "' " rsedit.Open edit, cn cmdedit.Caption = "&Edit": cmdsimpan.Visible = True cmdtambah.Enabled = True MsgBox "Data Berhasil Di Edit", vbInformation, "Data Diedit" bersih kunci End If lihatdata aturgrid cmdsimpan.Enabled = False End Sub

Page 46: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 46

Private Sub cmdhapus_Click() If MsgBox("Yakin Data Ini Akan Dihapus?...", vbQuestion + vbYesNo, "Hapus Data?...") = vbYes Then Dim rshapus As Recordset Set rshapus = New Recordset rshapus.Open "Delete from marksheet where nim = '" & Trim(cmbhuruf.Text) & "' and kode_mata_kuliah='" & Trim(cmbkode.Text) & "' and tahun_akademik='" & Trim(txttahun.Text) & "'", cn MsgBox "Data Berhasil Dihapus", vbInformation, "Penghapusan Data.." Else MsgBox "Data Batal Dihapus...", vbInformation, "Penghapusan Batal..." End If lihatdata aturgrid bersih kunci cmdtambah.Enabled = True cmdsimpan.Enabled = False End Sub Private Sub cmdsimpan_Click() If cmbhuruf.Text = "" And txttahun.Text = "" And cmbkode.Text = "" And cmbmutu.Text = "" Then MsgBox "Data Tidak Boleh Ada Yang Kosong", vbCritical, "Kesalahan" Else Dim rsperiksa As Recordset Set rsperiksa = New Recordset rsperiksa.Open "select * from marksheet where nim = '" & Trim(cmbhuruf.Text) & "' and tahun_akademik='" & Trim(txttahun.Text) & "' and kode_mata_kuliah = '" & Trim(cmbkode.Text) & "'", cn If Not rsperiksa.EOF Then MsgBox "Data Sudah ada !!", vbInformation, "Data Ditemukan..." bersih Else Dim rsinsert As Recordset Set rsinsert = New Recordset rsinsert.Open "insert into marksheet(tahun_akademik,NIM,kode_mata_kuliah,huruf_mutu) values('" & Trim(txttahun.Text) & "','" & Trim(cmbhuruf.Text) & "','" & Trim(cmbkode.Text) & "','" & Trim(cmbmutu.Text) & "')", cn MsgBox "Data Sudah Disimpan ", vbInformation, "Berhasil Disimpan" bersih kunci lihatdata aturgrid cmdtambah.Caption = "&Tambah" cmdsimpan.Enabled = False

Page 47: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 47

End If End If End Sub Private Sub cmdtambah_Click() If cmdtambah.Caption = "&Tambah" Then bukakunci cmdtambah.Caption = "&Cancel" ElseIf cmdtambah.Caption = "&Cancel" Then bersih kunci cmdtambah.Caption = "&Tambah" cmdsimpan.Enabled = False End If End Sub Private Sub cmdtutup_Click() Frm_admin.Enabled = True Unload Me End Sub Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer) cmbhuruf.Enabled = False cmdhapus.Enabled = True cmdedit.Enabled = True With DataGrid1 cmbhuruf = Trim(.Columns(1).Text) End With Dim rscari As Recordset Dim strcari As String Set rscari = New Recordset strcari = "select * from marksheet where nim= '" & Trim(DataGrid1.Columns(1).Text) & "'" rscari.Open strcari, cn If Not rscari.EOF Then cmbhuruf.Text = rscari.Fields("nim") txttahun.Text = rscari.Fields("tahun_akademik") cmbkode.Text = rscari.Fields("kode_mata_kuliah") cmbmutu.Text = rscari.Fields("huruf_mutu") End If End Sub Private Sub Form_Load() koneksi lihatdata ambilnim ambilhuruf kunci

Page 48: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 48

aturgrid cmdsimpan.Enabled = False lhSysMenu = GetSystemMenu(Me.hwnd, False) lRetVal = RemoveMenu(lhSysMenu, SC_MOVE, MF_BYCOMMAND) End Sub Private Sub Timer1_Timer() Label4.Caption = Time Label3.Caption = Date End Sub Sub kunci() cmbhuruf.Enabled = False cmbkode.Enabled = False cmbmutu.Enabled = False cmdsimpan.Enabled = True cmdhapus.Enabled = False cmdedit.Enabled = False cmdtambah.Enabled = True txttahun.Enabled = False End Sub Sub bukakunci() cmbhuruf.Enabled = True cmbkode.Enabled = True txttahun.Enabled = True cmbmutu.Enabled = True cmdsimpan.Enabled = True cmdhapus.Enabled = False cmdedit.Enabled = False End Sub Sub bersih() cmbhuruf.Text = "" cmbkode.Text = "" cmbmutu.Text = "" txttahun.Text = "" End Sub Private Sub lihatdata() Dim rs As Recordset Set rs = New Recordset rs.Open "select * from marksheet", cn Set DataGrid1.DataSource = rs.DataSource aturgrid End Sub Private Sub aturgrid() With DataGrid1 .Columns(0).Caption = "Tahun Akademik": .Columns(0).Width = 1500 .Columns(1).Caption = "NIM": .Columns(1).Width = 1000

Page 49: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 49

.Columns(2).Caption = "Kode Mata Kuliah": .Columns(2).Width = 1500

.Columns(3).Caption = "Huruf Mutu": .Columns(3).Width = 1200 End With End Sub Private Sub ambilnim() Dim rsnim As Recordset Set rsnim = New Recordset rsnim.Open "select * from belajar", cn cmbhuruf.Clear For i = 1 To rsnim.RecordCount cmbhuruf.AddItem rsnim.Fields("nim") rsnim.MoveNext Next i End Sub Private Sub ambilkode() Dim rskode As Recordset Set rskode = New Recordset rskode.Open "select * from belajar where nim='" & Trim(cmbhuruf.Text) & "'", cn cmbkode.Clear For i = 1 To rskode.RecordCount cmbkode.AddItem rskode.Fields("kode_mata_kuliah") rskode.MoveNext Next i End Sub Private Sub ambilhuruf() Dim rshuruf As Recordset Set rshuruf = New Recordset rshuruf.Open "select * from nilai", cn cmbmutu.Clear For i = 1 To rshuruf.RecordCount cmbmutu.AddItem rshuruf.Fields("huruf_mutu") rshuruf.MoveNext Next i End Sub Private Sub Form_Unload(Cancel As Integer) Frm_admin.Enabled = True End Sub Private Sub txttahun_KeyPress(KeyAscii As Integer) If InStr("0123456789", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub

Page 50: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 50

Ø Form Matakuliah Private Sub cmdedit_Click() If cmdedit.Caption = "&Edit" Then bukakunci txtkode.Enabled = False txtnama.Enabled = False cmdsimpan.Visible = False

Page 51: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 51

cmdedit.Caption = "&Simpan" cmdedit.Enabled = True ElseIf cmdedit.Caption = "&Simpan" Then Dim rsedit As Recordset Dim edit As String Set rsedit = New Recordset edit = "update mata_kuliah set sks='" & Trim(cmbsks.Text) & "',jumlah_jam_teori='" & Trim(txtteori.Text) & "',Jumlah_jam_praktek='" & Trim(txtpraktek.Text) & "',Semester='" & Trim(cmbsemester.Text) & "' where kode_mata_kuliah='" & Trim(txtkode.Text) & "'" rsedit.Open edit, cn cmdedit.Caption = "&Edit": cmdsimpan.Visible = True cmdtambah.Enabled = True MsgBox "Data Mata Kuliah : " & Trim(txtnama.Text) & " Berhasil Di Edit", vbInformation, "Data Diedit" bersih kunci End If lihatdata aturgrid End Sub Private Sub cmdhapus_Click() Dim rsperiksa As Recordset Set rsperiksa = New Recordset rsperiksa.Open " select * from mengajar where kode_mata_kuliah = '" & Trim(txtkode.Text) & "'", cn If Not rsperiksa.EOF Then MsgBox "mata kuliah : " & Trim(txtnama.Text) & " Tidak bisa dihapus Karena Data Masih Digunakan Di Mengajar !! ", vbInformation, "Informasi..." ElseIf MsgBox("Yakin Data Ini Akan Dihapus?...", vbQuestion + vbYesNo, "Hapus Data?...") = vbYes Then Dim rshapus As Recordset Set rshapus = New Recordset rshapus.Open "Delete from mata_kuliah where kode_mata_kuliah = '" & Trim(txtkode.Text) & "'", cn MsgBox "Data Berhasil Dihapus", vbInformation, "Penghapusan Data.." Else MsgBox "Data Batal Dihapus...", vbInformation, "Penghapusan Batal..." End If lihatdata aturgrid bersih kunci cmdtambah.Enabled = True cmdsimpan.Enabled = False End Sub

Page 52: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 52

Private Sub cmdsimpan_Click() If txtkode.Text = "" Then MsgBox "Kode Mata Kuliah Tidak Boleh Kosong", vbCritical, "Kesalahan" Else Dim rsperiksa As Recordset Set rsperiksa = New Recordset rsperiksa.Open "select * from mata_kuliah where kode_mata_kuliah = '" & Trim(txtkode.Text) & "'", cn If Not rsperiksa.EOF Then MsgBox "Kode Mata Kuliah : " & Trim(txtkode.Text) & " Sudah ada !!", vbInformation, "Data Ditemukan..." bersih Else Dim rsinsert As Recordset Set rsinsert = New Recordset rsinsert.Open "insert into mata_kuliah(kode_mata_kuliah,mata_kuliah,sks,jumlah_jam_teori,jumlah_jam_praktek,semester) values('" & Trim(txtkode.Text) & "','" & Trim(txtnama.Text) & "','" & Trim(cmbsks.Text) & "','" & Trim(txtteori.Text) & "','" & Trim(txtpraktek.Text) & "','" & Trim(cmbsemester.Text) & "')", cn MsgBox "Data Mata Kuliah " & txtnama.Text & " Sudah Disimpan ", vbInformation, "Berhasil Disimpan" bersih kunci lihatdata aturgrid cmdtambah.Caption = "&Tambah" cmdsimpan.Enabled = False End If End If End Sub Private Sub cmdtambah_Click() If cmdtambah.Caption = "&Tambah" Then bukakunci cmdtambah.Caption = "&Cancel" ElseIf cmdtambah.Caption = "&Cancel" Then kunci cmdtambah.Caption = "&Tambah" bersih cmdsimpan.Enabled = False End If End Sub Private Sub cmdtutup_Click() Frm_admin.Enabled = True Unload Me End Sub

Page 53: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 53

Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer) cmdtambah.Enabled = False: cmdsimpan.Enabled = False cmdhapus.Enabled = True: cmdedit.Enabled = True With DataGrid1 txtkode = Trim(.Columns(0).Text) End With Dim rscari As Recordset Dim strcari As String Set rscari = New Recordset strcari = "select * from mata_kuliah where kode_mata_kuliah= '" & Trim(DataGrid1.Columns(0).Text) & "'" rscari.Open strcari, cn If Not rscari.EOF Then txtkode.Text = rscari.Fields("kode_mata_kuliah") txtnama.Text = rscari.Fields("mata_kuliah") cmbsks.Text = rscari.Fields("sks") txtteori.Text = rscari.Fields("jumlah_jam_teori") txtpraktek.Text = rscari.Fields("jumlah_jam_praktek") cmbsemester.Text = rscari.Fields("semester") End If End Sub Private Sub Form_Activate() lihatdata aturgrid lhSysMenu = GetSystemMenu(Me.hwnd, False) lRetVal = RemoveMenu(lhSysMenu, SC_MOVE, MF_BYCOMMAND) End Sub Private Sub Form_Load() koneksi kunci lihatdata aturgrid cmdsimpan.Enabled = False End Sub Private Sub Timer1_Timer() Label4.Caption = Time Label3.Caption = Date End Sub Sub kunci() txtkode.Enabled = False txtnama.Enabled = False

Page 54: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 54

cmbsks.Enabled = False txtteori.Enabled = False txtpraktek.Enabled = False cmbsemester.Enabled = False cmdsimpan.Enabled = True cmdhapus.Enabled = False cmdedit.Enabled = False cmdtambah.Enabled = True End Sub Sub bukakunci() txtkode.Enabled = True txtnama.Enabled = True cmbsks.Enabled = True txtteori.Enabled = True txtpraktek.Enabled = True cmbsemester.Enabled = True cmdsimpan.Enabled = True cmdhapus.Enabled = False cmdedit.Enabled = False End Sub Sub bersih() txtkode.Text = "" txtnama.Text = "" cmbsks.Text = "" txtteori.Text = "" txtpraktek.Text = "" cmbsemester.Text = "" End Sub Private Sub lihatdata() Dim rs As Recordset Set rs = New Recordset rs.Open "select * from mata_kuliah", cn Set DataGrid1.DataSource = rs.DataSource aturgrid End Sub Private Sub aturgrid() With DataGrid1 .Columns(0).Caption = "Kode Mata Kuliah": .Columns(0).Width = 1500 .Columns(1).Caption = "Mata Kuliah": .Columns(1).Width = 1500 .Columns(2).Caption = "sks": .Columns(2).Width = 500 .Columns(3).Caption = "Jumlah Jam Teori": .Columns(3).Width = 1350 .Columns(4).Caption = "Jumlah Jam Praktek": .Columns(4).Width = 1550

Page 55: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 55

.Columns(5).Caption = "Semester": .Columns(5).Width = 800 End With End Sub Private Sub Form_Unload(Cancel As Integer) Frm_admin.Enabled = True End Sub Private Sub txtpraktek_KeyPress(KeyAscii As Integer) If InStr("0123456789,", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub Private Sub txtteori_KeyPress(KeyAscii As Integer) If InStr("0123456789,", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub Ø Form Mengajar Private Sub cmbhari_KeyPress(KeyAscii As Integer) If InStr("", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub

Page 56: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 56

Private Sub cmbjurusan_KeyPress(KeyAscii As Integer) If InStr("", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub Private Sub cmbjurusan_LostFocus() ambilprodi End Sub Private Sub cmbkode_KeyPress(KeyAscii As Integer) If InStr("", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub Private Sub cmbkode_LostFocus() ambilnamamatakuliah End Sub Private Sub cmbnip_KeyPress(KeyAscii As Integer) If InStr("", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub Private Sub cmbnip_LostFocus() ambildosen End Sub Private Sub cmbprodi_GotFocus() If cmbjurusan.Text = "" Then MsgBox "Silahkan Pilih Jurusan Terlebih dahulu", vbInformation, "Infomasi" cmbjurusan.Text = "" End If End Sub Private Sub cmbprodi_KeyPress(KeyAscii As Integer) If InStr("", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If

Page 57: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 57

End If End Sub Private Sub cmdedit_Click() If cmdedit.Caption = "&Edit" Then bukakunci DTPicker1.Enabled = False: cmbnip.Enabled = False: cmbkode.Enabled = False: cmbhari.Enabled = False: txtminggu.Enabled = False cmdsimpan.Visible = False cmdedit.Caption = "&Simpan" cmdedit.Enabled = True ElseIf cmdedit.Caption = "&Simpan" Then Dim rsedit As Recordset Dim edit As String Set rsedit = New Recordset edit = "update mengajar set tempat = '" & Trim(txttempat.Text) & "',jam_teori='" & Trim(txtteori.Text) & "',jam_praktek='" & Trim(txtpraktek.Text) & "',jam_ke='" & Trim(txtjamke.Text) & "',sd_jam_ke='" & Trim(txtsdjam.Text) & "',jurusan='" & Trim(cmbjurusan.Text) & "',program_studi='" & Trim(cmbprodi.Text) & "',topik_materi='" & Trim(txtmateri.Text) & "' where nip = '" & Trim(cmbnip.Text) & "' and tanggal='" & Trim(DTPicker1.Value) & "' and kode_mata_kuliah= '" & Trim(cmbkode.Text) & "'" rsedit.Open edit, cn cmdedit.Caption = "&Edit": cmdsimpan.Visible = True cmdtambah.Enabled = True MsgBox "Data Berhasil Di Edit", vbInformation, "Data Diedit" bersih kunci End If lihatdata aturgrid cmdsimpan.Enabled = False End Sub Private Sub cmdhapus_Click() If MsgBox("Yakin Data Ini Akan Dihapus?...", vbQuestion + vbYesNo, "Hapus Data?...") = vbYes Then Dim rshapus As Recordset Set rshapus = New Recordset rshapus.Open "Delete from mengajar where nip = '" & Trim(cmbnip.Text) & "' and tanggal='" & Trim(DTPicker1.Value) & "' and kode_mata_kuliah= '" & Trim(cmbkode.Text) & "'", cn MsgBox "Data Berhasil Dihapus", vbInformation, "Penghapusan Data.." Else MsgBox "Data Batal Dihapus...", vbInformation, "Penghapusan Batal..." End If lihatdata aturgrid bersih

Page 58: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 58

kunci cmdtambah.Enabled = True cmdsimpan.Enabled = False End Sub Private Sub cmdsimpan_Click() If cmbhari.Text = "" Or cmbnip.Text = "" Or cmbjurusan.Text = "" Or cmbprodi.Text = "" Or cmbkode.Text = "" Then MsgBox "Data Hari,NIP,Jurusan,Program Studi dan Kode Mata Kuliah Tidak Boleh Kosong", vbCritical, "Kesalahan" Else Dim rsinsert As Recordset Set rsinsert = New Recordset rsinsert.Open "insert into mengajar(hari,Tanggal,minggu_ke,NIP,jurusan,program_studi,kode_mata_kuliah,tempat,jam_teori,jam_praktek,jam_ke,sd_jam_ke,topik_materi)" _ & " values('" & Trim(cmbhari.Text) & "','" & Trim(DTPicker1.Value) & "','" & Trim(txtminggu.Text) & "','" & Trim(cmbnip.Text) & "','" & Trim(cmbjurusan.Text) & "','" & Trim(cmbprodi.Text) & "','" & Trim(cmbkode.Text) & "','" & Trim(txttempat.Text) & "','" & Trim(txtteori.Text) & "','" & Trim(txtpraktek.Text) & "','" & Trim(txtjamke.Text) & "','" & Trim(txtsdjam.Text) & "','" & Trim(txtmateri.Text) & "')", cn MsgBox "Data Sudah Disimpan ", vbInformation, "Berhasil Disimpan" bersih kunci lihatdata aturgrid cmdtambah.Caption = "&Tambah" cmdsimpan.Enabled = False End If End Sub Private Sub cmdtambah_Click() If cmdtambah.Caption = "&Tambah" Then bukakunci cmdtambah.Caption = "&Cancel" ElseIf cmdtambah.Caption = "&Cancel" Then bersih kunci cmdtambah.Caption = "&Tambah" cmdsimpan.Enabled = False End If End Sub Private Sub cmdtutup_Click() Frm_admin.Enabled = True Unload Me End Sub

Page 59: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 59

Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer) cmdtambah.Enabled = False: cmdsimpan.Enabled = False cmdhapus.Enabled = True: cmdedit.Enabled = True With DataGrid1 cmbnip = Trim(.Columns(3).Text) End With Dim rscari As Recordset Dim strcari As String Set rscari = New Recordset strcari = "select * from mengajar where nip= '" & Trim(DataGrid1.Columns(3).Text) & "'" rscari.Open strcari, cn If Not rscari.EOF Then cmbhari.Text = rscari.Fields("hari") DTPicker1.Value = rscari.Fields("tanggal") txtminggu.Text = rscari.Fields("minggu_ke") cmbnip.Text = rscari.Fields("nip") cmbjurusan.Text = rscari.Fields("jurusan") cmbprodi.Text = rscari.Fields("Program_studi") cmbkode.Text = rscari.Fields("kode_mata_kuliah") txttempat.Text = rscari.Fields("tempat") txtteori.Text = rscari.Fields("jam_teori") txtpraktek.Text = rscari.Fields("jam_praktek") txtjamke.Text = rscari.Fields("jam_ke") txtsdjam.Text = rscari.Fields("sd_jam_ke") txtmateri.Text = rscari.Fields("topik_materi") End If End Sub Private Sub Form_Activate() lihatdata aturgrid lhSysMenu = GetSystemMenu(Me.hwnd, False) lRetVal = RemoveMenu(lhSysMenu, SC_MOVE, MF_BYCOMMAND) End Sub Private Sub Form_Load() koneksi lihatdata ambilnip ambiljurusan ambilmatakuliah kunci cmdsimpan.Enabled = False lihatdata aturgrid End Sub

Page 60: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 60

Private Sub Timer1_Timer() Label4.Caption = Time Label3.Caption = Date End Sub Private Sub ambilnip() Dim rsnip As Recordset Set rsnip = New Recordset rsnip.Open "select * from dosen", cn cmbnip.Clear For i = 1 To rsnip.RecordCount cmbnip.AddItem rsnip.Fields("NIP") rsnip.MoveNext Next i End Sub Private Sub ambiljurusan() Dim rsjurusan As Recordset Set rsjurusan = New Recordset rsjurusan.Open "select jurusan from program_studi group by jurusan", cn cmbjurusan.Clear For i = 1 To rsjurusan.RecordCount cmbjurusan.AddItem rsjurusan.Fields("jurusan") rsjurusan.MoveNext Next i End Sub Private Sub ambilprodi() Dim rsjurusan2 As Recordset Set rsjurusan2 = New Recordset rsjurusan2.Open "select * from program_studi where jurusan = '" & Trim(cmbjurusan.Text) & "'", cn cmbprodi.Clear For i = 1 To rsjurusan2.RecordCount cmbprodi.AddItem rsjurusan2.Fields("program_studi") rsjurusan2.MoveNext Next i End Sub Private Sub ambilmatakuliah() Dim rsmatakuliah As Recordset Set rsmatakuliah = New Recordset rsmatakuliah.Open "select * from mata_kuliah", cn cmbkode.Clear For i = 1 To rsmatakuliah.RecordCount cmbkode.AddItem rsmatakuliah.Fields("kode_mata_kuliah") rsmatakuliah.MoveNext Next i

Page 61: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 61

End Sub Private Sub ambildosen() Dim rsdosen As Recordset Set rsdosen = New Recordset rsdosen.Open "select * from dosen where nip = '" & Trim(cmbnip.Text) & "'", cn For i = 1 To rsdosen.RecordCount LBLDOSEN.Caption = rsdosen.Fields("nama") rsdosen.MoveNext Next i End Sub Private Sub ambilnamamatakuliah() Dim rsmatkul As Recordset Set rsmatkul = New Recordset rsmatkul.Open "select * from mata_kuliah where kode_mata_kuliah = '" & Trim(cmbkode.Text) & "'", cn For i = 1 To rsmatkul.RecordCount Label21.Caption = rsmatkul.Fields("mata_kuliah") rsmatkul.MoveNext Next i End Sub Sub kunci() DTPicker1.Enabled = False cmbhari.Enabled = False txtminggu.Enabled = False cmbnip.Enabled = False txttempat.Enabled = False txtteori.Enabled = False txtpraktek.Enabled = False txtjamke.Enabled = False txtsdjam.Enabled = False cmbjurusan.Enabled = False cmbprodi.Enabled = False cmbkode.Enabled = False txtmateri.Enabled = False cmdsimpan.Enabled = True cmdhapus.Enabled = False cmdedit.Enabled = False cmdtambah.Enabled = True End Sub Sub bukakunci() cmbhari.Enabled = True txtminggu.Enabled = True cmbnip.Enabled = True txttempat.Enabled = True txtteori.Enabled = True

Page 62: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 62

txtpraktek.Enabled = True txtjamke.Enabled = True txtsdjam.Enabled = True cmbjurusan.Enabled = True cmbprodi.Enabled = True cmbkode.Enabled = True txtmateri.Enabled = True cmdsimpan.Enabled = True cmdhapus.Enabled = False cmdedit.Enabled = False DTPicker1.Enabled = True End Sub Sub bersih() cmbhari.Text = "" txtminggu.Text = "" cmbnip.Text = "" txttempat.Text = "" txtteori.Text = "" txtpraktek.Text = "" txtjamke.Text = "" txtsdjam.Text = "" cmbjurusan.Text = "" cmbprodi.Text = "" cmbkode.Text = "" txtmateri.Text = "" LBLDOSEN.Caption = "" Label21.Caption = "" End Sub Private Sub lihatdata() Dim rs As Recordset Set rs = New Recordset rs.Open "select * from mengajar", cn Set DataGrid1.DataSource = rs.DataSource aturgrid End Sub Private Sub aturgrid() With DataGrid1 .Columns(0).Caption = "Hari": .Columns(0).Width = 700 .Columns(1).Caption = "Tanggal": .Columns(1).Width = 900 .Columns(1).NumberFormat = "dd-mm-yyyy" .Columns(2).Caption = "Minggu Ke": .Columns(2).Width = 900 .Columns(3).Caption = "NIP": .Columns(3).Width = 1350 .Columns(4).Caption = "Jurusan": .Columns(4).Width = 1550 .Columns(5).Caption = "Program Studi": .Columns(5).Width = 1500 .Columns(6).Caption = "Kode Mata Kuliah": .Columns(6).Width = 1500 .Columns(7).Caption = "Tempat": .Columns(7).Width = 800

Page 63: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 63

.Columns(8).Caption = "Jam Teori": .Columns(8).Width = 800

.Columns(9).Caption = "Jam Praktek": .Columns(9).Width = 950

.Columns(10).Caption = "Jam Ke": .Columns(10).Width = 600

.Columns(11).Caption = "S/d Jam Ke": .Columns(11).Width = 900

.Columns(12).Caption = "Topik Materi": .Columns(12).Width = 1000 End With End Sub Private Sub Form_Unload(Cancel As Integer) Frm_admin.Enabled = True End Sub Private Sub txtjamke_KeyPress(KeyAscii As Integer) If InStr("0123456789,", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub Private Sub txtpraktek_KeyPress(KeyAscii As Integer) If InStr("0123456789,", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub Private Sub txtsdjam_KeyPress(KeyAscii As Integer) If InStr("0123456789,", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub Private Sub txttempat_KeyPress(KeyAscii As Integer) If InStr("0123456789,", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub Private Sub txtteori_KeyPress(KeyAscii As Integer) If InStr("0123456789,", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If

Page 64: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 64

End Sub Ø Form Nilai Private Sub cmbhuruf_KeyPress(KeyAscii As Integer) If InStr("", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub Private Sub cmbhuruf_LostFocus()

Page 65: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 65

If cmbhuruf.Text = "A" Then txtangka.Text = "4": txtpredikat.Text = "Sangat Baik" End If If cmbhuruf.Text = "B" Then txtangka.Text = "3": txtpredikat.Text = "Baik" End If If cmbhuruf.Text = "C" Then txtangka.Text = "2": txtpredikat.Text = "Cukup" End If If cmbhuruf.Text = "D" Then txtangka.Text = "1": txtpredikat.Text = "Kurang" End If If cmbhuruf.Text = "E" Then txtangka.Text = "0": txtpredikat.Text = "Sangat Kurang" End If End Sub Private Sub cmdhapus_Click() Dim rsperiksa As Recordset Set rsperiksa = New Recordset rsperiksa.Open " select * from marksheet where huruf_mutu = '" & Trim(cmbhuruf.Text) & "'", cn If Not rsperiksa.EOF Then MsgBox "Nilai : " & Trim(cmbhuruf.Text) & " Tidak bisa dihapus Karena Data Masih Digunakan Di Marksheet !! ", vbInformation, "Informasi..." ElseIf MsgBox("Yakin Data Ini Akan Dihapus?...", vbQuestion + vbYesNo, "Hapus Data?...") = vbYes Then Dim rshapus As Recordset Set rshapus = New Recordset rshapus.Open "Delete from nilai where huruf_mutu = '" & Trim(cmbhuruf.Text) & "'", cn MsgBox "Data Berhasil Dihapus", vbInformation, "Penghapusan Data.." Else MsgBox "Data Batal Dihapus...", vbInformation, "Penghapusan Batal..." End If lihatdata aturgrid bersih kunci cmdtambah.Enabled = True cmdsimpan.Enabled = False End Sub Private Sub cmdsimpan_Click() If cmbhuruf.Text = "" Then MsgBox "Huruf Mutu dan Tidak Boleh Kosong", vbCritical, "Kesalahan" Else Dim rsperiksa As Recordset

Page 66: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 66

Set rsperiksa = New Recordset rsperiksa.Open "select * from nilai where huruf_mutu = '" & Trim(cmbhuruf.Text) & "'", cn If Not rsperiksa.EOF Then MsgBox "Data " & Trim(cmbhuruf.Text) & " Sudah ada !!", vbInformation, "Data Ditemukan..." bersih Else Dim rsinsert As Recordset Set rsinsert = New Recordset rsinsert.Open "insert into nilai(huruf_mutu,angka_mutu,predikat) values('" & Trim(cmbhuruf.Text) & "','" & Trim(txtangka.Text) & "','" & Trim(txtpredikat.Text) & "')", cn MsgBox "Nilai : " & Trim(cmbhuruf.Text) & " Sudah Disimpan ", vbInformation, "Berhasil Disimpan" bersih kunci lihatdata aturgrid cmdtambah.Caption = "&Tambah" cmdsimpan.Enabled = False End If End If End Sub Private Sub cmdtambah_Click() If cmdtambah.Caption = "&Tambah" Then bukakunci txtangka.Enabled = False txtpredikat.Enabled = False cmdtambah.Caption = "&Cancel" ElseIf cmdtambah.Caption = "&Cancel" Then bersih kunci cmdtambah.Caption = "&Tambah" cmdsimpan.Enabled = False End If End Sub Private Sub cmdtutup_Click() Frm_admin.Enabled = True Unload Me End Sub Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer) cmbhuruf.Enabled = False cmdhapus.Enabled = True With DataGrid1 cmbhuruf = Trim(.Columns(0).Text)

Page 67: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 67

End With Dim rscari As Recordset Dim strcari As String Set rscari = New Recordset strcari = "select * from nilai where huruf_mutu= '" & Trim(DataGrid1.Columns(0).Text) & "'" rscari.Open strcari, cn If Not rscari.EOF Then cmbhuruf.Text = rscari.Fields("huruf_mutu") txtangka.Text = rscari.Fields("angka_mutu") txtpredikat.Text = rscari.Fields("predikat") End If End Sub Private Sub Form_Load() koneksi lihatdata kunci aturgrid cmdsimpan.Enabled = False lhSysMenu = GetSystemMenu(Me.hwnd, False) lRetVal = RemoveMenu(lhSysMenu, SC_MOVE, MF_BYCOMMAND) End Sub Private Sub Timer1_Timer() Label4.Caption = Time Label3.Caption = Date End Sub Sub kunci() cmbhuruf.Enabled = False txtangka.Enabled = False txtpredikat.Enabled = False cmdsimpan.Enabled = True cmdhapus.Enabled = False cmdedit.Enabled = False cmdtambah.Enabled = True End Sub Sub bukakunci() cmbhuruf.Enabled = True txtangka.Enabled = True txtpredikat.Enabled = True cmdsimpan.Enabled = True cmdhapus.Enabled = False cmdedit.Enabled = False End Sub Sub bersih() cmbhuruf.Text = "" txtangka.Text = ""

Page 68: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 68

txtpredikat.Text = "" End Sub Private Sub lihatdata() Dim rs As Recordset Set rs = New Recordset rs.Open "select * from nilai", cn Set DataGrid1.DataSource = rs.DataSource aturgrid End Sub Private Sub aturgrid() With DataGrid1 .Columns(0).Caption = "Huruf Mutu": .Columns(0).Width = 1000 .Columns(1).Caption = "Angka Mutu": .Columns(1).Width = 1000 .Columns(2).Caption = "Predikat": .Columns(2).Width = 1200 End With End Sub Private Sub Form_Unload(Cancel As Integer) Frm_admin.Enabled = True End Sub Ø Form Program Studi Private Sub cmbjurusan_KeyPress(KeyAscii As Integer) MsgBox "Hanya boleh memasukan Kejurusan Yang sudah ada", vbCritical, "Kesalahan" If InStr("", Chr(KeyAscii)) = 0 Then If KeyAscii <> vbKeyBack Then KeyAscii = 0 End If End If End Sub Private Sub cmdedit_Click()

Page 69: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 69

If cmdedit.Caption = "&Edit" Then bukakunci txtprodi.Enabled = False: txtsk.SetFocus cmdsimpan.Visible = False cmdedit.Caption = "&Simpan" ElseIf cmdedit.Caption = "&Simpan" Then Dim rsedit As Recordset Dim edit As String Set rsedit = New Recordset edit = "update program_studi set no_sk_berdiri ='" & Trim(txtsk.Text) & "',tgl_sk='" & Trim(DTPicker1.Value) & "',jurusan = '" & Trim(cmbjurusan.Text) & "' where program_studi ='" & Trim(txtprodi.Text) & "'" rsedit.Open edit, cn cmdedit.Caption = "&Edit": cmdsimpan.Visible = True bersih kunci cmdtambah.Enabled = True End If lihatdata aturgrid End Sub Private Sub cmdhapus_Click() Dim rsperiksa As Recordset Set rsperiksa = New Recordset Dim rsperiksa2 As Recordset Set rsperiksa2 = New Recordset rsperiksa.Open " select * from Mahasiswa where program_studi = '" & Trim(txtprodi.Text) & "'", cn rsperiksa2.Open " select * from mengajar where program_studi = '" & Trim(txtprodi.Text) & "'", cn If Not rsperiksa.EOF Or Not rsperiksa2.EOF Then MsgBox "Program studi : " & Trim(txtprodi.Text) & " Tidak bisa dihapus Karena Data Masih Digunakan Di Mahasiswa atau mengajar!! ", vbInformation, "Informasi..." ElseIf MsgBox("yakin data ini akan dihapus?..", vbQuestion + vbYesNo, "Hapus Data?...") = vbYes Then Dim rshapus As Recordset Set rshapus = New Recordset rshapus.Open "delete from program_studi where program_studi = '" & Trim(txtprodi.Text) & "'", cn Else MsgBox " Data Tidak Jadi Dihapus", vbInformation, "Informasi" End If lihatdata aturgrid bersih kunci End Sub

Page 70: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 70

Private Sub cmdsimpan_Click() If cmbjurusan.Text = "" Then MsgBox "Jurusan Tidak Boleh Kosong", vbCritical, "Informasi" bersih bukakunci cmdsimpan.Enabled = True Else Dim rsperiksa As Recordset Set rsperiksa = New Recordset rsperiksa.Open "Select * from Jurusan where jurusan = '" & Trim(cmbjurusan.Text) & "'", cn If rsperiksa.EOF Then MsgBox "Jurusan : " & Trim(cmbjurusan.Text) & " yang di entry tidak ada !", vbInformation, "Data Tidak Ditemukan..." End If End If If txtprodi.Text = "" Then MsgBox "Program Studi Tidak Boleh Kosong", vbCritical, "Infomasi" txtprodi.SetFocus Else Dim rsperiksa2 As Recordset Set rsperiksa2 = New Recordset rsperiksa2.Open "Select * from program_Studi where program_studi='" & Trim(txtprodi.Text) & "'", cn If Not rsperiksa2.EOF Then MsgBox "Program Studi : " & Trim(txtprodi.Text) & " sudah ada !! ", vbInformation, "Data ditemukan..." bersih bukakunci cmdsimpan.Enabled = True Else Dim rsinsert As Recordset Set rsinsert = New Recordset rsinsert.Open "Insert Into program_studi(Jurusan,program_studi,No_SK_Berdiri,tgl_sk) values ('" & cmbjurusan.Text & "','" & Trim(txtprodi.Text) & "','" & Trim(txtsk.Text) & "','" & Trim(DTPicker1.Value) & "')", cn MsgBox "Data Sudah Disimpan...", vbInformation, "Informasi..." cmdtambah.Caption = "&Tambah" kunci End If End If lihatdata aturgrid bersih End Sub Private Sub cmdtambah_Click() If cmdtambah.Caption = "&Tambah" Then

Page 71: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 71

bukakunci cmdtambah.Caption = "&Cancel" ElseIf cmdtambah.Caption = "&Cancel" Then bersih kunci cmdtambah.Caption = "&Tambah" End If End Sub Private Sub cmdtutup_Click() Frm_admin.Enabled = True Unload Me End Sub Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer) cmdtambah.Enabled = False: cmdsimpan.Enabled = False cmdhapus.Enabled = True: cmdedit.Enabled = True With DataGrid1 txtprodi = Trim(.Columns(1).Text) End With Dim rscari As Recordset Set rscari = New Recordset Dim strcari As String strcari = "Select * from program_studi where program_studi = '" & Trim(DataGrid1.Columns(1).Text) & "'" rscari.Open strcari, cn If Not rscari.EOF Then cmbjurusan.Text = rscari.Fields("Jurusan") txtprodi.Text = rscari.Fields("Program_studi") txtsk.Text = rscari.Fields("NO_SK_Berdiri") DTPicker1.Value = rscari.Fields("Tgl_sk") End If End Sub Private Sub Form_Activate() ambiljurusan lihatdata aturgrid kunci lhSysMenu = GetSystemMenu(Me.hwnd, False) lRetVal = RemoveMenu(lhSysMenu, SC_MOVE, MF_BYCOMMAND) End Sub Private Sub Form_Load() cmbjurusan.TabIndex = 0: txtprodi.TabIndex = 1: txtsk.TabIndex = 2: DTPicker1.TabIndex = 3

Page 72: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 72

koneksi End Sub Private Sub Form_Unload(Cancel As Integer) Frm_admin.Enabled = True End Sub Private Sub Timer1_Timer() Label4.Caption = Time Label3.Caption = Date End Sub Private Sub lihatdata() Dim rs As Recordset Set rs = New Recordset rs.Open "select * from program_studi", cn Set DataGrid1.DataSource = rs.DataSource aturgrid End Sub Private Sub aturgrid() With DataGrid1 .Columns(0).Caption = "Jurusan": .Columns(0).Width = 2000 .Columns(1).Caption = "Program Studi": .Columns(1).Width = 2500 .Columns(2).Caption = "Nomor SK Berdiri": .Columns(2).Width = 1500 .Columns(3).Caption = "Tanggal SK": .Columns(3).Width = 1500 .Columns(3).NumberFormat = "dd-mm-yyyy" End With End Sub Private Sub ambiljurusan() Dim rsjurusan As Recordset Set rsjurusan = New Recordset rsjurusan.Open "select * from jurusan", cn cmbjurusan.Clear For i = 1 To rsjurusan.RecordCount cmbjurusan.AddItem rsjurusan.Fields("jurusan") rsjurusan.MoveNext Next i End Sub Sub kunci() cmbjurusan.Enabled = False txtprodi.Enabled = False txtsk.Enabled = False DTPicker1.Enabled = False cmdsimpan.Enabled = False cmdhapus.Enabled = False cmdedit.Enabled = False cmdtambah.Enabled = True

Page 73: Sistem Informasi Akademik Dengan Vb

Programer by : Rudy Kurniawan 73

End Sub Sub bukakunci() cmbjurusan.Enabled = True txtprodi.Enabled = True txtsk.Enabled = True DTPicker1.Enabled = True cmdsimpan.Enabled = True End Sub Sub bersih() cmbjurusan.Text = "" txtprodi.Text = "" txtsk.Text = "" End Sub