- ©«¤l
- 1
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 2
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- 7
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-29
- ³Ì«áµn¿ý
- 2015-10-9
|
[µo°Ý] ACCESS2010 µ{¦¡½X³]p°ÝÃD
¤p§Ì¹ï©óµ{¦¡½s½X¬OÓªù¥~º~
¦ý¦]¬°¤u§@¤W»Ý¨D©Ò¥H¦Û¦ægoogle¨Ã³]paccessªí³æ
²{¦b¹J¨ì¤F¤@Ó°ÝÃD¡A·Q½Ð¨D¦U¦ì¥ý¶iÀ°¦£
§Ú¦³¤@Óªí³æ¡A³]p¤F¤@Ó¿z¿ï¤è¦¡
º¥ý³]p¤@Ó¤U©Ô¦¡ªí³æ¡A¿ï¾Ü¬YC¡A¦ÓA«ö¶s¥i¥H¿z¿ïFÄæ¦ì¬YC¤Hûªº¸ê®Æ
±µµÛ¦A«öB¥i¥H¿z¿ï¥X¬YC©Ò¦³®×¥ó¤é´ÁÄæ¦ì(G)¬°ªÅ¥Õªº¸ê®Æ
A«ö¶s§Ú¬O³o¼Ë¼g±o
Me.Form.Filter = "[¼f¬d¤Hû]='" & ¤Hû¿z¿ï.Value & "'" '±ø¥ó ( ¤Hû¿z¿ï¬O§Ú¤U©Ô¦¡¿ï³æªº¦WºÙ)
Me.Form.FilterOn = True '±Ò°Ê False ¤£±Ò°Ê
Me.Form.Requery 'µe±§ó·s
³o¼ËOK
¦ý¬O§Ún¿z¿ï¥X¤é´ÁÄæ¦ì¬°ªÅ¥Õªº¸ê®Æ¤£ª¾¹Dnµ¹¥L¤°»ò±ø¥ó
¸Õ¹Lnull©Î""³£¤£¦æ
©Î¬O¦³¨ä¥L§ó¦n±o¿z¿ï¤è¦¡¡A½Ð¦U¦ì¥ý¶iÀ°¦£
·PÁ¡ã
ªþÀɬ°§Ú¥Ø«eªº´ú¸ÕÀÉ
TEST.rar (23.04 KB)
|
|