¦p¦ó²MªÅ¾ãµ§¸ê®Æªº¬Y¤@Äæ¦ìÈ©O¡H
- ©«¤l
- 231
- ¥DÃD
- 55
- ºëµØ
- 0
- ¿n¤À
- 293
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- KEELUNG
- µù¥U®É¶¡
- 2010-7-24
- ³Ì«áµn¿ý
- 2018-8-28
|
¦p¦ó²MªÅ¾ãµ§¸ê®Æªº¬Y¤@Äæ¦ìÈ©O¡H
¦U¦ì¤j¤j¦n¡G
¤p§Ì¥¿¦b¾Ç²ß¨Ï¥Îvba
¾Þ§@access¸ê®Æ®w
²{¦³¤@½d¨Ò·Q±N¬d¸ßªº
¬Y¤@µ§¸ê®Æ«ü©wªºÄæ¦ì¡G¿¤¥«
¬Û²Å®É±N¸Ó¿¤¥«Äæ¦ìȲMªÅ
¦ý¤p§Ì¨Ï¥Îvba»yªk·|¥X²{
¿ù»~°T®§¡C½Ð°Ý¤p§ÌÀ³¦p¦ó
§ï¥¿»yªk©O¡H
°õ¦æ¶¥¬q¿ù»~-2147217887 (80040e21)
¨ÑÀ³°Ó¸ê°T¦æ¬F°ÏÄæ¦ì¤£¯à¬O¹sªø«×¦r¦ê- Option Compare Database
- Option Explicit
- 'ADO °O¿ý§ó·s
- Public Sub ADOcontoExtDB()
- Dim con2 As New ADODB.Connection
- Dim rcord2 As New ADODB.Recordset
-
- Set con2 = CurrentProject.Connection
- rcord2.Open "Select * From ¨ÑÀ³°Ó¸ê°T Where ¿¤¥« Like '¥x¤¤%'", _
- con2, adOpenKeyset, adLockPessimistic
- With rcord2
- Do While Not .EOF
- Debug.Print .AbsolutePosition, .Fields("¨ÑÀ³°Ó½s¸¹"), .Fields(2), .Fields(3), .Fields(6)
- .MoveNext
- Loop
- End With
- rcord2.MoveFirst
-
- With rcord2
- Do While Not .EOF
- .Fields(6).Value = "" '¦pªGÂù¤Þ¸¹¤º¥[³æ¤Þ¸¹¥i°õ¦æ¡A¦ý¤£¥[³æ¤Þ¸¹´N·|¥X²{¿ù»~°T®§
- .MoveNext
- Loop
- End With
- con2.Close
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 5
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2015-5-14
- ³Ì«áµn¿ý
- 2018-12-22
|
¦pªG±N¸ÓÄæ¦ìªº"¤¹³\¹sªø«×¦r¦ê"³]©w¬°yesÀ³§ï¥i¥H¸Ñ¨M |
|
|
|
|
|
|
- ©«¤l
- 231
- ¥DÃD
- 55
- ºëµØ
- 0
- ¿n¤À
- 293
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- KEELUNG
- µù¥U®É¶¡
- 2010-7-24
- ³Ì«áµn¿ý
- 2018-8-28
|
¦^´_ 2# aa7551
¤j¤j±z¦n¡G
ÁÂÁ±z¡I
¦ý¤p§Ì¬O·QÅý¨Ï¥ÎªÌ¥i¥H
קï¤@µ§¸ê®Æ¤º¬Y¤@Äæ¦ì¸ê®Æ
©Î¬O¥i²MªÅÄæ¦ì¸ê®Æ¡C
¦]¦¹¡A¤£·Q§ïÅÜì³]p¤º®e¡C
·P®¦¤j¤j¡I |
|
|
|
|
|
|
- ©«¤l
- 116
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 190
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2002
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2010-11-17
- ³Ì«áµn¿ý
- 2024-10-27
|
°õ¦æ¶¥¬q¿ù»~-2147217887 (80040e21)
¨ÑÀ³°Ó¸ê°T¦æ¬F°ÏÄæ¦ì¤£¯à¬O¹sªø«×¦r¦ê,¦pªG="",«h²Å¦X¿ù»~°T®§,¦]¬°¸ê®Æ¬°¹sªø«×¦r¦ê,À³§ï³]©w |
|
|
|
|
|
|