Login capture

[Jay]

Dear All,

i have a MS Access database where users login using their indvidual user
accounts, is there a way to capture the userid and date/time stamp so if the
users adds entries to the database it will capture the login id and the
date/time stamp in a table?

I would apreciate if someone can assist?

many thanks
jay

 

[Douglas J. Steele]

http://www.mvps.org/access/api/api0008.htm at "The Access Web" will give you
the userid.

You simply use the VBA Now() function to get the current date and time.

Put code in the BeforeUpdate event of the form to assign those values to the
appropriate fields in the form's RecordSource.

 

[Jay]

Doug,

thanks for the response, the login i want capture is the database login not
the network, i am not familiar with the programming languages, so if you
could help in a simplest term.

thanks

 

[Douglas J. Steele]

Sorry, for the database login, there's a built-in function CurrentUser()

If you go into the definition for your table, look at the properties for the
fields in question. Set their DefaultValue properties to CurrentUser() and
Now(). (Note that this would not have been possible if you were looking for
the Windows ID, which is what my first response assumed)

 

[Jay]

thank you very much, very helpful

Sorry, for the database login, there's a built-in function CurrentUser()

If you go into the definition for your table, look at the properties for the
fields in question. Set their DefaultValue properties to CurrentUser() and
Now(). (Note that this would not have been possible if you were looking for
the Windows ID, which is what my first response assumed)