¡¾ÒëÎÄ¡¿µ±Ç°ÖµÓëǰһÌõ¼Ç¼µÄÖµµÄ±È½Ï£¨Ïàͬ×ֶΣ©
ʱ¡¡¼ä:2012-04-13 07:43:45
×÷¡¡Õß:ÖÜ·¼ ID£º24526 ³ÇÊУºÉϺ£
Õª¡¡Òª:ÔÚ¸üкóʼþ£¬±È½Ï×ֶεÄÔÖµºÍ×ֶεÄÐÂÖµ¡£
Õý¡¡ÎÄ:
Ô×÷ÕߣºÎ´Öª¡¡¡¡·Ò룺ÖÜ·¼
¡¾ÒëÎÄ¡¿ÔÚ¸üкóʼþ£¬±È½Ï×ֶεÄÔÖµºÍ×ֶεÄÐÂÖµ¡£
ÏëÖªµÀΪʲôºÜÄÑÔÚÓû§¸üÐÂ×ֶκóÕÒ³ö×ֶεÄÔÖµÂð?ÎÒÈÏΪ¸üÐÂǰʼþ¿ÉÒÔͨ¹ýMe.[×Ö¶ÎÃû]»ñµÃÔÖµ¡£
ÕâÀïÓÐÒ»¸ö¼òµ¥µÄ·½·¨À´×öµ½ÕâÒ»µã£ºÊ×ÏÈÔÚ´°ÌåÄ£¿éÖС°Option Compare Database¡±µÄ´úÂëºóÃæ¶¨ÒåÒ»¸öÈ«¾Ö±äÁ¿¡£Õâ¸öÀý×ÓÀï,ÎÒÃǶ¨ÒåÒ»¸östringÀàÐ͵ıäÁ¿:hold_value.
Option Compare Database
Dim hold_value As String
...
½ÓÏÂÀ´ÎÒÃÇÔÚ´°ÌåÖн¨Á¢Ò»¸ö¡°³ÉΪµ±Ç°¡±Ê¼þ£º
Private Sub Form_Current()
hold_value = Me.icount ¡¯icountÊÇ×Ö¶ÎÃû
End Sub
Äã¿ÉÄܻᷢÏÖÄã»áµÃµ½Ò»¸ö¿ÕÖµµÄ±¨´í,ËùÒÔÄã¿ÉÄÜÏëҪʹÓÃÏÂÃæµÄ·½·¨À´ÈÆ¿ªÕâ¸öСÎÊÌâ:
hold_value = Nz(Me.icount, "") ¡¯°Ñ¿Õֵת»»³É¿Õ×Ö·û´®
×îºóÔÚ¸üÐÂʼþºó£¬ÔÖµºÍÐÂÖµ¶¼¿É¹©ÎÒÃÇʹÓá£
¡¾ÔÎÄ¡¿
Compare original value of field to new value of field in the after update event.
Ever wonder why it is so difficult to figure out what the original value of a form field was after the user updates the field? I thought that the Before Update event would help me do this but using the Me.Fieldname.Oldvalue doesn't give me the old value it gives the new value!
Here is a simple way to do this: First set up a global variable in this form just after the Option Compare Database. In this example we dimension a string variable called hold_value.
Option Compare Database
Dim hold_value As String
...
Next we create an On Current event for the form:
Private Sub Form_Current()
hold_value = Me.icount
End Sub
You may find that you get a null value error so you might want to use the following assignment to get around this little problem:
hold_value = Nz(Me.icount, "")
Finally in the After Update event we have both the new and old values available for us to use.
AccessÈí¼þÍøQQ½»Á÷Ⱥ (ȺºÅ:115180141) ¡¡¡¡¡¡¡¡¡¡¡¡AccessÔ´ÂëÍøµê
³£¼ûÎÊ´ð:
¼¼Êõ·ÖÀà:
Ô´ÂëʾÀý
- ¡¾Ô´ÂëQQȺºÅ19834647...(12.17)
- ¡¾Access¸ßЧ°ì¹«¡¿±¾ÈÕÀÛ...(06.19)
- ¡¾Access¸ßЧ°ì¹«¡¿±¾ÈÕÀÛ...(06.18)
- ¡¾Access¸ßЧ°ì¹«¡¿×Ô¶¯ÐÐ...(06.08)
- ¡¾AccessÔ´ÂëʾÀý¡¿×Ô¶¨Òå...(05.25)
- ¡¾Access Dcountº¯...(05.12)
- ¡¾AccessÏÖѧÏÖÓÃʾÀý¡¿Ö÷...(04.24)
- ¡¾AccessÔ´ÂëʾÀý¡¿»ñÈ¡±¾...(04.15)
- ¡¾Access´°Ìå²éѯʾÀý¡¿Í¼...(04.07)
- ¡¾AccessÌõ¼þ¸ñʽʾÀý¡¿Êý...(04.01)

ѧϰÐĵÃ
- ¡¶ÎïÒµ×âÁÞºÏͬ¹ÜÀíϵͳ¡·ÓÃAccess...
- ¡¶È¾ÕûÅä·½¹ÜÀíÈí¼þ¡·Access¿ìËÙ¿ª...
- ¡¶Ò½±£±¨Ïú¹ÜÀíϵͳ¡·ÎªÁËʹÎҵŤ×÷¸ü¼Ó...
- ¡¶°²È«Ö°ÒµÎÀÉúÐÅϢƽ̨¡·Access¿ª...
- ¡¶É繤·þÎñ¹ÜÀíϵͳ¡·Access¿ª·¢ÐÄ...
- ¡¶Éú²ú¹ÜÀíϵͳ¡·Ñ§Ï°Access¿ª·¢Öú...
- ¡¶Àͱ£ÓÃÆ·¹ÜÀíϵͳ¡·ÓÃÃËÍþ¿ìËÙ¿ª·¢Æ½Ì¨...
- ¡¶Ö×Áö±ê±¾¿âºÍÖ×Áö¿ÆÑÐÊý¾Ý¹ÜÀíϵͳ¡··Ç...
- ¡¶ÈéÒµERPϵͳ¡·²ÆÎñÈËÔ±ÓÃAcces...
- ¡¶·þÊι«Ë¾¹ÜÀíϵͳ¡·ÔËÓÃÃËÍþAcces...
×îÐÂÎÄÕÂ
- ¡¾Access¸ßЧ°ì¹«¡¿±¾ÈÕÀۼƼÇ...(06.19)
- ¡¾Access¸ßЧ°ì¹«¡¿±¾ÈÕÀÛ¼ÆÊý...(06.18)
- MIRR º¯Êý(06.18)
- ¡¾Accessɨä֪ʶ¡¿²éѯ¾®ºÅ¼ü...(06.17)
- Access²ÆÎñͨÓÃϵͳ¡¾Ô´Âë·ÖÏí...(06.16)
- ¡¾Access¸ßЧ°ì¹«¡¿×Ó´°ÌåÊý¾Ý...(06.15)
- Access2021½»Á÷QQȺ£¬Èº...(06.14)
- Accessд´úÂëʱ--ÉèÖÃÊäÈë·¨...(06.14)
- Access 2021 ÖеÄÐÂÔö¹¦...(06.14)
- ʹÓÃAccess¿ìËÙ¿ª·¢Æ½Ì¨µÄÉý¼¶...(06.13)
רÀ¸×÷¼Ò
- ÉϺ£ 1804ûœÌï
- ÉϺ£ 1166ÕÅÖ¾
- ½Òõ 576¶ÅС½Ü
- ÉϺ£ 509ºêÅô
- ½Òõ 477will.miao
- Î人 448Ö󽯷²è
- ½Òõ 391Ç®Óñì¿
- ÄϾ© 380ÑîÑ©
- ½Òõ 362½ðÓî
- ÉϺ£ 344СÖÜ
- ÉϺ£ 255Ò×Ñ«
- ³É¶¼ 215ºì³¾ÈçÑÌ
- ÉϺ£ 185Ê®¶Î
- ÉϺ£ 163ÖÜ·¼
- ÄϾ© 146Natsume Takashi
- ¹ãÖÝ 146Å·Ö¾»ª
- ãÉÐÐ 142Victor Duane
- ÏåÑô 129Big Young
- ÔÀÑô 124ÖìÒàÎÄ
- Äϲý 110½Óð