VB-數據刪³ý處Àí
Private Sub Command1_Click(Index As Integer)
Select Case Index
Case 3 ¡¯刪³ý
Dim YesNo As String
If Command1(Index).Caption = "刪³ý(&D)" Then
YesNo = MsgBox("ÄúÒª刪³ý" + CStr(Mb.Text) + "µÄ組裝ÅÅÅä記錄嗎?", vbYesNo + vbCritical, "¾¯¸æ")
If YesNo = vbNo Then Exit Sub
cnn.Execute ("DELETE from DGMOCPPT WHERE convert(char(10),PS002,121)='" & Trim(Format(Mb.Text, "yyyy-mm-dd")) & "' ")
RsVWPZ.Requery
ElseIf Command1(Index).Caption = "·Å棄(&Q)" Then
If RsVWPZ.RecordCount = 0 Then ClearRs 1 '當沒ÓÐ記錄´æÔÚµÄÇé況ÏÂÇå¿Õ顯ʾ
EditCmd 2
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬Îʸövb´òÓ¡ÎÊÌâ
printer.print "dsff"
.....
....
Printer.EndDoc
´òÓ¡³É¹¦ºóÎÒ½«Ö´ÐÐ
sqlstr = "update vc_yh set pr=' ÒÑ´òÓ¡ ', ......
±ÈÈç½ø³Ì¼ÓÔØÐµijÌÐò¡£
ÔÚÆäÔËÐÐ֮ǰ×èÖ¹¡£
È»ºóÔÊÐíºó·ÅÐС£
±ÈÈç³ÌÐòÖ÷Îļþ·¾¶ÊÇc:\test\test.exe£¬½¨Á¢ÄÚÈÝÈÎÒâµÄÎļþc:\test\test.exe.manifest¡£
¾ÍÊDz»ÖªµÀ³ÌÐòÎļþ·¾¶¡£
ÉèÖ ......
´ó¼Ò¿´¿´
http://topic.csdn.net/u/20091005/16/aa0a010f-1428-4eef-9886-684039e382f7.html?93089
http://topic.csdn.net/u/20091005/16/aa0a010f-1428-4eef-9886-684039e382f7.html?93089
µ°¶¨
http://t ......
Private Sub fun()
Static a As Integer
A=a+1
Print a;
End Sub
Private Sub Command1_Click()
Dim m As Integer
&n ......