Access ´°ÌåÖÐÐмǼ ±ä»¯ ʱ´¥·¢ ʼþÊÇʲô
ÈçÌâÄ¿
Access ´°ÌåÖÐÐмǼ ±ä»¯ ʱ´¥·¢ ʼþÊÇʲô°¡
´°ÌåÉÏÓиöÊý¾Ý±í1µÄ ×Ö¶ÎA ×Ö¶ÎB ×Ö¶ÎCµÄ ×Ö¶ÎDÊÇCombo1 ÏÔʾ
×Ö¶ÎDµÄÐÐÊý¾ÝÊÇÒ»¸öQuery ,µ«ÊÇºÍ µ±Ç°ÐеÄ×Ö¶ÎAÏà¹Ø
×Ö¶ÎDµÄÊý¾Ýÿ´ÎÀ´Ô´¶¼ÐèҪˢÐÂһϣ¬µ«ÊÇÎÒдÔÚ´°ÌåµÄ ¸üкó ʼþÀ
×Ö¶ÎDµÄÊý¾Ý²»Ë¢Ð£¬ÎÒдÔÚÒ»¸ö°´Å¥ÀïµÄµÄˢРCombo1.Requery
¾Í¿ÉÒÔ £¬²»ÖªµÀΪɶ
×Ô¼º¸ã¶¨ ÁË £¬ Ö»ÒªÔÚCombo2»ñµÃ½¹µãµÄʼþµØ·½Ð´Ò»¾äCombo2.Requery
¶àл ACMain ¹ØÐÄ
Ïà¹ØÎÊ´ð£º
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
ÎÒ»ú×ÓÀïÃæÃ»ÓÐACCESS,ÇëÎÊÔÚ²»ÖØ×°ÏµÍ³µÄÇé¿öϸÃÈçºÎ°ÑËü×°ÉÏ,֮ǰÎÒÊÔ×°¹ýÆäËü°æ±¾µÄSP3 OFFICE,µ«»¹ÊÇ×°²»ÉÏ,
ÇëÎÊÓÐʲôºÃ°ì·¨Âð?
°²×°OFFICE £¬Ñ¡Ôñ°²×°ACCESS¾Í¿ÉÒÔѽ ¡£
ÒýÓÃ
°²×°OFFICE £¬Ñ¡Ôñ°²×° ......
ÈçºÎ½«notesÊý¾Ýµ¼Èëms accessÊý¾Ý¿â£¿
¿´ÏÂÖ÷Òª´úÂ룬ÀÏÊÇÌí¼Ó²»½øÈ¥¡£
Dim msName As String
msName = ws.Prompt( PROMPT_OKCANCELEDIT, "ÊäÈë","ÇëÊäÈëÒªµ¼ÈëMS AccessµÄÃû³Æ£º" )
......