Dennis-
After Update is all you need. When you change and save a row, After Update
fires. When you create a new row, After Update fires followed by After Insert.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Dennis Davidsson
Sent: Sunday, October 16, 2011 12:13 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] How to add timestamp properly when adding and/or
updating a form
Hello,
I have a table in which I have included a timestamp column in order to keep
track of every time I add a new record or update an existing record.
How shall I specify the Event properties for the form that I use to handle my
table?
I know that I shall add a Visual Basic line like 'Timestamp = NOW'.
But to which of all the possible Event properties shall I add this line?
Shall I add it to all the following:
After Insert
After Update
On Change
Or is there even more properties to consider?
I have tried some of these examples, but I am confused by the behavior of
Access. I cannot quite figure out the logic behind.
Regards
Dennis Davidsson
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar