By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,917 Members | 1,305 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,917 IT Pros & Developers. It's quick & easy.

Last Updated By Field in Access

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a

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

P: n/a
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.