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

[µo°Ý] ACCESS2010 µ{¦¡½X³]­p°ÝÃD

[µ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¤é´ÁÄæ¦ì¬°ªÅ¥Õªº¸ê®Æ¤£ª¾¹D­nµ¹¥L¤°»ò±ø¥ó
¸Õ¹Lnull©Î""³£¤£¦æ
©Î¬O¦³¨ä¥L§ó¦n±o¿z¿ï¤è¦¡¡A½Ð¦U¦ì¥ý¶iÀ°¦£
·PÁ¡ã
ªþÀɬ°§Ú¥Ø«eªº´ú¸ÕÀÉ

TEST.rar (23.04 KB)

Me.Form.Filter = "[¥Ó³ø¤é´Á] Is Null"
Kenny

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD