µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» Excel VBA + Access ªº°ÝÃD¡K
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
Excel VBA + Access ªº°ÝÃD¡K
darrenlien
µoµu®ø®§
¥[¬°¦n¤Í
darrenlien
·í«eÂ÷½u
UID
18078
©«¤l
6
¥DÃD
2
ºëµØ
0
¿n¤À
6
ª÷¿ú
6
ÂI¦W
0
§@·~¨t²Î
Windows 7 x64
³nÅ骩¥»
Office 2010
¾\ŪÅv
10
©Ê§O
¨k
¦b½u®É¶¡
3 ¤p®É
µù¥U®É¶¡
2014-7-18
³Ì«áµn¿ý
2014-10-21
¤p¾Ç¥Í
©«¤l
6
¥DÃD
2
ºëµØ
0
¿n¤À
6
ÂI¦W
0
§@·~¨t²Î
Windows 7 x64
³nÅ骩¥»
Office 2010
¾\ŪÅv
10
©Ê§O
¨k
µù¥U®É¶¡
2014-7-18
³Ì«áµn¿ý
2014-10-21
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2014-8-22 16:26
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
Excel VBA + Access ªº°ÝÃD¡K
½Ð°Ý¡G
¤p§Ì±ý¨Ï¥ÎExcel VBA + Access¨Ó¼¶¼gµ{¦¡¡A©Ò¥H¶R¤F®Ñ¨Ó¬ã¨s¡A¦ý¬O¥O¤H®ð¾kªº¬O¡A
§Ú³s°õ¦æ®Ñ¤¤ªº½d¨Ò³£¥X°ÝÃD¡A®Ñ¤¤¬O¦³´£¨ìY¬O¦w¸ËOffice 64¦ì¤¸ªº(¦]¬°§Ú¬O¦w¸Ë
Office 2010 64¦ì¤¸ª©)¡An¥h¤U¸ü ¡uMicrosoft.Jet.OLEDB¡vªº64¦ì¤¸ª©¥»¦w¸Ë¡A§Ú
¤]¤U¸ü¤F¨Ã¦w¸Ë¤F(
«ö§Ú¶i¤J³sµ²
)¡A
¦ý¬O¡A°õ¦æ¸Óµ{¦¡¨ÌÂÂ¥X¿ù¡A¥H¤U¦C¥X¸Óµ{¦¡ªº¤@³¡¥÷(ªþ¥ó¬Oµ{¦¡ªº§¹¾ãª©)¡F¦w¸Ë¤W
zMicrosoft.Jet.OLEDBªº64¦ì¤¸ª©«á¡A°õ¦æ¸Óµ{¦¡ªº¡i·s¼W°O¿ý¡j¡A´N¥X²{¤U¹Ï¿ù»~¡G
¤U¸ü
(13.03 KB)
2014-8-22 16:19
¦Ó¬d¤F¤@¤Uºô¸ô¤W¤@¨Ç¸Ñ¨M¤èªk¡A±N
.Provider = "Microsoft.Jet.OLEDB.4.0
½Æ»s¥N½X
§ï¦¨
Provider = "Microsoft.ACE.OLEDB.12.0
½Æ»s¥N½X
«á¡A¤Wz¹Ï¤ùªº¿ù»~¬O¸Ñ¨M¤F¡A¦ý¬O
«o´«¦¨¥H¤Uªº¿ù»~°T®§¡G
¤U¸ü
(13.47 KB)
2014-8-22 16:22
ºô¸ô¤W¡B½×¾Â¤W¤]§ä¤£¨ì¬ÛÃöªº¸Ñ¨M¤èªk¡A½Ð°Ý³oÓ°ÝÃDn¦p¦ó¸Ñ¨M©O?
ÁÂÁÂ!!
µù¡G
1¡Bªþ¥ó"CH21.rar"¬O¸Ó®Ñ©Òªþªºì©lµ{¦¡¡A§Ú¤@Ó¦r³£¨S¦³§ï¹L¡C
2¡Bªþ¥ó"CH21_Modify.rar"¡A¬O§Ú±NOLEDB4.0§ï¦¨OLEDB.12.0ªºµ{¦¡½X¡C
CH21.rar
(73.32 KB)
ì©lµ{¦¡¡C
¤U¸ü¦¸¼Æ: 2
2014-8-22 16:13
(ì©lµ{¦¡)
CH21_Modify.rar
(87.79 KB)
¤wקï¹Lµ{¦¡¡C
¤U¸ü¦¸¼Æ: 2
2014-8-22 16:13
(¦Û¦æ§ï¹Lªºµ{¦¡½X)
Sub AddTransfer(Style As Variant, FromStore As Variant, ToStore As Variant, Qty As Integer)
' Page 21-6
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
MyConn = ThisWorkbook.Path & Application.PathSeparator & "transfers.mdb"
MyConn = "Driver=Microsoft Access Driver (*.mdb);DBQ=" & MyConn
'MyConn = "Driver=Microsoft Access Driver (*.accdb);DBQ=D:\CH21\Transfers.accdb"
' ¶}±Ò³s½u
Set cnn = New ADODB.Connection
With cnn
.Provider = "Microsoft.ACE.OLEDB.12.0"
'.Provider = "Microsoft.Jet.OLEDB.4.0"
.Open MyConn
End With
' ©w¸q°O¿ý¶°
Set rst = New ADODB.Recordset
rst.CursorLocation = adUseServer
' ¶}±Ò¸ê®Æªí
rst.Open Source:="tblTransfer", ActiveConnection:=cnn, _
CursorType:=adOpenDynamic, LockType:=adLockOptimistic, _
Options:=adCmdTable
' ·s¼W¤@µ§°O¿ý
rst.AddNew
½Æ»s¥N½X
¦¬ÂÃ
¤À¨É
joey0415
µoµu®ø®§
¥[¬°¦n¤Í
joey0415
(joey0415)
·í«eÂ÷½u
UID
198
©«¤l
361
¥DÃD
57
ºëµØ
0
¿n¤À
426
ª÷¿ú
426
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
2003,2010
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
917 ¤p®É
µù¥U®É¶¡
2010-5-13
³Ì«áµn¿ý
2022-12-8
¡@¼ÊºÙ:
joey0415
¤¤¾Ç¥Í
©«¤l
361
¥DÃD
57
ºëµØ
0
¿n¤À
426
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
2003,2010
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2010-5-13
³Ì«áµn¿ý
2022-12-8
2
#
µoªí©ó 2014-8-22 20:17
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
1#
darrenlien
ªþ¤W¤@Ó¥i¥H¥Îªº½d¨Ò¡A¦Û¤v¸Õ¸Õ¬Ý
Chapter5.zip
(237.75 KB)
¤U¸ü¦¸¼Æ: 32
2014-8-22 20:16
TOP
darrenlien
µoµu®ø®§
¥[¬°¦n¤Í
darrenlien
·í«eÂ÷½u
UID
18078
©«¤l
6
¥DÃD
2
ºëµØ
0
¿n¤À
6
ª÷¿ú
6
ÂI¦W
0
§@·~¨t²Î
Windows 7 x64
³nÅ骩¥»
Office 2010
¾\ŪÅv
10
©Ê§O
¨k
¦b½u®É¶¡
3 ¤p®É
µù¥U®É¶¡
2014-7-18
³Ì«áµn¿ý
2014-10-21
¤p¾Ç¥Í
©«¤l
6
¥DÃD
2
ºëµØ
0
¿n¤À
6
ÂI¦W
0
§@·~¨t²Î
Windows 7 x64
³nÅ骩¥»
Office 2010
¾\ŪÅv
10
©Ê§O
¨k
µù¥U®É¶¡
2014-7-18
³Ì«áµn¿ý
2014-10-21
3
#
µoªí©ó 2014-8-25 14:11
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
2#
joey0415
º¥ý¥ý·PÁ joeyj0415 ¤jªº¼ö¤ß¦^ÂСA¦ý¬O¤p§Ì¦]ÅvªºÃö«Y¡AµLªk¤U¸ü¸Óªþ¥ó¡A¯à¤£¯à¤W¶Ç¨ìÃþ¦ü¹³Megaªº§K¶OªÅ¶¡¡A
©Î¬O±zª½±µ¸ò§ÚÁ¿µ{¦¡½XþÃänקï´N¦æ¤F!!
ÁÂÁÂ!!
TOP
¤pµØ
µoµu®ø®§
¥[¬°¦n¤Í
¤pµØ
·í«eÂ÷½u
UID
12413
©«¤l
36
¥DÃD
8
ºëµØ
0
¿n¤À
44
ª÷¿ú
44
ÂI¦W
0
§@·~¨t²Î
win 7
³nÅ骩¥»
office 2007
¾\ŪÅv
10
©Ê§O
¨k
¦b½u®É¶¡
24 ¤p®É
µù¥U®É¶¡
2013-1-8
³Ì«áµn¿ý
2020-10-29
¤p¾Ç¥Í
©«¤l
36
¥DÃD
8
ºëµØ
0
¿n¤À
44
ÂI¦W
0
§@·~¨t²Î
win 7
³nÅ骩¥»
office 2007
¾\ŪÅv
10
©Ê§O
¨k
µù¥U®É¶¡
2013-1-8
³Ì«áµn¿ý
2020-10-29
4
#
µoªí©ó 2014-8-25 23:03
|
¥u¬Ý¸Ó§@ªÌ
¤p§Ì¤]·Q¾Ç ¦p¦ó¥ÎAccess·í§@¸ê®Æ®w¡AExcel·í§@¿é¤J¤¶±
²{¦b¥ÎExecl·í§@¸ê®Æ®w¦³®ÉÔ¸ê®Æ¤Ó¦h®ÉŪ¨ú³£·|ÅܺC
TOP
joey0415
µoµu®ø®§
¥[¬°¦n¤Í
joey0415
(joey0415)
·í«eÂ÷½u
UID
198
©«¤l
361
¥DÃD
57
ºëµØ
0
¿n¤À
426
ª÷¿ú
426
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
2003,2010
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
917 ¤p®É
µù¥U®É¶¡
2010-5-13
³Ì«áµn¿ý
2022-12-8
¡@¼ÊºÙ:
joey0415
¤¤¾Ç¥Í
©«¤l
361
¥DÃD
57
ºëµØ
0
¿n¤À
426
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
2003,2010
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2010-5-13
³Ì«áµn¿ý
2022-12-8
5
#
µoªí©ó 2014-8-26 16:46
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
3#
darrenlien
§Úªºdropbox
https://dl.dropboxusercontent.com/u/40393708/VBA/Chapter5.zip
TOP
darrenlien
µoµu®ø®§
¥[¬°¦n¤Í
darrenlien
·í«eÂ÷½u
UID
18078
©«¤l
6
¥DÃD
2
ºëµØ
0
¿n¤À
6
ª÷¿ú
6
ÂI¦W
0
§@·~¨t²Î
Windows 7 x64
³nÅ骩¥»
Office 2010
¾\ŪÅv
10
©Ê§O
¨k
¦b½u®É¶¡
3 ¤p®É
µù¥U®É¶¡
2014-7-18
³Ì«áµn¿ý
2014-10-21
¤p¾Ç¥Í
©«¤l
6
¥DÃD
2
ºëµØ
0
¿n¤À
6
ÂI¦W
0
§@·~¨t²Î
Windows 7 x64
³nÅ骩¥»
Office 2010
¾\ŪÅv
10
©Ê§O
¨k
µù¥U®É¶¡
2014-7-18
³Ì«áµn¿ý
2014-10-21
6
#
µoªí©ó 2014-8-27 09:59
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
5#
joey0415
¤Ó·PÁÂjoey0415¤j¤jªºÀ°¦£¡A§Ú¤w¤U¸ü¦¨¥\¡A·Ç³Æ¬ã¨s¤@¤U±zµ¹ªºµ{¦¡½X¡FÁÂÁÂ!!¦A¦¸·PÁÂ!!
TOP
ÀR«ä¦Û¦b :
¤£n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µLªº¥i¯à¡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¯»µ·