µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» ½Ð°Ý´M§ä²Å¦X±ø¥ó¸ê®Æ(¥h°£«½Æ¸ê®Æ)
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
½Ð°Ý´M§ä²Å¦X±ø¥ó¸ê®Æ(¥h°£«½Æ¸ê®Æ)
ltc
µoµu®ø®§
¥[¬°¦n¤Í
ltc
·í«eÂ÷½u
UID
1901
©«¤l
49
¥DÃD
15
ºëµØ
0
¿n¤À
70
ª÷¿ú
70
ÂI¦W
0
§@·~¨t²Î
W7
³nÅ骩¥»
IE8
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
28 ¤p®É
µù¥U®É¶¡
2010-10-10
³Ì«áµn¿ý
2014-5-10
¤¤¾Ç¥Í
©«¤l
49
¥DÃD
15
ºëµØ
0
¿n¤À
70
ÂI¦W
0
§@·~¨t²Î
W7
³nÅ骩¥»
IE8
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2010-10-10
³Ì«áµn¿ý
2014-5-10
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2010-11-27 18:37
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
½Ð°Ý´M§ä²Å¦X±ø¥ó¸ê®Æ(¥h°£«½Æ¸ê®Æ)
½Ð°Ý§Ú³o¼Ë¼g¹ï¶Ü?
¬O§_¦³¨ä¥L¥h°£«½Æ¸ê®Æ«ü¥O¥i¥H¥Î?
ÁÂÁÂ
With MYRS
.Source = "SELECT ¥Á°ê FROM ¸ê®Æ ORDER BY ¥Á°ê DESC"
.ActiveConnection = MYCON '«ü©w©Ò¨Ï¥ÎªºConnectionª«¥ó
.Open
End With
With ¿ï³æ
.Clear
Do Until MYRS.EOF
If MYRS.Fields("¥Á°ê") <> ±ø¥ó Then
.AddItem MYRS.Fields("¥Á°ê")
End If
±ø¥ó = MYRS.Fields("¥Á°ê")
MYRS.MoveNext
Loop
End With
¼Ó¥D¼ö©«
½Ð°Ý INNER JOIN ¦p¦ó³s±µ¨âÓ¥H¤W¸ê®Æªí
¦³Ãö±j¨îÃö³¬EXCEL¤£¦sÀÉ°ÝÃD
¦³Ãö 2010 ColumnWidths µo¥Í¿ù»~
½Ð°Ý(°õ¦æ¶¥¬q¿ù»~ 75)°ÝÃD
½Ð°Ý¦p¦ó¨ú±o¸ê®Æ®wÁ`µ§¼Æ
½Ð°Ý¤U©Ô¦¡¿ï³æ¬O§_¥i¥H¦P®ÉÅã¥Ü¨âÄæ¸ê®Æ
½Ð±ÐVBA¦p¦ó¨ú±o¸ê®Æ®wsumªº¥[Á`
¦³Ãö TextBox1_Exit(...)·|run 2¦¸
½Ð°Ý·j´M¸ê®Æ®w©Ò¦³Äæ¦ì¦³²Å¦X±ø¥óªº¸ê®Æ
½Ð°ÝEXCEL VBA ±N¸ê®Æ®w¸ê®Æª½±µÂà¨ì°}¦C
¦¬ÂÃ
¤À¨É
et5323
µoµu®ø®§
¥[¬°¦n¤Í
et5323
·í«eÂ÷½u
UID
1602
©«¤l
128
¥DÃD
13
ºëµØ
1
¿n¤À
118
ª÷¿ú
118
ÂI¦W
0
§@·~¨t²Î
WinXP
³nÅ骩¥»
Office2003
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¥|¤t¦¨³£ÊT崃
¦b½u®É¶¡
120 ¤p®É
µù¥U®É¶¡
2010-9-13
³Ì«áµn¿ý
2017-5-12
´L¶Q·|û
©«¤l
128
¥DÃD
13
ºëµØ
1
¿n¤À
118
ÂI¦W
0
§@·~¨t²Î
WinXP
³nÅ骩¥»
Office2003
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
¥|¤t¦¨³£ÊT崃
µù¥U®É¶¡
2010-9-13
³Ì«áµn¿ý
2017-5-12
2
#
µoªí©ó 2010-11-27 22:06
|
¥u¬Ý¸Ó§@ªÌ
SELECT distinct ¥Á°ê FROM ¸ê®Æ ORDER BY ¥Á°ê DESC
TOP
ltc
µoµu®ø®§
¥[¬°¦n¤Í
ltc
·í«eÂ÷½u
UID
1901
©«¤l
49
¥DÃD
15
ºëµØ
0
¿n¤À
70
ª÷¿ú
70
ÂI¦W
0
§@·~¨t²Î
W7
³nÅ骩¥»
IE8
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
28 ¤p®É
µù¥U®É¶¡
2010-10-10
³Ì«áµn¿ý
2014-5-10
¤¤¾Ç¥Í
©«¤l
49
¥DÃD
15
ºëµØ
0
¿n¤À
70
ÂI¦W
0
§@·~¨t²Î
W7
³nÅ骩¥»
IE8
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2010-10-10
³Ì«áµn¿ý
2014-5-10
3
#
µoªí©ó 2010-11-28 08:47
|
¥u¬Ý¸Ó§@ªÌ
·PÁÂet5323 ¤j¤j¡A±Ð¾É
³o¬O§Únªº¨S¿ù¡AÁÂÁÂ
TOP
ÀR«ä¦Û¦b :
®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·