Kamis, 02 Juni 2016

RE: [MS_AccessPros] Last Updated - My error

 

Robin,

Try the BeforeUpdate rather than the AfterUpdate.

Regards,
Duane Hookom, MVP
MS Access

> To: MS_Access_Professionals@yahoogroups.com
> From: MS_Access_Professionals@yahoogroups.com
> Date: Thu, 2 Jun 2016 10:20:57 +1000
> Subject: [MS_AccessPros] Last Updated - My error
>
>
> I am a modest Access user. As a result I have little experience.
>
> I have a form with a "Last Upated" field, [Lastupdated] and I need to
> update that field whhenever I make a change to the data.
>
> I have used this code in the 'After Update' property:
>
> = If Me.Dirty Then
> Me![LastUpdated]=Date()
> End If
>
> And I get an error message .
>
> I have also tried an eveny:
>
>
> Private Sub Form_AfterUpdate()
>
> If Me.Dirty Then
> Me![LastUpdated] = Date()
> End If
>
> End Sub
>
> which fails.
>
> Your help will be appreciated.
>
> Regards,
>
> Robin Chapple
>
>
>
> ------------------------------------
> Posted by: Robin Chapple <robinski@westnet.com.au>
> ------------------------------------
>
>
> ------------------------------------
>
> Yahoo Groups Links
>
> <*> To visit your group on the web, go to:
> http://groups.yahoo.com/group/MS_Access_Professionals/
>
> <*> Your email settings:
> Individual Email | Traditional
>
> <*> To change settings online go to:
> http://groups.yahoo.com/group/MS_Access_Professionals/join
> (Yahoo! ID required)
>
> <*> To change settings via email:
> MS_Access_Professionals-digest@yahoogroups.com
> MS_Access_Professionals-fullfeatured@yahoogroups.com
>
> <*> To unsubscribe from this group, send an email to:
> MS_Access_Professionals-unsubscribe@yahoogroups.com
>
> <*> Your use of Yahoo Groups is subject to:
> https://info.yahoo.com/legal/us/yahoo/utos/terms/
>

__._,_.___

Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Poskan Komentar