vb 6 adodb - data pasien + penduduk

Januari 16th, 2010 [PROGRAM DATABASE PASIEN DAN PENDUDUK MENGGUNAKAN VISUAL BASIC]

===================== Menu Utama =====================

Private Sub Kalender_Click()BeepLoad Form4Form4.ShowEnd Sub

Private Sub Penduduk_Click()BeepForm1.Enabled = FalseLoad Form3Form3.ShowUnload Form1End Sub

Private Sub Pasien_Click()BeepForm1.Enabled = FalseLoad Form2Form2.ShowUnload Form1End Sub

Private Sub Keluar_Click()Beeppesan = MsgBox("Keluar dari aplikasi?", vbYesNo + vbQuestion, "Konfirmasi")

If pesan = vbYes ThenEndElseExit SubEnd IfEnd Sub

Private Sub Picture1_Click()If Timer2.Enabled = True Then Timer2.Enabled = FalseElseTimer2.Enabled = TrueEnd IfEnd Sub

Private Sub Timer1_Timer()If Timer1.Enabled ThenSelect Case (Format(Now, "mm")) Case "01" bulan_skr = "Januari" Case "02" bulan_skr = "Februari" Case "03" bulan_skr = "Maret" Case "04" bulan_skr = "April" Case "05" bulan_skr = "Mei" Case "06" bulan_skr = "Juni" Case "07" bulan_skr = "Juli" Case "08" bulan_skr = "Agustus" Case "09" bulan_skr = "September" Case "10" bulan_skr = "Oktober" Case "11" bulan_skr = "November" Case "12" bulan_skr = "Desember" End Select Select Case (Format(Now, "dddd")) Case "Sunday" hari_skr = "Ahad" Case "Monday" hari_skr = "Senin" Case "Tuesday" hari_skr = "Selasa" Case "Wednesday" hari_skr = "Rabu" Case "Thursday" hari_skr = "Kamis" Case "Friday"

Muhammad Furqan Q. Ts. (TI0801029) 1 | P a g e


hari_skr = "Jum'at" Case "Saturday" hari_skr = "Sabtu" End Select

Label20.Caption = Format(Now, "dd") & " " & _ (bulan_skr) & " " & _ Format(Now, "yyyy")

Label19.Caption = (hari_skr) & ", " & _Format(Now, "hh : mm : ss")

i = i + Format(Now, "ss")If i Mod 2 = 0 ThenLabel1.ForeColor = &H0&ElseLabel1.ForeColor = &HFFFF&End IfEnd IfEnd Sub

Private Sub Form_Load()Timer1.Enabled = True RestartTextPos Timer2.Enabled = TrueEnd Sub

Private Sub RestartTextPos() Text1.Top = Picture1.Top + Picture1.HeightEnd Sub

Private Sub Timer2_Timer() If (Text1.Top = Picture1.Top - Text1.Height - 1000) Then RestartTextPos End If Text1.Top = Text1.Top - 10End Sub

===================== Data Pasien =====================

Sub Tanggal_GotFocus()If TAMBAH.Enabled = True Then

pesan = MsgBox("Klick Tombol TAMBAH Untuk Mengisi Database", vbOKOnly + vbCritical, "Isikan Data")TAMBAH.SetFocusEnd IfEnd Sub

Sub Tanggal_LostFocus_Input()pesan = MsgBox("Input Tanggal Salah, Apakah Anda Ingin Memperbaikinya Lagi?", vbYesNo + vbQuestion, "Tanggal")If pesan = vbYes ThenDTPicker1.SetFocusDTPicker1.Text = ""ElseBATAL.SetFocusDTPicker1.Text = ""End IfEnd Sub

Sub Tanggal_LostFocus_Nilai()pesan = MsgBox("Nilai Tanggal Atau Bulan Tidak Memenuhi Standar, Apakah Anda Ingin Memperbaikinya Lagi?", vbYesNo + vbQuestion, "Standar Kalender")If pesan = vbYes ThenDTPicker1.SetFocusDTPicker1.Text = ""ElseBATAL.SetFocusDTPicker1.Text = ""End IfEnd Sub

Private Sub DTPicker1_GotFocus()Tanggal_GotFocusEnd Sub

Private Sub DTPicker2_GotFocus()Tanggal_GotFocusEnd Sub

Private Sub DTPicker1_LostFocus()If TAMBAH.Enabled = True ThenTAMBAH.SetFocusElse



If (Len(DTPicker1.Text) < 9) Or (Len(DTPicker1.Text) > 10) ThenTanggal_LostFocus_InputEnd IfEnd IfIf Format(DTPicker1.Text, "##/##/####") > Format(Date, "12/31/####") ThenTanggal_LostFocus_NilaiEnd IfEnd Sub

Private Sub DTPicker2_LostFocus()If TAMBAH.Enabled = True ThenTAMBAH.SetFocusElseIf (Len(DTPicker2.Text) < 9) Or (Len(DTPicker2.Text) > 10) ThenTanggal_LostFocus_NilaiEnd IfEnd IfIf Format(DTPicker2.Text, "##/##/####") > Format(Date, "12/31/####") ThenTanggal_LostFocus_NilaiEnd IfEnd Sub

Private Sub DTPicker1_KeyPress(keyascii As Integer)If Not ((keyascii >= Asc("0") And keyascii <= Asc("9")) Or keyascii = 18 Or keyascii = 8 Or keyascii = 13) Then keyascii = 0 pesan = MsgBox("Kolom Hanya Dapat Diisi Data Numerik", vbOKOnly + vbCritical, "Data Numerik") End IfIf keyascii = 13 ThenDTPicker1.Text = Format(DTPicker1.Text, "##/##/####")boxAgama.SetFocusEnd IfEnd Sub

