ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

½Ð°ÝAccess ¥i¥H°µªÑ²¼ºÞ²z¶Ü?

½Ð°ÝAccess ¥i¥H°µªÑ²¼ºÞ²z¶Ü?

½Ð°ÝAccess ¥i¥H°µªÑ²¼ºÞ²z¶Ü? ·Q°µ¶i¥X©ú²Ó+­ÓªÑ¸ê®Æ--³sµ²VBA---¤£ª¾¹D°µ¤£°µ±o¨ì..

§Ú¦³Å¥§ÚªB¤Í»¡¬O¥i¥H¥ÎAccess§@¸ê®Æ®w¨Ó§@¨ì¡A¦ý§Ú¤]¬O·s¤â§ÚµLªk±Ð©p§Æ±æ³oªº¥ý¶i¥i¥H¶Ç±Â¦]¬°§Ú¤]¦³³o¤è­±ªº»Ý¨D¡A¤£¹L³oªºAccess°ÝÃD¦n¹³¤ñ¸û¤Ö©Ò¥H­nµ¥°ª¤â¨ÓÀ°§Ú­Ì¸Ñµª¤F¡C
tony

TOP

·PÁ§AÀ°¦£..¦]¬°§Úı±oEXCEL ³q±`³£­nµ¥¥L­pºâ-¦³®É¥[¤W§ìºô¸ô¸ê®Æ·|ºC...©Ò¥H¤~·Q¨ì¥ÎAccess§@¬°­ì©l¸ê®Æ®w..¦A¥ÑEXCEL¨Ó­pºâ...¤£ª¾¬O§_¥i¦æ...¥Ø«e§Ú¬O°Ñ¦Ò.Ây°\.ªºEXCEL³]­p¨Ó·í­ÓªÑ°ò¥»­±¤ÀªR.ÁÙ¦³ ¤@­Ó¬O¤jªÑªF«ùªÑ¨«¦V¨Ó°µ°Ñ¦Ò...§Ú¬O·Q°µ­Ó¾ã¦X..Access·í¸ê®Æ®w...EXCEL¨Ó¶]­pºâ..

TOP

¥Ø«e§Ú¤]¬O·Q§@Ãþ¦üªº¸ê®Æ®w¡A¦ý¯uªº¬O³o¤è­±ªº·s¤â¦pªG¦³µ²ªGªº¸ÜÁٽЦU¦ì«e½ú¥i¥H±Ð¾É¤@¤U§@ªk¡I·PÁ¡I
tony

TOP

·PÁ§AÀ°¦£..¦]¬°§Úı±oEXCEL ³q±`³£­nµ¥¥L­pºâ-¦³®É¥[¤W§ìºô¸ô¸ê®Æ·|ºC...©Ò¥H¤~·Q¨ì¥ÎAccess§@¬°­ì©l¸ê®Æ ...
pig172 µoªí©ó 2011-10-22 13:05

¦pªG¬O§ì¨ú¸ê®Æªº¸Ü¡A§Ú·QExcel©MAccessÀ³¸Ó¬O¤@¼Ëªº³t«×¡A®t²§À³¸Ó¦b¸ê®Æ³B²zªº³t«×;Excel¬O¤ñ¸û¦n³]­p¡A·Q¶]±o§Öªº¸ÜÁÙ¬O­nªá®É¶¡³]­p¦bAccess³B²z¡C

TOP

¦pªG¦³¸ê®Æ®w°ò¦¦b¥ÎACCESS ·|¤ñ¸û¦X¾A

