Bill/John,
Thank you both for your suggestions.
Regards,
Thomas
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> 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