Private Sub DTPicker2_KeyPress(keyascii As Integer)If Not ((keyascii >= Asc("0") And keyascii <= Asc("9")) Or keyascii = 18 Or keyascii = 8 Or keyascii = 13) Then keyascii = 0 pesan = MsgBox("Kolom Hanya Dapat Diisi Data Numerik", vbOKOnly + vbCritical, "Data Numerik") End If

If keyascii = 13 ThenDTPicker2.Text = Format(DTPicker2.Text, "##/##/####")txtFields(13).SetFocusEnd IfEnd Sub

Private Sub JK_KeyPress(keyascii As Integer)If keyascii = 13 ThentxtFields(5).SetFocusEnd IfEnd Sub

Private Sub boxAgama_KeyPress(keyascii As Integer)If keyascii = 13 ThentxtFields(6).SetFocusEnd IfEnd Sub

Private Sub SIMPAN_KeyPress(keyascii As Integer)If keyascii = 13 ThenTAMBAH.SetFocusEnd IfEnd Sub

Private Sub BATAL_KeyPress(keyascii As Integer)If keyascii = 13 ThenTAMBAH.SetFocusEnd IfEnd Sub

Private Sub txtFields_GotFocus(Index As Integer)If TAMBAH.Enabled = True Thenpesan = MsgBox("Klick Tombol TAMBAH Untuk Mengisi Database", vbOKOnly + vbCritical, "Isikan Data")TAMBAH.SetFocusEnd IfEnd Sub

Function TCase(s As String) As StringDim i As IntegerDim x, ss, b As String



i = 1 For i = 1 To Len(s) x = Mid(s, i, 1) If (x = " ") Then b = UCase(Mid(s, i + 1, 1)) ss = ss + x + b i = i + 1 Else ss = ss + x End If Next i TCase = UCase(Left(ss, 1)) + Right(ss, Len(ss) - 1)End Function

Private Sub txtFields_KeyPress(Index As Integer, keyascii As Integer)If keyascii = 13 ThenIf SIMPAN.Enabled = False ThenSIMPAN.Enabled = TrueEnd IfIf (Index < 2) Or ((Index > 5) And (Index < 9)) Or (Index = 11) Then txtFields(Index + 1).SetFocus Else If Index = 2 Then JK.SetFocus Else If Index = 5 Then DTPicker1.SetFocus Else If Index = 9 Then txtFields(11).SetFocus Else If Index = 12 Then DTPicker2.SetFocus Else SIMPAN.SetFocusEnd IfEnd IfEnd IfEnd IfEnd IfEnd If Select Case Index

Case 2, 5, 6, 7, 8, 9, 13 If keyascii = 13 Then txtFields(Index) = TCase(txtFields(Index)) End If Case 0, 1, 11, 12 If Not ((keyascii >= Asc("0") And keyascii <= Asc("9")) Or keyascii = 18 Or keyascii = 8 Or keyascii = 13) Then keyascii = 0 pesan = MsgBox("Kolom Hanya Dapat Diisi Data Numerik", vbOKOnly + vbCritical, "Data Numerik") End If End SelectEnd Sub

Private Sub RESET() txtFields(0).Text = "" txtFields(1).Text = "" txtFields(2).Text = "" JK = "" boxAgama.Text = "" txtFields(5).Text = "" txtFields(6).Text = "" txtFields(7).Text = "" txtFields(8).Text = "" txtFields(9).Text = "" txtFields(11).Text = "" txtFields(12).Text = "" txtFields(13).Text = "" DTPicker1.Text = "" DTPicker2.Text = ""End Sub

Private Sub Perintah_SIMPAN()With Data1.Recordset !No_Register = txtFields(0).Text !No_CM = txtFields(1).Text !Nama_Lengkap = txtFields(2).Text !Jenis_Kelamin = JK.Text !Agama = boxAgama.Text !Tempat_Lahir = txtFields(5).Text !Alamat = txtFields(6).Text !Kelurahan = txtFields(7).Text



!Kecamatan = txtFields(8).Text !Kota = txtFields(9).Text !Tgl_Masuk = DTPicker2.Text !Telp = txtFields(11).Text !HP = txtFields(12).Text !Kategori = txtFields(13).Text !Tanggal_Lahir = DTPicker1.Text .Update .Bookmark = Data1.Recordset.LastModifiedEnd WithEnd Sub

Private Sub TAMPILDATA()With Data1.Recordset If (.RecordCount = 0) Then Exit Sub End If txtFields(0).Text = .Fields!No_Register txtFields(1).Text = .Fields!No_CM txtFields(2).Text = .Fields!Nama_Lengkap JK.Text = .Fields!Jenis_Kelamin boxAgama.Text = .Fields!Agama txtFields(5).Text = .Fields!Tempat_Lahir txtFields(6).Text = .Fields!Alamat txtFields(7).Text = .Fields!Kelurahan txtFields(8).Text = .Fields!Kecamatan txtFields(9).Text = .Fields!Kota DTPicker2.Text = .Fields!Tgl_Masuk txtFields(11).Text = .Fields!Telp txtFields(12).Text = .Fields!HP txtFields(13).Text = .Fields!Kategori DTPicker1.Text = .Fields!Tanggal_LahirEnd WithEnd Sub

