Thomas-
If the user is entering updates via the form, then the updates should still
show. Are you using code to perform updates?
As for a time stamp, add two fields to the table: DateUpdated Date/Time and
UpdateUser Text
In BeforeUpdate of the form do:
Me.DateUpdated = Now
Me.UpdateUser = Environ("USERNAME")
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 Thomas
Sent: Tuesday, July 24, 2012 8:28 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] updating records
How can I update the record(s) to include a time-stamp field updated and the
userid when the record is updated via the form?
The form allows for edit and filter only. After the record(s) are updated on the
form, the updated information does not reflect on the on the form immediately.
I notice the updated information is displayed after I close and reopen the form.
So I know the affected rows are updated by Access.
Is there any way to force the update to be displayed immediately on the form
after the rows are being updated?
If I want to include some additional information, such as the time-stamp at the
time of the update and the userid etc, as part of the record update, what event
will allow me to included this before Access update the row(s) ?
Regards,
Thomas
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar