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

[µo°Ý] ªø´Á©Ê­q³æ¥B¶·¨C¤éºûÅ@ªº³]­p

[µo°Ý] ªø´Á©Ê­q³æ¥B¶·¨C¤éºûÅ@ªº³]­p

¥»©«³Ì«á¥Ñ starry1314 ©ó 2016-10-11 20:17 ½s¿è

1.½Ð°Ý¤@µ§­q³æ »Ýºû«ù30¤Ñ(¥B¨C¤é¤TÀ\»Ý·Ó¹ê»Ú¬O§_¦³±N³o¤@¤Ñ³o¤@À\ªº°Ó«~°e¥X,¨Ã¥B°µ¤W°O¸¹)­ì¥HEXCELªí®æ»s§@,¦ý¦p¹J¨ì¶W¹L30¤Ñ¬Æ¦Üªø¹F¤@¦~ªº±N«ÜÃøÅý¾Þ§@ªÌ¥h¨Ï¥Î,¤Ï¦Ó­n¤@ª½«Ø¥ß·s­q³æ
·QÂରaccesseªí®æ»s§@,Åý¦o¥iµL­­©µ¦ù
¦ý¹J¤W¤@­ÓÃøÃD
­ìEXCEL ¬O¥i¨Ì·Ó­qÁʪº°_  ©l ¤é´Á ¹w¥ý±N³o¤é´Á°Ï¶¡¤ºªºÀx¦s®æ³£°µ¤W¡i¤w°e¡jªº°O¸¹,
¦ý¨ìaccess ¤Ï¦Ó­n¨Ï¥ÎªÌ¥h³æ®æ¤@¤@¥h¶ñ¼g¤é´Á ¤Î°t°e¬ö¿ý,¤Ï¦Ó³y¦¨¤u§@®Ä²v¤j´T¤U­°

·Q½Ð°Ý¦U¦ì¦³¤°»ò¦n«Øij¶Ü....
ªí®æ½d¨Ò.rar (9.19 KB)
­Ó¤H·Qªº¬O ¬O§_¥i¥HVBA ¤w­q³æªº¤é´Á°Ï«Ø ¦Û°Ê¦A¤lªí³æ·s¼W ³o°Ï¶¡ªº©Ò¦³­q³æ©ú²Ó
¦p 8/1~8/30  ¤lªí³æ«h¦Û°Ê·s¼W
8/1¦­ ¤È ±ß
8/2¦­ ¤È ±ß
8/3¦­ ¤È ±ß

¬d¸ß¨ìªº·s¼W¸ê®Æ¨ì¤lªí³æ,¬O§_¥i¥HÅܼƨӤÏÂпé¤J©O?
8/1~8/30
ª½¨ì i = µ²§ô¤é´Á ¬°¤î
i = °_©l¤é´Á +1
¤£ª¾¸Ó¦p¦ó®M¤J¥H¤U¥N½X

DIM RS AS RECORDSET
IF ME.DIRTY THEN ME.REFRESH
SET RS=CURRENTDB.OPENRECORDSET("¾ú¥v°O¿ý¸ê®Æªí")
RS.ADDNEW
RS("°Ó«~¦WºÙ")=ME![°Ó«~¦WºÙ]
RS("­qÁʤé´Á")=ME![­qÁʤé´Á]
RS("¼Æ¶q")=ME![¼Æ¶q]
RS.UPDATE
RS.CLOSE
ME![¤lªí³æ].REFRESH

¨Ã¤£¤F¸Ñ§Aªº§¹¾ã»Ý¨D¡A¶È¯à¥Î²qªº¡A°Ñ¦Ò¬Ý¬Ý§a¡C
Database9.rar (52.21 KB)
Kenny

TOP

¦^´_ 2# ky2599y


   ¨¯­W¤F,¦ý¤£¬O³oºØ¤@µ§¬ö¿ý¿é¤Jªº®t¦b¦p§A³]ªº¤é´Á°Ï¶¡ ¶}©l 11/1 µ²§ô11/5
¨Ã¥B¦b¿ï¾Ü§¹«~¶µ«á ¨Ò¦p ¥Ò
·|¦³¥÷¤l¸ê®Æªí ¨Ì­q³æ¤é´Á¦Û°Ê«Ø¥ß«á,¤º®e¨Ì§ÇŪ¨ú(³]©w¦nªºµæ³æ¤º®e¥H¤é´Á¬°·Ç) ®M¤J
¥H¤U­q³æ©ú²Ó¬°¨Ì¾Ú¤@¶}©l¿ï¾Ü¿é¤J«á¦Û°Ê«Ø¥ßªº
01-¦Û°Ê­q³æ.rar (61.99 KB)

TOP