Private Sub EDIT_DATA() AWAL.Enabled = False AKHIR.Enabled = False SEBELUM.Enabled = False SETELAH.Enabled = False TAMBAH.Enabled = False HAPUS.Enabled = False

KOREKSI.Enabled = False KELUAR.Enabled = False BATAL.Enabled = True SIMPAN.Enabled = TrueEnd Sub

Private Sub NAVIGASI() If (txtFields(0).Text = "") Or (txtFields(1).Text = "") Or (txtFields(2).Text = "") Or (txtFields(5).Text = "") Or (txtFields(6).Text = "") Or (txtFields(7).Text = "") Or (txtFields(8).Text = "") Or (txtFields(9).Text = "") Or (txtFields(11).Text = "") Or (txtFields(12).Text = "") Or (txtFields(13).Text = "") Or (DTPicker1.Text = "") Or (DTPicker2.Text = "") Then pesan = MsgBox("Terdapat Field Kosong Pada Data Dalam Database,", vbOKOnly + vbCritical, "Kesalahan Saat Penyimpanan") KOREKSI_Click HAPUS.Enabled = True Else TAMPILDATA End IfEnd Sub

Private Sub AWAL_Click()If (txtFields(0).Text = "") Or (txtFields(1).Text = "") Or (txtFields(2).Text = "") Or (txtFields(5).Text = "") Or (txtFields(6).Text = "") Or (txtFields(7).Text = "") Or (txtFields(8).Text = "") Or (txtFields(9).Text = "") Or (txtFields(11).Text = "") Or (txtFields(12).Text = "") Or (txtFields(13).Text = "") Or (DTPicker1.Text = "") Or (DTPicker2.Text = "") ThenData1.RefreshElseWith Data1.Recordset If .RecordCount <= 1 Then Exit Sub End If .MoveFirst NAVIGASIEnd WithEnd IfEnd Sub

Private Sub AKHIR_Click()If (txtFields(0).Text = "") Or (txtFields(1).Text = "") Or (txtFields(2).Text = "") Or (txtFields(5).Text = "") Or (txtFields(6).Text = "") Or (txtFields(7).Text = "") Or (txtFields(8).Text = "") Or (txtFields(9).Text = "") Or (txtFields(11).Text = "") Or (txtFields(12).Text = "") Or (txtFields(13).Text = "") Or (DTPicker1.Text = "") Or (DTPicker2.Text = "") Then



Data1.RefreshElseWith Data1.Recordset If .RecordCount <= 1 Then Exit Sub End If .MoveLast NAVIGASIEnd WithEnd IfEnd Sub

Private Sub SEBELUM_Click()If (txtFields(0).Text = "") Or (txtFields(1).Text = "") Or (txtFields(2).Text = "") Or (txtFields(5).Text = "") Or (txtFields(6).Text = "") Or (txtFields(7).Text = "") Or (txtFields(8).Text = "") Or (txtFields(9).Text = "") Or (txtFields(11).Text = "") Or (txtFields(12).Text = "") Or (txtFields(13).Text = "") Or (DTPicker1.Text = "") Or (DTPicker2.Text = "") ThenData1.RefreshElseWith Data1.Recordset If .RecordCount <= 1 Then Exit Sub End If .MovePrevious If .BOF Then .MoveLast End If NAVIGASIEnd WithEnd IfEnd Sub

Private Sub SETELAH_Click()If (txtFields(0).Text = "") Or (txtFields(1).Text = "") Or (txtFields(2).Text = "") Or (txtFields(5).Text = "") Or (txtFields(6).Text = "") Or (txtFields(7).Text = "") Or (txtFields(8).Text = "") Or (txtFields(9).Text = "") Or (txtFields(11).Text = "") Or (txtFields(12).Text = "") Or (txtFields(13).Text = "") Or (DTPicker1.Text = "") Or (DTPicker2.Text = "") ThenData1.RefreshElseWith Data1.Recordset If .RecordCount <= 1 Then Exit Sub

End If .MoveNext If .EOF Then .MoveFirst End If NAVIGASIEnd WithEnd IfEnd Sub

Private Sub TAMBAH_Click()If (txtFields(0).Text <> "") Or (txtFields(1).Text <> "") Or (txtFields(2).Text <> "") Or (txtFields(5).Text <> "") Or (txtFields(6).Text <> "") Or (txtFields(7).Text <> "") Or (txtFields(8).Text <> "") Or (txtFields(9).Text <> "") Or (txtFields(11).Text <> "") Or (txtFields(12).Text <> "") Or (txtFields(13).Text <> "") Or (DTPicker1.Text <> "") Or (DTPicker2.Text <> "") Thenpesan = MsgBox("Input Data Telah Terisi, Coba Ulangi Tekan Tombol TAMBAH", vbOKOnly + vbCritical, "Isikan Data")RESETElseData1.RefreshData1.Recordset.AddNewtxtFields(0).SetFocusEDIT_DATAEnd IfEnd Sub

Private Sub KOREKSI_Click()If (txtFields(0).Text = "") Thenpesan = MsgBox("Pilih Data Yang Akan Dikoreksi", vbOKOnly + vbCritical, "Pilih Data")Else Data1.Recordset.Edit txtFields(0).Enabled = False txtFields(1).SetFocusEDIT_DATAEnd IfEnd Sub

Private Sub HAPUS_Click()BATAL_ClickIf Data1.Recordset.BOF = False Then pesan = MsgBox("Apakah Anda Yakin Untuk Menghapus Data?", vbYesNo + vbExclamation, "Penghapusan Data")



