ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕû°æ¾ÍÓУ¬°²×°µÄʱºòÑ¡×Ô¶¨Òå°²×°
ÄãÔÚÏÂÔØ¸ö´øaccessÊý¾Ý¿âµÄoffice
°²×°OFFICE 2000/2003/2007 ¶¼¿ ......
Çë½Ì¸ßÊÖ2¸öÎÊÌ⣺
1¡¢¹ØÓÚ²éѯACCESSÒ»¸ö×ֶεÄËùÓмǼÎÊÌ⣻ÔõôÏÂÃæ´úÂëÎÞ·¨´ò¿ªÊý¾Ý¿âѽ£¿
2¡¢ÏÂÃæµÄ´úÂë¿ÉÒÔ·ÃÎÊ¡°¹ú±êÂ롱×Ö¶ÎÖеÄËùÓмǼֵÂð£¿
¼±¼±£¡£¡£¡£¡£¡£¡£¡£¡
vbÓïÑÔ´úÂëÈçÏ£º
Sub addcomboxitem()
Dim Sql_connect As String
&nb ......
´ó¼ÒºÃ£¬ÎÒÔÚÊý¾Ý±íÖж¨ÒåÒ»¸öÐèÒª½øÐÐÅÅÐòµÄÕûÊý×ֶΣ¬µ«ÊǸù¾ÝÓ¦ÓÃÐèÇ󣬸Ã×ֶεÄȡֵ·¶Î§ºÜ´ó£¬¼¸ºõÓÃÂúÁËÕû¸ö32볤¶È¡£
ÔÚAccess±íÖкÃÏñÖ»ÓС°³¤ÕûÐÍ¡±Êʺϳ¤¶ÈµÄÐèÒª¡£¿ÉÊÇÓÉÓÚ³¤ÕûÐÍÊÇ´ø·ûºÅÊýµÄ£¬Òò´ËÔÚÖ´ÐÐ
SQL code:
select * from table1 order by field1
´Ëʱ¸ù¾Ý´ø·ûºÅÊýµÄ¹æÔò½øÐÐÅÅÐò£¬µ¼Ö ......
СµÜÊǸöASPÐÂÊÖ£¬×î½üÓöµ½¸ö¼¬ÊÖµÄÎÊÌ⣬ÀûÓÃASP+ACCESSÊý¾Ý¿â×öÁ˸öÍøÕ¾³ÌÐò£¬ÏëҪʵÏÖ°´Ô·ݲéѯ³öÊý¾Ý£¬ÒѾ´´½¨ÁËÒ»¸öʱ¼ä×ֶΣ¬ÀïÃæ´æµÄ¶¼ÊÇ1999-9-1ÕâÑùµÄ¸ñʽ£¬Ìá½»°´Ô²éѯʱµÄ±íµ¥Ê±ÊÇÓõÄ×Ö·û´®£¬µ«ÊDz»»áдÊý¾Ý¿â²éѯÓï¾ä£¬Ôõôд¶¼ÊÇÌáʾÓï·¨´íÎ󣬲»ÖªÄÄλ´óÏÀÄÜÖ¸½Ìһϣ¬¾ßÌåÈçÏ£º
´ÓÇ°ÃæÒ³Ãæ×öÁ˸öÄêÔ ......
ÎÒ½¨Á¢2¸ö±í,±ÈÈçtable a table b
¼ÙÈçÎÒtable a µÄÖµµÃÊÇÍøÒ³Ìá½»ÊäÈë½øÀ´..
Äܲ»ÄÜÔÚaccessÓмÆË㹦ÄÜ,¼ÆËã½á¹û¸³Óètable b
Èç: table a
id time num1 num2 ......
×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ
µ±Êý¾Ý¿â×Ö¶ÎΪ¡°Memo(Access±¸×¢)¡±µÄʱºò£¬Ê¹ÓÃMSHFlexGrid1.TextMatrixÈ¡µÃµÄÖµ²¢²»ÍêÈ«£¬³¤¶ÈÖ»ÓÐ999¸ö×Ö·û¡¡À§ÈÅÁ ......