Access ´°ÌåÖÐÐмǼ ±ä»¯ ʱ´¥·¢ ʼþÊÇʲô
ÈçÌâÄ¿
Access ´°ÌåÖÐÐмǼ ±ä»¯ ʱ´¥·¢ ʼþÊÇʲô°¡
´°ÌåÉÏÓиöÊý¾Ý±í1µÄ ×Ö¶ÎA ×Ö¶ÎB ×Ö¶ÎCµÄ ×Ö¶ÎDÊÇCombo1 ÏÔʾ
×Ö¶ÎDµÄÐÐÊý¾ÝÊÇÒ»¸öQuery ,µ«ÊÇºÍ µ±Ç°ÐеÄ×Ö¶ÎAÏà¹Ø
×Ö¶ÎDµÄÊý¾Ýÿ´ÎÀ´Ô´¶¼ÐèҪˢÐÂһϣ¬µ«ÊÇÎÒдÔÚ´°ÌåµÄ ¸üкó ʼþÀ
×Ö¶ÎDµÄÊý¾Ý²»Ë¢Ð£¬ÎÒдÔÚÒ»¸ö°´Å¥ÀïµÄµÄˢРCombo1.Requery
¾Í¿ÉÒÔ £¬²»ÖªµÀΪɶ
×Ô¼º¸ã¶¨ ÁË £¬ Ö»ÒªÔÚCombo2»ñµÃ½¹µãµÄʼþµØ·½Ð´Ò»¾äCombo2.Requery
¶àл ACMain ¹ØÐÄ
Ïà¹ØÎÊ´ð£º
Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit
ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......
ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......
ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË,
ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,
ÒýÓÃ
Æäʵ¾ÍÊǰÑEXCELµ±³ÉÊý ......
ÎÒÊÖ¶¯Ìí¼Ó»ùÓÚCRecordSetÀàµÄÅÉÉúÀàCODBCDemoSetÀà,ÊÇÀûÓÃclass wizardÌí¼ÓµÄ¡£²¢ÇÒ¶¨ÒåÁËÒ»¸öÈ«¾Ö±äÁ¿CODBSDemoSet*m_pCommon.µ«ÊÇÎÒ³ÌÐò²»ÄÜÔËÐС£ÎÒ¸ú×ÙÁËһϣ¬µ½ÁËm_pCommon->Isopen£¨£©´¦·¢Éú´íÎ󣬣 ......
ÈçºÎ½«notesÊý¾Ýµ¼Èëms accessÊý¾Ý¿â£¿
¿´ÏÂÖ÷Òª´úÂ룬ÀÏÊÇÌí¼Ó²»½øÈ¥¡£
Dim msName As String
msName = ws.Prompt( PROMPT_OKCANCELEDIT, "ÊäÈë","ÇëÊäÈëÒªµ¼ÈëMS AccessµÄÃû³Æ£º" )
......