If pesan = vbYes Then Data1.Recordset.Delete Data1.Recordset.MoveNext End IfElseIf Data1.Recordset.BOF = True Then pesan = MsgBox("Database Dalam Keadaan Kosong", vbOKOnly + vbCritical, "Database Kosong") End IfEnd IfData1.RefreshEnd Sub

Private Sub BATAL_Click()RESETtxtFields(0).Enabled = TrueAWAL.Enabled = TrueAKHIR.Enabled = TrueSEBELUM.Enabled = TrueSETELAH.Enabled = TrueTAMBAH.Enabled = TrueHAPUS.Enabled = TrueKOREKSI.Enabled = TrueKELUAR.Enabled = TrueBATAL.Enabled = FalseSIMPAN.Enabled = FalseEnd Sub

Private Sub SIMPAN_Click()If (txtFields(0).Text = "") Or (txtFields(1).Text = "") Or (txtFields(2).Text = "") Or (txtFields(5).Text = "") Or (txtFields(6).Text = "") Or (txtFields(7).Text = "") Or (txtFields(8).Text = "") Or (txtFields(9).Text = "") Or (txtFields(11).Text = "") Or (txtFields(12).Text = "") Or (txtFields(13).Text = "") Or (DTPicker1.Text = "") Or (DTPicker2.Text = "") Thenpesan = MsgBox("Input Data Belum Lengkap", vbOKOnly + vbCritical, "Isikan Data")If pesan = vbOK ThenIf txtFields(0).Enabled = False ThentxtFields(1).SetFocusElsetxtFields(0).SetFocusEnd IfEnd IfElse

Perintah_SIMPANBATAL_ClickTAMPILDATAEnd IfEnd Sub

Private Sub Keluar_Click()Beeppesan = MsgBox("Kembali Ke Menu Utama?", vbYesNo + vbQuestion, "Konfirmasi")If pesan = vbYes ThenForm1.Enabled = TrueLoad Form1Form1.ShowUnload MeMe.HideClose FormElseExit SubEnd IfEnd Sub

Private Sub Form_Load()Timer1.Enabled = TrueBATAL.Enabled = FalseSIMPAN.Enabled = FalseEnd Sub

Private Sub Timer1_Timer()If Timer1.Enabled ThenSelect Case (Format(Now, "mm")) Case "01" bulan_skr = "Januari" Case "02" bulan_skr = "Februari" Case "03" bulan_skr = "Maret" Case "04" bulan_skr = "April" Case "05" bulan_skr = "Mei" Case "06" bulan_skr = "Juni"



Case "07" bulan_skr = "Juli" Case "08" bulan_skr = "Agustus" Case "09" bulan_skr = "September" Case "10" bulan_skr = "Oktober" Case "11" bulan_skr = "November" Case "12" bulan_skr = "Desember" End Select Select Case (Format(Now, "dddd")) Case "Sunday" hari_skr = "Ahad" If hari_skr = "" Then hari_skr = Format(Now, "dddd") End If Case "Monday" hari_skr = "Senin" If hari_skr = "" Then hari_skr = Format(Now, "dddd") End If Case "Tuesday" hari_skr = "Selasa" If hari_skr = "" Then hari_skr = Format(Now, "dddd") End If Case "Wednesday" hari_skr = "Rabu" If hari_skr = "" Then hari_skr = Format(Now, "dddd") End If Case "Thursday" hari_skr = "Kamis" If hari_skr = "" Then hari_skr = Format(Now, "dddd") End If Case "Friday" hari_skr = "Jum'at"

If hari_skr = "" Then hari_skr = Format(Now, "dddd") End If Case "Saturday" hari_skr = "Sabtu" If hari_skr = "" Then hari_skr = Format(Now, "dddd") End If End Select



i = i + Format(Now, "ss")If i Mod 2 = 0 ThenlblLabels(15).ForeColor = &H0&lblLabels(16).ForeColor = &H0&ElselblLabels(15).ForeColor = &HFFFFFFlblLabels(16).ForeColor = &HFFFFFFEnd IfEnd IfEnd Sub

==================== Data Penduduk ====================

Private Sub DTPicker1_GotFocus()If TAMBAH.Enabled = True Thenpesan = MsgBox("Klick Tombol TAMBAH Untuk Mengisi Database", vbOKOnly + vbCritical, "Isikan Data")TAMBAH.SetFocusEnd IfEnd Sub

Private Sub DTPicker1_LostFocus()If TAMBAH.Enabled = True ThenTAMBAH.SetFocusElse



If (Len(DTPicker1.Text) < 9) Or (Len(DTPicker1.Text) > 10) Thenpesan = MsgBox("Input Tanggal Salah, Apakah Anda Ingin Memperbaikinya Lagi?", vbYesNo + vbQuestion, "Tanggal")If pesan = vbYes ThenDTPicker1.SetFocusDTPicker1.Text = ""ElseBATAL.SetFocusDTPicker1.Text = ""End IfEnd IfEnd IfIf Format(DTPicker1.Text, "##/##/####") > Format(Date, "12/31/####") Thenpesan = MsgBox("Nilai Tanggal Atau Bulan Tidak Memenuhi Standar, Apakah Anda Ingin Memperbaikinya Lagi?", vbYesNo + vbQuestion, "Standar Kalender")If pesan = vbYes ThenDTPicker1.SetFocusDTPicker1.Text = ""ElseBATAL.SetFocusDTPicker1.Text = ""End IfEnd IfEnd Sub

