LogIn Table

[Guest]

Is there any way to generate a table that would include the Windows Login ID
and the date and time of the login to the database, and then attach that
information to each record ?

 

[Arvin Meyer [MVP]]

Is there any way to generate a table that would include the Windows Login
ID
and the date and time of the login to the database, and then attach that
information to each record ?

Sure. You can get the Windows login from an api:

http://www.mvps.org/access/api/api0008.htm

and just write that function return to a field in the record. For the
timestamp, just add a date/time field to the table and set its DefaultValue
to:

= Now()
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Brendan Reynolds]

There's code at the following URL to get the Windows user name ...

http://www.mvps.org/access/api/api0008.htm

 

[Guest]

How do I get that LogIn ID into the table?

Sure. You can get the Windows login from an api:

http://www.mvps.org/access/api/api0008.htm

and just write that function return to a field in the record. For the
timestamp, just add a date/time field to the table and set its DefaultValue
to:

= Now()
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Arvin Meyer [MVP]]

Add a field to the table for the username. Bind a textbox in your form to
that field. Set the DefaultValue of the textbox to:

= fOSUserName()

(the function name)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access