¦pªG¥u¬O³æ¯Âªº­n°O¿ý/­pºâ  EXCEL ·|¤ñ¸û®e©ö ¦³«Ü¦h²{¦¨ªº¨ç¼Æ¥i¥H¨Ï¥Î

¤£¥Î¦A¥t¥~¼gµ{¦¡

TOP

¦^´_ 3# pig172

¥ÎAccess§@¾ã¦Xªº·Qªk¬O¹ï£x
§Ú¤]¤£·|¼gµ{¦¡,¦ýAccessºâ¬O«Ü¤è«Kªº®M¸Ë³nÅé
¥ý±q°ò¥»ªº«Ø¥ß"¸ê®Æªí"¨ì"¬d¸ß¥\¯à"
´N¥i¥H»´ÃP±o¨ì§A­nªºµ²ªG
¤@¼Ë¥i¥H­pºâ¤Î¨ç¼ÆÀ³¥Î
·|¤ñExcel§ó§Ö
¦Ó¥B¨S¦³Excelªºµ§¼Æ­­¨î

§A¥i¥H±N²{¦³ªº¸ê®Æ¶×¤JAccess§@¸ê®Æªí
¥Î¤º³¡¬d¸ßºëÆF³]­p,±N¸ê®Æªí¤§¶¡ªºªÑ²¼¥N¸¹°µÃöÁp©Ê³sµ²
³o¼Ë¥i¥H¦Û¤v³]­p§A·Q­n±o¨ìªºµ²ªG

¤Jªù¤§«á,³Ñ¤Uªº´N¬O¤£Â_ªº½m²ß¤ÎÀ³¥Î

TOP

½Ð°Ý ¦³¤Hª¾¹D¦p¦ó¥Îaccess§ìºô­¶¸ê®Æ¶Ü
jayer

TOP

¦^´_ 8# jayer
¦^´_ 1# pig172
¦^´_ 7# HSIEN6001
µª®×¬O¡G µ²¦X Access ¸ê®Æ®w (¦p«D³B²z«D±`Ãe¤jªº¸ê®Æ®w¡A§_«h¦b¸gÀÙ¦¨¥»ªº¦Ò¶q¤U¡B¤O¨D¤è«K¡B
                 ¥H¤Î»PExcel¹ê°ÈÀ³¥Î­±¨Ó»¡¬O¥i¤©°Ñ¦Òªº)¡A¤]¬OÆZ­È±o±ÀÂ˨ϥΪº¡C

ªþ¤W¤@­Ó½d¨Ò¦@¤j®a°Ñ¦Ò¡AAccess »P Excel ¹ê»Ú¤W¤§À³¥Î(VBA)¡C (¦U¦ì¥i¦Û¦æµo´§¡A¥Ø«e§Ú­Ó¤Hªº°õ¦æÀô¹Ò¥ç¬O¦p¦¹À³¥Îªº)
¥]§t¡G(¤@) ¿ï©w«ü©w¤é´Á¡A±q Access ¤¤±N«ü©w½d³ò¤º©Ò¦³ªº¸ê®Æ¥þ³¡¨ú¥X¶×¦Ü «ü©w¤§ Excel ¤u§@ªí³æ¤º¡C
            (¤G) Àˬd«ü©w¤é´Á¬O§_¦s¦b©ó Access ¤¤¡C (ª`·N¡G¬d¸ß®É¤é´ÁÄæ¦ì«e«á­n¥H "#" & ¿ï©w«ü©w & "#" ªí¥Ü¤§ )
            (¤T) ´M§ä«ü©w­Ë¦^¤Ñ¼Æªº·í¤é¬O­þ¤@¤Ñ¡H (Ä´¦p¡G­n±oª¾­Ë¼Æ²Ä´X¤Ñ¬O´X¤ë´X¸¹µ¥)
                   (³o­Ó°ÝÃD¬O§Ú¼Æ¤é«e¦b¥»½×¾Â¤§´£°Ý¡A¦ý°£¤F HSIEN6001 ¤j¤j¦^ÂÐ¥~¡Aµ²ªG¸Ó¥÷´£°Ý¤]¤£ª¾¦ó¦]¡A
                   «K±q¦¹±q¥»½×¾Â¤H¶¡»]µo®ø¥¢ªºµL¼vµLÂÜ¡A³Ì«á¤£±o¤£¦Û¦æ³}®Ñ©±¬d¸ê®Æ¡A¦A¦Û­Ó¨à´ú¸Õ¤~¦³¤Fµ²ªG¡C)
¦bExcel¤¤¶}±ÒAccess¸ê®Æ´ú¸Õ.rar (257.85 KB)

TOP

¦^´_ 9# c_c_lai


    ÁÂÁµL¨p¤À¨É^^

§Úªºoffice¬O2003 ,´Á³f²Î­pµLªk¥Î
½Ð°Ý,¥i¥H´£¨Ñ2003®M¥Îªº?
§Ú·Q¾Ç²ß,¦p¦ó¼gVBAl§ìAccess¸ê®Æ
¥Ø«e¥u¯àÀ³¥Î¶×¤J¥~³¡¸ê®Æ-->¸ê®Æ®w¬d¸ß
~¦R¦Þ¶Ì¯º~^¥×^

VBAÁÙ¬Oªì¾ÇªÌ,¬Ý¤£À´ªº³¡¥÷«Ü¦h~«Ü¦h~«Ü¦h
¥¿¦b§V¤O¾Ç²ß=___=

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD