469,593 Members | 2,010 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,593 developers. It's quick & easy.

Last Updated By Field in Access

Is there a way that I can create a "Last Updated by" field in MS
Access. I know how to do the Date Last Updated but can't seem to find
out how to record the user who last updated the info.

Thanks in advance.

Aug 29 '06 #1
2 6678

abprules wrote:
Is there a way that I can create a "Last Updated by" field in MS
Access. I know how to do the Date Last Updated but can't seem to find
out how to record the user who last updated the info.

Thanks in advance.
if you implement security so that each user has his own userid, you can
use
application.CurrentUser

if not, you can grab the user's domain login name.
http://www.mvps.org/access/api/api0008.htm

but then you're counting on each user logging into the network using
his own username/password. Just set the value in the BeforeUpdate
property of the form.

Otherwise, check Allen Browne's site. he has code that does all this.
www.allenbrowne.com

Aug 29 '06 #2
Environ("UserName")

Set your LastUpdatedBy field equal to that value.

abprules wrote:
Is there a way that I can create a "Last Updated by" field in MS
Access. I know how to do the Date Last Updated but can't seem to find
out how to record the user who last updated the info.

Thanks in advance.
Aug 30 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Ike | last post: by
2 posts views Thread by Mark Reed | last post: by
1 post views Thread by Nicholas Howells | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.