©Ò¥H§Aµæ³æ¬O¨Æ¥ý©w¦nªº¡A°²³]§A©w¥X¤F¤@¬P´Áªºµæ³æ¡A¨S¦³¥²­n§â¤@¤Ñ¤TÀ\µæ³æ¤S¦s¨ì«È¤áÀ³³æ¥h§a¡A§â«È¤á­q³æ»Pµæ³æ¥H¤é´Á¬°ÃöÁp¤£´N¥i¥H¡A´N¦p¦P¤@¥»®Ñ¡A¥L¦³¥Ø¿ý¡A¥Ø¿ý¬O¥H­¶¬°ÃöÁp¡AŪªÌ¬Ý¨ì²Ä´X­¶´N¥i¥H¶i¨ì¸Ó³¹¸`¤F
Kenny

TOP

¥»©«³Ì«á¥Ñ starry1314 ©ó 2016-11-5 22:27 ½s¿è

¦^´_ 4# ky2599y


   ¦]¬°¤£¬O©Ò¦³«È¤á³£·|¬O¤@¼ËªºªF¦è,¥u¬O¹w³]±a¤J³o¨Ç¸ê®Æ ¦p¦³¤£³ßÅwªºµæ¦â·|»Ý­n³æ¿W°w¹ï¨CÀ\¥h°µÅÜ°Ê

©Ò¥H¤~»Ý­n¤~¦^¦s¨ì«È¤á­q³æ¸Ì­±,¦A°w¹ï­Ó¤H¥h«È»s¤Æ

TOP

¦^´_ 5# starry1314

1. ¤@­Ó¤ë1~30¤Ñ³£¤£¦P?¥i®É­×§ï¥XÀ\«e¤@¤Ñ¡H·í¤Ñ?¤@¶}©l­qÀ\®É?
2. «È»s¤Æ§¹¦¨«á«È¤á°w¹ï¬Y¼Ëµæ¦â¤£º¡·N¡A­n¨D³oµæ¦â¥H«á¤£­n¥X²{¡A¨C¤Ñ°O±o¦í­n§ï¶Ü?
´«­Ó¨¤«×¦b»P«È¤á½Í§´µæ¦â«á·|À°¥L²£¥Í¤@¥÷µæ³æÀɮסA¨C¤é«ö¤TÀ\¬ö¿ý¬O§_°e¥X¡A·í«È¤á­n§ï®Éª½±µ¶i¤Jµæ³æ¥h§ï
¤]¤£¥Î¨C¤Ñ¤TÀ\­n¶}±Ò¹w³]µæ³æ¦A­×§ï¤º®e¶i¦æ¦sÀÉ
3. °µ­Ó«ö¶sÂI¤U¥h´N¨q¥Lªºµæ³æ³o¼Ë¤£¤]®¼¤è«K
Kenny

TOP

1.¬Oªº,³£¤£¦P ¥¼°e¥X¥h³£¥i§ï
2.¹w³]±a¤J´N«Ø¥ß­q³æªº¨º¤@¦¸,¨º¦¸´N§ï¦n¤@¶}©l©Ò½Íªºµæ¦â
¤§«á¨C·í±µ¦¬¨ì«È¤á¦³©ÒÅܰʪº¤º®e,¤~·|¥h°µ­×¥¿,§_«h´N·Ó¤@¶}©l³]©wªº¥h»s§@
¦ý´N¥²¶·±N¥¦­qÀ\¤Ñ¼Æ(EX: 11/1~11/10)ªºµæ¦â®Õ¥¿¹L¤@¦¸
¦Ü©ó¥Ñ«È¤á¥h°µ§ó§ï,¬O¥H«á§Æ±æ°µ¨ìªº¤è¦V
3.³o­Ó­ì¥»ªº¤è¦¡¬O¥ÑEXCEL+ACCESSE¥h°µªº,­n¸Ñ¨M2¤~¯à§¹¥þÂà¥ÑACCESS

TOP

§Aªº°ÝÃD¤Ó¤j
¦^¨ì§A­ì©l°ÝÃD¦n¤F
·s¼W + °j°é§PÂ_

DIM RS AS RECORDSET
IF ME.DIRTY THEN ME.REFRESH
SET RS=CURRENTDB.OPENRECORDSET("¾ú¥v°O¿ý¸ê®Æªí")
For i = 1 To (Me!µ²§ô¤é - Me!°_©l¤é) + 1
RS.ADDNEW
RS("°Ó«~¦WºÙ")=ME![°Ó«~¦WºÙ]
RS("­qÁʤé´Á")= Me![°_©l¤é] + i - 1
RS("¼Æ¶q")=ME![¼Æ¶q]
RS.UPDATE
Next i
RS.CLOSE
ME![¤lªí³æ].REFRESH
Kenny

TOP

http://blog.xuite.net/hcm19522/twblog/463912600

TOP

¦^´_ 9# hcm19522


  ·PÁ¨ó§U,¦ý»Ý­nªº¬O¦bAccesseªº°µªk,·Q§¹¥þÂ\²æEXCEL

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD