Login form register

[isnpms]

Good morning.
I have a little system at my work and a few of people using it, with a login form with userid e passid. There's also a textbox that display the date and time it (login form) started (date()).


What i can't see it's a way to register these 3 itens: name, passoword and date and time anyone logged in, for posterior printing (report, txt, any...).
Acctualy what i most needed was a way to make theses registers everytime one of the tables was updated or addeed, with name, pw anda date/time too.
I cloudn't think anything that worked and even couldn't find a tutorial for helping me. If anyone could help giving an idea or suggestion, i thank you very much.

Ivan Sinigaglia
(Brasil)

[pkstormy]

I prefer to grab the user's loginID automatically in code. Here's an example along with a security table type setup. User's don't need to 'login' or enter any passwords and I can easily make buttons visible/enabled/disabled depending on their security level in the 'user' table.

http://www.dbforums.com/6332819-post68.html

As far as logging, I have in all my data type tables, 2 key fields. 1 is DateEntered (which I default on the form to =Now().) The other is a field I call EnteredBy which I default on the form to =getuser() (using the example in the above link to automatically grab the user's loginID)

User's tend to get sick of dealing with entering their login/password.