Private Sub DTPicker1_KeyPress(keyascii As Integer)If Not ((keyascii >= Asc("0") And keyascii <= Asc("9")) Or keyascii = 18 Or keyascii = 8 Or keyascii = 13) Then keyascii = 0 pesan = MsgBox("Kolom Hanya Dapat Diisi Data Numerik", vbOKOnly + vbCritical, "Data Numerik") End IfIf keyascii = 13 ThenDTPicker1.Text = Format(DTPicker1.Text, "##/##/####")txtFields(5).SetFocusEnd IfEnd Sub

Private Sub JenisKelamin_KeyPress(keyascii As Integer)If keyascii = 13 ThenDTPicker1.SetFocusEnd If

End Sub

Private Sub Pendidikan_KeyPress(keyascii As Integer)If keyascii = 13 ThentxtFields(7).SetFocusEnd IfEnd Sub

Private Sub boxAgama_KeyPress(keyascii As Integer)If keyascii = 13 ThenPendidikan.SetFocusEnd IfEnd Sub

Private Sub GD_KeyPress(keyascii As Integer)If keyascii = 13 ThenboxAgama.SetFocusEnd IfEnd Sub

Private Sub SIMPAN_KeyPress(keyascii As Integer)If keyascii = 13 ThenTAMBAH.SetFocusEnd IfEnd Sub

Private Sub BATAL_KeyPress(keyascii As Integer)If keyascii = 13 ThenTAMBAH.SetFocusEnd IfEnd Sub

Private Sub Pernikahan_KeyPress(keyascii As Integer)If keyascii = 13 ThentxtFields(6).SetFocusEnd IfEnd Sub

Private Sub WN_KeyPress(keyascii As Integer)If keyascii = 13 ThenSIMPAN.SetFocusEnd If



End Sub

Private Sub txtFields_GotFocus(Index As Integer)If TAMBAH.Enabled = True Thenpesan = MsgBox("Klick Tombol TAMBAH Untuk Mengisi Database", vbOKOnly + vbCritical, "Isikan Data")TAMBAH.SetFocusEnd IfEnd Sub

Function TCase(s As String) As StringDim i As IntegerDim x, ss, b As String i = 1 For i = 1 To Len(s) x = Mid(s, i, 1) If (x = " ") Then b = UCase(Mid(s, i + 1, 1)) ss = ss + x + b i = i + 1 Else ss = ss + x End If Next i TCase = UCase(Left(ss, 1)) + Right(ss, Len(ss) - 1)End Function

Private Sub txtFields_KeyPress(Index As Integer, keyascii As Integer)If keyascii = 13 ThenIf SIMPAN.Enabled = False ThenSIMPAN.Enabled = TrueEnd IfIf ((Index >= 0) And (Index < 2)) Or ((Index > 6) And (Index < 13)) Then txtFields(Index + 1).SetFocus Else If Index = 2 Then JenisKelamin.SetFocus Else If Index = 5 Then Pernikahan.SetFocus Else If Index = 6 Then

GD.SetFocus Else If Index = 13 Then WN.SetFocus Else SIMPAN.SetFocusEnd IfEnd IfEnd IfEnd IfEnd IfEnd If Select Case Index Case 2, 5, 6, 7, 10, 11, 13 If keyascii = 13 Then txtFields(Index) = TCase(txtFields(Index)) End If Case 0, 1, 8, 9, 12 If Not ((keyascii >= Asc("0") And keyascii <= Asc("9")) Or keyascii = 18 Or keyascii = 8 Or keyascii = 13) Then keyascii = 0 pesan = MsgBox("Kolom Hanya Dapat Diisi Data Numerik", vbOKOnly + vbCritical, "Data Numerik") End If End SelectEnd Sub

Private Sub RESET() txtFields(0).Text = "" txtFields(1).Text = "" txtFields(2).Text = "" txtFields(5).Text = "" txtFields(6).Text = "" txtFields(7).Text = "" txtFields(8).Text = "" txtFields(9).Text = "" txtFields(10).Text = "" txtFields(11).Text = "" txtFields(12).Text = "" txtFields(13).Text = "" Pernikahan.Text = "" WN.Text = ""



GD.Text = "" DTPicker1.Text = "" JenisKelamin.Text = "" boxAgama.Text = "" Pendidikan.Text = ""End Sub

Private Sub Perintah_SIMPAN()With Data1.Recordset !KTP = txtFields(0).Text !Nik = txtFields(1).Text !Nama = txtFields(2).Text !Tmp_Lahir = txtFields(5).Text !Kerja = txtFields(6).Text !Alamat = txtFields(7).Text !RT = txtFields(8).Text !RW = txtFields(9).Text !Kel = txtFields(10).Text !Kec = txtFields(11).Text !KdPos = txtFields(12).Text !Kab = txtFields(13).Text !SK = Pernikahan.Text !WN = WN.Text !GD = GD.Text !Tgl_Lahir = DTPicker1.Text !JK = JenisKelamin.Text !Agama = boxAgama.Text !Pendidikan = Pendidikan.Text .Update .Bookmark = Data1.Recordset.LastModifiedEnd WithEnd Sub

Private Sub TAMPILDATA()With Data1.Recordset If (.RecordCount = 0) Then Exit Sub End If txtFields(0).Text = .Fields!KTP txtFields(1).Text = .Fields!Nik txtFields(2).Text = .Fields!Nama txtFields(5).Text = .Fields!Tmp_Lahir

