ÎÒÐèҪͨ¹ýµ¥¸ö²éѯÌõ¼þ°´ÄêÔÂ,²éѯµ½accessÊý¾Ý¿âÀïµÄÊý¾ÝΪ (ÈÕÆÚÀàÐÍ2008-02-02)
Dim DDTP1 As String
Dim date1 As Date = DTP1.Value
DDTP1 = Format(date1, "#yyyy-MM#" ......
ÎÒÐèҪͨ¹ýµ¥¸ö²éѯÌõ¼þ°´ÄêÔÂ,²éѯµ½accessÊý¾Ý¿âÀïµÄÊý¾ÝΪ (ÈÕÆÚÀàÐÍ2008-02-02)
Dim DDTP1 As String
Dim date1 As Date = DTP1.Value
DDTP1 = Format(date1, "#yyyy-MM#" ......
½öÊÇÒ»¶Î¸üÐÂÃÜÂëµÄ´úÂëÈçÏ¡£±¨´íÐÅϢΪ£º
δ´¦ÀíµÄ¡°System.Data.OleDb.OleDbException¡±ÀàÐ͵ÄÒì³£³öÏÖÔÚ System.Data.dll ÖС£
ÆäËûÐÅÏ¢: UPDATE Óï¾äµÄÓï·¨´íÎó¡£
µ¥¶ÀµÄINSERTÓïÑÔÔÚÊý¾Ý¿âÖÐÔËÐÐͨ¹ý¡£²¢ÇÒselectcommand ,insertcommand ¶¼ÊÇ¿ÉÒÔÔËÐеģ¬Î¨¶Àupdate ±¨Óï·¨´íÎó¡£
Çë½Ì¸ß ......
ÓÉExcel±í¸ñµ¼Èëµ½AccessÊý¾Ý¿â,µ¼Èë¹ý³ÌÖгöÏÖÓиö±ðÊý¾Ý³öÏÖÎÊÌâ,
Ê×ÏÈÌø¹ýÓÐÎÊÌâµÄÊý¾Ý,È»ºó°ÑÕâÌõÊý¾Ý´æ·Å½øÊý×é,ÔÚ´¦ÀíÍêËùÓе¼È붯×÷Ö®ºó,
ÔٰѳöÏÖÎÊÌâµÄ¼Í¼(¹¤ºÅºÍ¼Í¼ÌõÊý)ÓÃMSGBOXÌáʾ¸ø¿Í»§.
ÊÇ·ñÐèÒª°Ñµ¼ÈëµÄÊý¾ÝÿÌõ¶ÔÓ¦Êý¾ÝµÄÂÖ×ŶԱÈ?
ÇëÎʸÃÈçºÎʵÏÖ?
ÖªµÀµÄÐÖµÜÇ ......
±¾²ËÄñÔÚʹÓÃVB2005¶ÔACCESS±à³ÌʱÓöµ½ÎÊÌ⣺²»ÖªÈçºÎ°Ñ±íµÄËùÓмǼȫ²¿É¾³ý¡£²»ÖªÓÐûÓиßÊÖÄÜÌṩ´úÂ룿
àÅ£¬Ó¦¸ÃÓÃɾ³ý±íÓï¾ä
DELETE * from ±íÃû
Â¥ÉÏ˵µÃ¶Ô£¡
ÄDz»ÊÇÕû¸ö±í¶¼É¾³ýÁË£¿
ÒýÓÃ
ÄDz»ÊÇÕû¸ö±í¶¼É¾³ýÁË£¿
²»ÊÇɾ³ý,ÊÔÊÔ¿´
delete * from ±íÃû
delete from ± ......
ÇóVB6.0Á¬½ÓSqliteÊý¾Ý¿â¼°²éѯ´úÂ룬½â˵ԽÏêϸԽºÃ£¬ÒòΪÎÒ»¹Ã»ÓÐÓùýSQLite£¬Ð»Ð»£¡
Éϴζ¼²»¸øÎÒ·Ö¡£¡£
×¢²ásqltp30.dllÕâ¸öActiveX DLL
ÓÃÀïÃæµÄSQLiteDBÀཨÁ¢¡¢Á¬½ÓÊý¾Ý¿âÎļþ£¬¾ÍÏñADODBÀïµÄConnection
ÓÃÀïÃæµÄDatasetÀà²Ù×÷±í£¬¾ÍÏñADODBµÄRecordset¡£
http://topic.csdn.net/u/20090908/17 ......