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

Àx¦s®æµLªk§ï®æ¦¡?

Àx¦s®æµLªk§ï®æ¦¡?

±qrecordset.getrows¨ú±o¤@Äæ®É¶¡­È,9:00 am,Åã¥Ü¬°9:00:00,¦¹Äæ®æ¦¡¤â¤u¤SµLªk§ï,µL½×§ï¬°¤°»ò®æ¦¡³£Åã¥Ü9:00:00,½Ð±Ð¤j®v«ü±Ð,ÁÂÁÂ
lmh

¤â°Ê§ó§ï¶¶§Q°Ú!!

¤£µM´N¸Õ¸Õ¬Ý:

¥H¤U±N®É¶¡©ñ¦bA1


Sub Timex()
'
' Timex Macro
'
    Range("a1").Select
    Selection.NumberFormatLocal = "hh:mm:ss AM/PM"
End Sub

TOP

¦^´_ 2# cji3cj6xu6

¤â¤u®Ú¥»´N§ï¤£¤F,§Ú¸Õ¤F¸Õ 9:00:00+0 µ²ªG=9:00:00,¦ý¥i¥H¤â¤u§ï¥ô¦ó®æ¦¡¤F,¥i¥H§ï¦¨ 9:00 am
°ÝÃD§Ú¦³1040000¦æ,¨C¦æ10­Ó¼Æ,³£­n§ï,¤£¸Ó³sºâ³N¹Bºâ³£¤£¥i¥H,¶Ë³z¸£µ¬!!!
lmh

TOP

¦^´_ 2# cji3cj6xu6

¤â¤u®Ú¥»´N§ï¤£¤F,§Ú¸Õ¤F¸Õ 9:00:00+0 µ²ªG=9:00:00,¦ý¥i¥H¤â¤u§ï¥ô¦ó®æ¦¡¤F,¥i¥H§ï¦¨ 9:00 am
°ÝÃD§Ú¦³1040000¦æ,¨C¦æ10­Ó¼Æ,³£­n§ï,¤£¸Ó³sºâ³N¹Bºâ³£¤£¥i¥H,¶Ë³z¸£µ¬!!!
lmh

TOP

§Ú¸Õ¤F¸Õ>¿ï¾Ü©Ò¦³¦³ºÃ°ÝªºÀx¦s®æ>control+c>¿ï¾Ü©Ê¶K¤W>¤Ä¿ï"¥[ªk¹Bºâ">½T©w>>©Ò¦³Àx¦s®æ«ì´_¥¿±`,¥i¥H§ï®æ¦¡,¥i¥H°µ¹Bºâ!!!
¦ý°ÝÃD»·¨S¦³¸Ñ¨M,¦p¦ó¥ÎVB°µ©O?¦Ó¥B¥²¶·°õ¦æ±o°÷§Ö,§_«h´X¥G¨S¦³·N¸q¤F
lmh

TOP

¦A¦¸¨D±Ï¤F,¦]¬°¼Æ¾Ú¶q¤j,§Ú­ì¨Ó¥ÎADO¨ú±o´X¤d­Ó¤å¥óªº¸ê®Æ,¦w¸m¦btemp­¶,¦A±qtemp­¶¤@¶ô¤@¶ô¨ú¥Î,­pºâ¾ã²z¸Ë¶i"¸ê®Æ®w",¦ý°õ¦æ¤@¦¸¯Ó®É10´X¤ÀÄÁ,¦ô­puserÃø¥H±µ¨ü,§Ú¤]¤£¦n·N«ä¥æ¦p¦¹¥\½Ò,©Ò¥H§Ú¥Î ADOªºrecordset.getrows¤èªk,§â¦p¦¹¯E¤jªº¸ê®Æ¶q,¸Ë¦b¤@­Ódictionary¨½,ÂǦ¹¥i¥H¦b°O¾ÐÅ騽­pºâ©M¾ã²z,³Ì«á¤@¦¸¹L§â¥þ³¡¸ê®Æ(d.items)©ñ¶i¸ê®Æ®w,®É¶¡¬Ù¤F¤£¤Ö,4¤ÀÄÁ¥i¥H§¹¦¨¥H«e10´X¤ÀÄÁªº¤u§@.§Ú¥Î d(d.count)=cn.Execute(iQ).getrows¨ú±oADOªº¿é¥X,¦ý¨ú±oªº¸ê®Æ¥þ³¡¬OString,¤£Âà´«¤£¯à¥Î,ÃöÁä§Ú¤£¼ô±xgetrows¥Îªk,­þ¦ì¤j¤jÄ@·N¦ù¥X´©¤â? ÁÂÁÂ,ÁÂÁÂ
lmh

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD