ACCESS FEED: RE: [MS_AccessPros] Re: Use of update to "LastUpdated" field

Rabu, 11 Februari 2015

RE: [MS_AccessPros] Re: Use of update to "LastUpdated" field

Hi Robin,

adding on ... how to update tracking fields is discussed in this video tutorial:

Learn Access -6- Create a Continuous Form in Microsoft Access (cc) {music by April Kelly}
https://www.youtube.com/watch?v=norAB9QvIls#t=21m58s

21:37 - discuss controls containing tracking fields on the form
21:58 discuss writing Before Update code for the form to update the date edited tracking field
22:40 click the Builder button to write the code
25:44 save code

Warm Regards,
Crystal

~ have an awesome day ~

--------------------------------------------
On Wed, 2/11/15, 'Graham Mandeno' graham@mandeno.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Subject: RE: [MS_AccessPros] Re: Use of update to "LastUpdated" field
To: MS_Access_Professionals@yahoogroups.com
Date: Wednesday, February 11, 2015, 2:44 PM

Hi Bill I think you mean Form_BeforeUpdate
don't you? I would think that updating the record in
AfterUpdate could cause an endless loop J Cheers,Graham From:
MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, 12 February 2015
09:29
To:
MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Use of
update to "LastUpdated"
field RobinMe.Dirty will not be true in
the AfterUpdate event. "Dirty" means a record is
in a state of being edited. What I would use
is:Private Sub
Form_AfterUpdate() lastUpdate =
Date()
End
Sub
The
AfterUpdate event only fires after a record has been
updated.
Regards,Bill Mosca, Founder -
MS_Access_Professionalshttp://www.thatlldoit.comMicrosoft Office Access
MVPhttp://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852My nothing-to-do-with-Access
bloghttp://wrmosca.wordpress.com

Posted by: "Graham Mandeno"
<graham@mandeno.com>