Adding Network Username & Date / Timestamp

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Working to build a database that tracks different stages of an entry. Each
stage needs to show "WHO" and "when" the stage was completed. I was looking
to make a form that when a check box is clicked a macro would pull the users
network login ID and the current date and time to be recorded in the table as
two seperate fields.
 
hi,
I don't understand the checkbox idea. I would put text
boxes on the form to hold the username and time.

=Environ("username")
enter the above as a text box control source to get the
network username.
=currentuser()
enter the above as a text box control source to get the
database log on name if the database has users and groups
assigned.
=now() will produce the date/time in format 11/9/04 10:39

Regards
Frank
 
The network user name is available from:
http://www.mvps.org/access/api/api0008.htm

If you are trying to build a complete log of all inserts, edits, and
deletions, see:
Audit Trail - Log changes at the record level
at:
http://members.iinet.net.au/~allenbrowne/AppAudit.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

"Don (Novice Database User)" <Don (Novice Database
User)@discussions.microsoft.com> wrote in message
news:[email protected]...
 
Back
Top