txtFields(6).Text = .Fields!Kerja txtFields(7).Text = .Fields!Alamat txtFields(8).Text = .Fields!RT txtFields(9).Text = .Fields!RW txtFields(10).Text = .Fields!Kel txtFields(11).Text = .Fields!Kec txtFields(12).Text = .Fields!KdPos txtFields(13).Text = .Fields!Kab Pernikahan.Text = .Fields!SK WN.Text = .Fields!WN GD.Text = .Fields!GD DTPicker1.Text = .Fields!Tgl_Lahir JenisKelamin.Text = .Fields!JK boxAgama.Text = .Fields!Agama Pendidikan.Text = .Fields!PendidikanEnd WithEnd Sub

Private Sub NAVIGASI() If (txtFields(0).Text = "") Or (txtFields(1).Text = "") Or (txtFields(2).Text = "") Or (txtFields(5).Text = "") Or (txtFields(6).Text = "") Or (txtFields(7).Text = "") Or (txtFields(8).Text = "") Or (txtFields(9).Text = "") Or (txtFields(10).Text = "") Or (txtFields(11).Text = "") Or (txtFields(12).Text = "") Or (txtFields(13).Text = "") Or (DTPicker1.Text = "") Then pesan = MsgBox("Terdapat Field Kosong Pada Data Dalam Database,", vbOKOnly + vbCritical, "Kesalahan Saat Penyimpanan") KOREKSI_Click HAPUS.Enabled = True Else TAMPILDATA End IfEnd Sub

Private Sub EDIT_DATA() AWAL.Enabled = False AKHIR.Enabled = False SEBELUM.Enabled = False SETELAH.Enabled = False TAMBAH.Enabled = False HAPUS.Enabled = False KOREKSI.Enabled = False KELUAR.Enabled = False BATAL.Enabled = True



SIMPAN.Enabled = TrueEnd Sub

Private Sub AWAL_Click()If (txtFields(0).Text = "") Or (txtFields(1).Text = "") Or (txtFields(2).Text = "") Or (txtFields(5).Text = "") Or (txtFields(6).Text = "") Or (txtFields(7).Text = "") Or (txtFields(8).Text = "") Or (txtFields(9).Text = "") Or (txtFields(10).Text = "") Or (txtFields(11).Text = "") Or (txtFields(12).Text = "") Or (txtFields(13).Text = "") Or (DTPicker1.Text = "") ThenData1.RefreshElseWith Data1.Recordset If .RecordCount <= 1 Then Exit Sub End If .MoveFirst NAVIGASIEnd WithEnd IfEnd Sub

Private Sub AKHIR_Click()If (txtFields(0).Text = "") Or (txtFields(1).Text = "") Or (txtFields(2).Text = "") Or (txtFields(5).Text = "") Or (txtFields(6).Text = "") Or (txtFields(7).Text = "") Or (txtFields(8).Text = "") Or (txtFields(9).Text = "") Or (txtFields(10).Text = "") Or (txtFields(11).Text = "") Or (txtFields(12).Text = "") Or (txtFields(13).Text = "") Or (DTPicker1.Text = "") ThenData1.RefreshElseWith Data1.Recordset If .RecordCount <= 1 Then Exit Sub End If .MoveLast NAVIGASIEnd WithEnd IfEnd Sub

Private Sub SEBELUM_Click()If (txtFields(0).Text = "") Or (txtFields(1).Text = "") Or (txtFields(2).Text = "") Or (txtFields(5).Text = "") Or (txtFields(6).Text = "") Or (txtFields(7).Text = "") Or (txtFields(8).Text = "") Or (txtFields(9).Text = "") Or (txtFields(10).Text = "") Or (txtFields(11).Text = "") Or (txtFields(12).Text = "") Or (txtFields(13).Text = "") Or (DTPicker1.Text = "") Then

Data1.RefreshElseWith Data1.Recordset If .RecordCount <= 1 Then Exit Sub End If .MovePrevious If .BOF Then .MoveLast End If NAVIGASIEnd WithEnd IfEnd Sub

Private Sub SETELAH_Click()If (txtFields(0).Text = "") Or (txtFields(1).Text = "") Or (txtFields(2).Text = "") Or (txtFields(5).Text = "") Or (txtFields(6).Text = "") Or (txtFields(7).Text = "") Or (txtFields(8).Text = "") Or (txtFields(9).Text = "") Or (txtFields(10).Text = "") Or (txtFields(11).Text = "") Or (txtFields(12).Text = "") Or (txtFields(13).Text = "") Or (DTPicker1.Text = "") ThenData1.RefreshElseWith Data1.Recordset If .RecordCount <= 1 Then Exit Sub End If .MoveNext If .EOF Then .MoveFirst End If NAVIGASIEnd WithEnd IfEnd Sub

Private Sub TAMBAH_Click()If (txtFields(0).Text <> "") Or (txtFields(1).Text <> "") Or (txtFields(2).Text <> "") Or (txtFields(5).Text <> "") Or (txtFields(6).Text <> "") Or (txtFields(7).Text <> "") Or (txtFields(8).Text <> "") Or (txtFields(9).Text <> "") Or (txtFields(10).Text <> "") Or (txtFields(11).Text <> "") Or (txtFields(12).Text <> "") Or (txtFields(13).Text <> "") Or (DTPicker1.Text <> "") Thenpesan = MsgBox("Input Data Telah Terisi, Coba Ulangi Tekan Tombol TAMBAH", vbOKOnly + vbCritical, "Isikan Data")



RESETElseData1.RefreshData1.Recordset.AddNewtxtFields(0).SetFocusEDIT_DATAEnd IfEnd Sub

