vbÐÞ¸ÄDTPicker1ÈÕÆÚÎÊÌâ
Private Sub Check1_Click()
If Check1.Value = 1 Then
DTP1.Enabled = True
Else
DTP1.Enabled = False
End If
End Sub
Private Sub Check2_Click()
If Check2.Value = 1 Then
DTP2.Enabled = True
Else
DTP2.Enabled = False
End If
End Sub
Private Sub cmd_Click()
Set cn = New ADODB.Connection
Set res = New ADODB.Recordset
cn.Open "provider=SQLOLEDB;server=it;database=khgl1;uid=sa;pwd=123456"
res.CursorLocation = adUseClient
res.Open "select * from khgl", cn, adOpenStatic, adLockOptimistic
Set frm_xxxg.MSHFlexGrid1.DataSource = res
On Error Resume Next
If Check1.Value = 1 Then
res!À´µçʱ¼ä = DTP1.Value
res!È¥µçʱ¼ä = DTP2.Value
-----
res.Update
res.Close
MsgBox ("Ð޸ijɹ¦")
ÕâÊÇÎÒµÄÐ޸ĴúÂ룬ÐÞ¸ÄÈÕÆÚ,µ±´æÈëÈÕÆÚÖ®ºó£¬ÎÞ·¨Çå¿ÕÁË£¬Ö÷Òª²ÉÓà check¿Ø¼þ¿ØÖÆdtpicker£¬Ï£ÍûÔÚdtpicker¾Í³É»ÒÉ«£¬Ð޸ı£´æµÄʱºò²»´æÈëÈÕÆÚ£¡
ÄÇÔÚdtpicker²»ÄÜÓõÄʱºò¾Í²»Òª res!À´µçʱ¼ä = DTP1.Value ,ÅжÏÒ»ÏÂ
²»ÅжÏÖ»ÄÜÐÞ¸ÄÈÕÆÚ£¬ÎÞ·¨Çå¿Õ
dtpicker»¹ÓÐÒ»¸öCHECKBOXÊôÐÔ ¿ÉÒÔ½áºÏÓÃÒ»ÏÂ
checkboxÉèÖÃΪtrueÖ®ºó£¬°ÑdtpickerÉèÖÃΪnull£¬Ò²²»ÐÐ
À´µçʱ¼äºÍÀ´µçʱ¼äÔÚÊý¾Ý¿âÖÐÊÇʲôÀàÐÍ?×Ö·ûÐ
Ïà¹ØÎÊ´ð£º
ΪʲôCдµÄDLLÎļþC¡¢PBÄܵ÷ÓÃVB²»Äܵ÷Óã¿
VBÀïΪʲôÓеÄDLLÖ±½Óͨ¹ýÒýÓÿÉÒÔʹÓã¿ÓеÄÐèҪͨ¹ýdeclareÉêÃ÷Íⲿº¯Êý£¿ÕâЩDLLÓÐʲô²î±ð£¿
1¡¢ÎªÊ²Ã´PBÄÜͨ¹ýDECLAREÉùÃ÷¶øVB²»ÐУ¿
2¡¢Èç¹ûÕâ¸ödllÖÐµÄ ......
´ó¼ÒºÃ£¬Îʸövb´òÓ¡ÎÊÌâ
printer.print "dsff"
.....
....
Printer.EndDoc
´òÓ¡³É¹¦ºóÎÒ½«Ö´ÐÐ
sqlstr = "update vc_yh set pr=' ÒÑ´òÓ¡ ', ......
vbдµÄ³ÌÐò±àÒëºó,ÔËÐÐÈô³ö´í,ÈçºÎÖªµÀµ½ÔÚÄÄÒ»ÐÐ?
°´Ctrl+F5Ô¤±àÒ룬³ö´íʱ»áÌø×ªµ½´íÎóÐÐ
²»ÊÇÄÇÑùµÄÁË,ÎÒÊÇÒªÇó±àÒë³ÉEXEºóÔËÐÐ,Ìáʾ³ö´íÄÜ·ñÌáʾ´íÔÚÄÄÒ»ÐÐ.
ÎÒ±àÒëºóÔÚÎҵĵçÄÔÉÏÔËÐÐûÎÊÌâ,µ«Ô ......
Ë«ÖØËæ»ú Ôõôд ¾ÍÊÇËæ»ú³öÁËÒ»¸öÊý È»ºóÄÃÕâ¸öÊý×ù¿ªÍ·ÔÙËæ»úÒ»±é
±ÈÈç 1µ½10Ö®¼ä Ëæ»ú µÚÒ»´ÎÒÔ1¿ªÍ·10½áβ Ëæ»ú³öÒ»¸ö7 µÚ¶þ´Î¾ÍÊÇÒÔ7¿ªÍ·6½áβÔÙËæ»úÒ»±é
ÄÇλ¿ÉÒÔ°ï¸öæ ÏÈллÁË
6½áβ Õâ¸öʲ ......