tiap pagi cuma nongkrong mau kerja ga ada yang sesuai profesi
pusing2 ingin bebassssssssssssssssssssssssssssssssssssssssssssssssssssgila
gila pokoknya gila kerja berangkat pagi pulang pagi
kapan w bisa tidur sehari apakah cukup tidur 5 jam makan kurang juga
kapan w bisa bebas
pusing 2 pengen lepas
Dengan Perubahan zaman komputerisasi pun ikut berkembang dengan pesat sang ahli virus tak mau kalah ayo kita bantai sama2 viruss
Friday, April 23, 2010
Monday, April 12, 2010
Sunday, April 4, 2010
source vb delete no entry
Private Sub btFind_Click(Index As Integer)
Select Case Index
Case 0 '--- From Entry No. ----
F_EntryNo = 1
FindEntryNo.Show 1
Me.Text1.Text = E_Map_01
E_Map_01 = ""
Case 1 '--- To Entry No. ----
F_EntryNo = 1
FindEntryNo.Show 1
Me.Text2.Text = E_Map_01
E_Map_01 = ""
End Select
End Sub
Private Sub btFinish_Click()
Unload Me
End Sub
Private Sub btProses_Click()
On Error GoTo ErrorMSG
Select Case MsgBox("Do you want to delete the record's?", vbQuestion + vbYesNo, "Confirmation")
Case vbYes
Call SqlCONN
Me.MousePointer = 11
Me.pBAR.Value = 0
Me.pBAR.Visible = True
Me.btProses.Enabled = False
Call Me.Delete
Call SqlDisCONN
MsgBox "Records Delete...!!", vbInformation, "Accounting System"
Me.MousePointer = 0
Me.pBAR.Visible = False
Me.btFinish.Enabled = True
Call SqlDisCONN
Call CloseRS
Set rs1 = Nothing
Set Cmd = Nothing
Case vbNo
End Select
Exit Sub
ErrorMSG:
End Sub
Private Sub Timer1_Timer()
If Me.Label3.Visible = True Then
Me.Label3.Visible = False
Else
Me.Label3.Visible = True
End If
End Sub
Sub Delete()
strSQL = "SELECT NO_ENTRI FROM Table " & _
"WHERE NO_ENTRI >= '" & Me.Text1 & "' and NO_ENTRI <='" & Me.Text2 & "' "
Set rs = Conn.Execute(strSQL)
If rs.EOF = False Then
rs.MoveFirst
Do While rs.EOF = False
strSQL = "DELETE Table WHERE NO_ENTRI = '" & rs.Fields(0) & "' "
Conn.Execute (strSQL)
Me.pBAR.Value = rs.AbsolutePosition / rs.RecordCount * 100
rs.MoveNext
Loop
End If
End Sub
Select Case Index
Case 0 '--- From Entry No. ----
F_EntryNo = 1
FindEntryNo.Show 1
Me.Text1.Text = E_Map_01
E_Map_01 = ""
Case 1 '--- To Entry No. ----
F_EntryNo = 1
FindEntryNo.Show 1
Me.Text2.Text = E_Map_01
E_Map_01 = ""
End Select
End Sub
Private Sub btFinish_Click()
Unload Me
End Sub
Private Sub btProses_Click()
On Error GoTo ErrorMSG
Select Case MsgBox("Do you want to delete the record's?", vbQuestion + vbYesNo, "Confirmation")
Case vbYes
Call SqlCONN
Me.MousePointer = 11
Me.pBAR.Value = 0
Me.pBAR.Visible = True
Me.btProses.Enabled = False
Call Me.Delete
Call SqlDisCONN
MsgBox "Records Delete...!!", vbInformation, "Accounting System"
Me.MousePointer = 0
Me.pBAR.Visible = False
Me.btFinish.Enabled = True
Call SqlDisCONN
Call CloseRS
Set rs1 = Nothing
Set Cmd = Nothing
Case vbNo
End Select
Exit Sub
ErrorMSG:
End Sub
Private Sub Timer1_Timer()
If Me.Label3.Visible = True Then
Me.Label3.Visible = False
Else
Me.Label3.Visible = True
End If
End Sub
Sub Delete()
strSQL = "SELECT NO_ENTRI FROM Table " & _
"WHERE NO_ENTRI >= '" & Me.Text1 & "' and NO_ENTRI <='" & Me.Text2 & "' "
Set rs = Conn.Execute(strSQL)
If rs.EOF = False Then
rs.MoveFirst
Do While rs.EOF = False
strSQL = "DELETE Table WHERE NO_ENTRI = '" & rs.Fields(0) & "' "
Conn.Execute (strSQL)
Me.pBAR.Value = rs.AbsolutePosition / rs.RecordCount * 100
rs.MoveNext
Loop
End If
End Sub
Saturday, April 3, 2010
Subscribe to:
Posts (Atom)