Help needed,

[Angeluz]

Sorry, i dont know where should i post this( under which category)

so i just post it here,

I want to create a login page using access,
and then i wanted to record down the name of the user and the time and date(login and log out) when he/she is using the database.

And then record it down in a table.

Any ideas fellow forumers

 

[Moniker]

Make a table called t_Log. Add three fields: UserID, StartTime, and StopTime.

On the login form, use t_Log as the Record Source. Make a text field and set the control source to UserID. After they type in a user name, update the StartTime field to Now(). In the DB OnClose Event, set the StopTime to Now().

This has been covered multiple times. use the Search features of this forum if my example doesn't make sense.

~Moniker

 

[Angeluz]

Hi, again

Sorry guys, i can't seem to find it using search, any example of keywords to use, as i think maybe i enter the wrong keyword, been using words such as "login page", "record timestamp"

thanks in advance.

 

[Angeluz]

Update on this topic, Hmm, is it possible for the username and password be save in to a table in a database.