Private Sub KOREKSI_Click()If (txtFields(0).Text = "") Thenpesan = MsgBox("Pilih Data Yang Akan Dikoreksi", vbOKOnly + vbCritical, "Pilih Data")Else Data1.Recordset.Edit txtFields(0).Enabled = False txtFields(1).SetFocusEDIT_DATAEnd IfEnd Sub

Private Sub HAPUS_Click()BATAL_ClickIf Data1.Recordset.BOF = False Then pesan = MsgBox("Apakah Anda Yakin Untuk Menghapus Data?", vbYesNo + vbExclamation, "Penghapusan Data") If pesan = vbYes Then Data1.Recordset.Delete Data1.Recordset.MoveNext End IfElseIf Data1.Recordset.BOF = True Then pesan = MsgBox("Database Dalam Keadaan Kosong", vbOKOnly + vbCritical, "Database Kosong") End IfEnd IfData1.RefreshEnd Sub

Private Sub BATAL_Click()RESETtxtFields(0).Enabled = TrueAWAL.Enabled = True

AKHIR.Enabled = TrueSEBELUM.Enabled = TrueSETELAH.Enabled = TrueTAMBAH.Enabled = TrueHAPUS.Enabled = TrueKOREKSI.Enabled = TrueKELUAR.Enabled = TrueBATAL.Enabled = FalseSIMPAN.Enabled = FalseEnd Sub

Private Sub SIMPAN_Click()If (txtFields(0).Text = "") Or (txtFields(1).Text = "") Or (txtFields(2).Text = "") Or (txtFields(5).Text = "") Or (txtFields(6).Text = "") Or (txtFields(7).Text = "") Or (txtFields(8).Text = "") Or (txtFields(9).Text = "") Or (txtFields(10).Text = "") Or (txtFields(11).Text = "") Or (txtFields(12).Text = "") Or (txtFields(13).Text = "") Or (DTPicker1.Text = "") Thenpesan = MsgBox("Input Data Belum Lengkap", vbOKOnly + vbCritical, "Isikan Data")If pesan = vbOK ThenIf txtFields(0).Enabled = False ThentxtFields(1).SetFocusElsetxtFields(0).SetFocusEnd IfEnd IfElsePerintah_SIMPANBATAL_ClickTAMPILDATAEnd IfEnd Sub

Private Sub Keluar_Click()Beeppesan = MsgBox("Kembali Ke Menu Utama?", vbYesNo + vbQuestion, "Konfirmasi")If pesan = vbYes ThenForm1.Enabled = TrueLoad Form1Form1.ShowUnload MeMe.HideClose FormElse



Exit SubEnd IfEnd Sub

Private Sub Form_Load()Timer1.Enabled = TrueBATAL.Enabled = FalseSIMPAN.Enabled = FalseEnd Sub

Private Sub Timer1_Timer()If Timer1.Enabled ThenSelect Case (Format(Now, "mm")) Case "01" bulan_skr = "Januari" Case "02" bulan_skr = "Februari" Case "03" bulan_skr = "Maret" Case "04" bulan_skr = "April" Case "05" bulan_skr = "Mei" Case "06" bulan_skr = "Juni" Case "07" bulan_skr = "Juli" Case "08" bulan_skr = "Agustus" Case "09" bulan_skr = "September" Case "10" bulan_skr = "Oktober" Case "11" bulan_skr = "November" Case "12" bulan_skr = "Desember" End Select Select Case (Format(Now, "dddd")) Case "Sunday" hari_skr = "Ahad"

If hari_skr = "" Then hari_skr = Format(Now, "dddd") End If Case "Monday" hari_skr = "Senin" If hari_skr = "" Then hari_skr = Format(Now, "dddd") End If Case "Tuesday" hari_skr = "Selasa" If hari_skr = "" Then hari_skr = Format(Now, "dddd") End If Case "Wednesday" hari_skr = "Rabu" If hari_skr = "" Then hari_skr = Format(Now, "dddd") End If Case "Thursday" hari_skr = "Kamis" If hari_skr = "" Then hari_skr = Format(Now, "dddd") End If Case "Friday" hari_skr = "Jum'at" If hari_skr = "" Then hari_skr = Format(Now, "dddd") End If Case "Saturday" hari_skr = "Sabtu" If hari_skr = "" Then hari_skr = Format(Now, "dddd") End If End Select





i = i + Format(Now, "ss")If i Mod 2 = 0 ThenlblLabels(11).ForeColor = &H0&

ElselblLabels(11).ForeColor = &HFFFFFF

End IfEnd IfEnd Sub

====================== Kalender ======================

Option ExplicitDim hari As LongDim i As Integer

Private Sub Form_Load()Timer1.Enabled = Truebulan.Text = Format(Now, "m")tahun.Text = Format(Now, "yyyy")If bulan.Text = "01" ThenBLN_KURANG.Enabled = FalseEnd IfIf bulan.Text = "12" ThenBLN_TAMBAH.Enabled = FalseEnd Iflihat_ClickEnd Sub

Private Sub BLN_KURANG_Click()bulan.Text = bulan.Text - 1If bulan.Text = "1" ThenBLN_KURANG.Enabled = FalseEnd IfBLN_TAMBAH.Enabled = TrueEnd Sub

Private Sub BLN_TAMBAH_Click()bulan.Text = bulan.Text + 1If bulan.Text = "12" ThenBLN_TAMBAH.Enabled = False

End IfBLN_KURANG.Enabled = TrueEnd Sub

