Todd,
The e-mail solution is definitely doable; I've never done it myself, but I
know others do e-mail a lot from Access.
The logon log is what I use, and I have found it very convenient; to do it I
sue a table with four fields, ID, UserID, Logon and LOgoff (autonumber,
text, date/time, date/time).
For the userID: if you have implemented Access security, you can retrieve
the logon name with Application.CurrentUser; if not, you can retrieve the
Windows logon name with Environ("UserName").
Logon and logoff time stamp: Now()
Logon and Logoff events: if you have a form that opens with db startup and
closes when the db closes, use its On Open and Close events; if not, make a
dummy one just for the purpose and hide it as soon as it is opened.
To add a record in the table at logon: use an append query (run by the
form's Open event), or some code to do the same via a recordset. The form
should have a hidden textbox to store the record ID, so you know which
record to put the timestamp in at logoff.
To add the logoff time stamp: an update query (filter: ID) or, again, a
recordset operation through code.
If you decide to go the table way and need more help, post back.
HTH,
Nikos
