access´°Ìå¼Ç¼ÖÐÈçºÎɾ³ýËù»÷ÐеļǼ£¿VBA´úÂëʵÏÖ
´ó¼ÒºÃ£¡
ÔÚaccess2003´°ÌåÖÐÈçºÎɾ³ýËù»÷ÐеļǼ£¿VBA´úÂëʵÏÖ¡£Çë´ó¼Ò°ïæ¡£·Ç³£¸Ðл£¡£¡£¡
ÎÒÕâÒ»¹¦ÄÜÊÇÒª½â¾öÕâÑùµÄÎÊÌ⣺ÎÒ±íÀïÓÐÁ½¸ö»òÈý¸öÐÕÃûΪ¡°ÕÅÈý¡±µÄ¼Ç¼£¬Ïëɾ³ýÄÄÌõ£¬¾ÍµãÐÐÄÄÐУ¬¾Í°Ñ¸ÃÐмǼɾ³ý¡£
ÊÔÊÔ from.recordset.Delete
¼ÙÉèÄãͨ¹ý×Ó´°ÌåÏÔʾ±í£¬¼ÙÉèIDΪΨһ±êʶµÄ×ֶΣº
×Ó´°Ìå:
Private Sub Form_Click()
CurrentDb.Execute "DELETE from AA WHERE ID=" & Me.id
Me.Requery
end sub
ллÄãÃÇ£¡ÎÊÌâ½â¾öÁË£¡£¡·Ç³£¸Ðл£¡£¡£¡
Ïà¹ØÎÊ´ð£º
ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿Ãǰïæ·ÖÎö һϣ¡£¡£¡
ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë
XML code:
<?xml version="1.0" encoding="utf-8"? ......
Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......
ÿ´ÎMFC³ÌÐòÍ˳öµÄʱºò ¶¼»á³öÏÖ
Unhandled exception at 0x035e1341 in cvPDM.exe: 0xC0000005: Access violation writing location 0x80517de0.
ÇëÎÊÕâ¸öÎÊÌâÓ¦¸Ã´ÓÄÄÀïÈëÊÖ½â¾ö £¿
ÓÐûÓÐÒ»Ì×ͨÓõĽ⾠......
ÎÒÔÚCBÁ·´´½¨ACCESSÎļþ£¬
²ÉÓõÄÏÂÁдúÂë,ÎÒרÃÅÏÈ×ö¸öС³ÌÐò²âÊÔ£¬Ò»ÇÐÕý³£¡£
È»ºóÔÚ¼ÓÔØµ½1¸öÈí¼þÖУ¬
´«ÈëµÄ±äÁ¿MDB_PathNameÒ²ÊÇÕýÈ·µÄ¡£
µ«ÔÚÖ´ÐÐ
mdb.OleFunction("Create", ......