Private Sub THN_KURANG_Click()tahun.Text = tahun.Text - 1If tahun.Text = "1900" ThenTHN_KURANG.Enabled = FalseEnd IfTHN_TAMBAH.Enabled = TrueEnd Sub

Private Sub THN_TAMBAH_Click()tahun.Text = tahun.Text + 1If tahun.Text = "2099" ThenTHN_TAMBAH.Enabled = FalseEnd IfTHN_KURANG.Enabled = TrueEnd Sub

Private Sub Keluar_Click()BeepUnload MeMe.HideEnd Sub

Private Sub lihat_Click()hari = 0For i = 0 To 34 nomor(i).Caption = ""Next i

For i = 1900 To tahun.Text - 1 If i Mod 4 = 0 Then hari = hari + 366 Else hari = hari + 365 End IfNext i

For i = 1 To bulan.Text - 1 If i = 1 Or i = 3 Or i = 5 Or i = 7 Or i = 8 Or i = 10 Or i = 12 Then



hari = hari + 31 ElseIf (i = 4 Or i = 6 Or i = 9 Or i = 11) Then hari = hari + 30 ElseIf (i = 2 And tahun.Text Mod 4 = 0) Then hari = hari + 29 Else hari = hari + 28 End If Next i If (i = 1 Or i = 3 Or i = 5 Or i = 7 Or i = 8 Or i = 10 Or i = 12) Then Kalender 31

ElseIf (i = 4 Or i = 6 Or i = 9 Or i = 11) Then Kalender 30

ElseIf (i = 2 And tahun.Text Mod 4 = 0) Then Kalender 29 Else Kalender 28 End If

Select Case bulan.Text Case 1 wkt_kalender = "Bulan : Januari" & " @ Tahun : " & _ (tahun.Text) Case 2 wkt_kalender = "Bulan : Februari" & " @ Tahun : " & _ (tahun.Text) Case 3 wkt_kalender = "Bulan : Maret" & " @ Tahun : " & _ (tahun.Text) Case 4 wkt_kalender = "Bulan : April" & " @ Tahun : " & _ (tahun.Text) Case 5 wkt_kalender = "Bulan : Mei" & " @ Tahun : " & _ (tahun.Text) Case 6 wkt_kalender = "Bulan : Juni" & " @ Tahun : " & _ (tahun.Text) Case 7 wkt_kalender = "Bulan : Juli" & " @ Tahun : " & _

(tahun.Text) Case 8 wkt_kalender = "Bulan : Agustus" & " @ Tahun : " & _ (tahun.Text) Case 9 wkt_kalender = "Bulan : September" & " @ Tahun : " & _ (tahun.Text) Case 10 wkt_kalender = "Bulan : Oktober" & " @ Tahun : " & _ (tahun.Text) Case 11 wkt_kalender = "Bulan : November" & " @ Tahun : " & _ (tahun.Text) Case 12 wkt_kalender = "Bulan : Desember" & " @ Tahun : " & _ (tahun.Text) End SelectEnd Sub

Private Function Kalender(n As Integer)Dim i, k As Integerk = hari Mod 7For i = 1 To n nomor(k).Caption = i k = k + 1 If k = 35 Then k = 0Next iEnd Function

Private Sub Timer1_Timer()If Timer1.Enabled Thentgl_skr.Text = Format(Now, "dd")bulan_skr.Text = Format(Now, "mm")Select Case bulan_skr.Text Case "01" bulan_skr = "Januari" Case "02" bulan_skr = "Februari" Case "03" bulan_skr = "Maret" Case "04" bulan_skr = "April"



Case "05" bulan_skr = "Mei" Case "06" bulan_skr = "Juni" Case "07" bulan_skr = "Juli" Case "08" bulan_skr = "Agustus" Case "09" bulan_skr = "September" Case "10" bulan_skr = "Oktober" Case "11" bulan_skr = "November" Case "12" bulan_skr = "Desember" End Selecttahun_skr.Text = Format(Now, "yyyy")hari_jam.Text = Format(Now, "hh : mm : ss")If wkt_kalender <> "" Theni = i + 1If i Mod 2 = 0 Thenwkt_kalender.BackColor = &HFFFF&ElseIf i Mod 3 = 0 Thenwkt_kalender.BackColor = &HFFFFC0Elsewkt_kalender.BackColor = &HFFC0FFEnd IfEnd IfEnd IfEnd IfEnd Sub

Private Sub Atas_Click() Dim rc As RECT GetWindowRect Me.hwnd, rc If (Atas.Value = 1) Then SetWindowPos Me.hwnd, HWND_TOPMOST, rc.Left, rc.Top, 0, 0, SWP_NOSIZE Else SetWindowPos Me.hwnd, HWND_NOTOPMOST, rc.Left, rc.Top, 0, 0, SWP_NOSIZE End If

End Sub

==================== Module Kalender ====================

Public Type RECT Left As Long Top As Long Right As Long Bottom As LongEnd Type

Public Const HWND_TOPMOST = -1Public Const HWND_NOTOPMOST = -2Public Const SWP_NOSIZE = &H1

Public Declare Function SetWindowPos Lib "user32" (ByVal hwnd As Long, ByVal hWndInsertAfter As Long, ByVal x As Long, ByVal y As Long, ByVal cx As Long, ByVal cy As Long, ByVal wFlags As Long) As LongPublic Declare Function GetWindowRect Lib "user32" (ByVal hwnd As Long, lpRect As RECT) As Long


vb 6 adodb - data pasien + penduduk

Documents