how to make lastlogin date & time (2 Viewers)

[SalmanZeiad]

i want to make form display in text box last login or entered to form

 

[MarkK]

Describe more exactly where you are stuck in accomplishing that task.

 

[SalmanZeiad]

Describe more exactly where you are stuck in accomplishing that task.

i want to add for example ,"last login :1-1-2026" to my login form

 

[DHookom]

You didn’t add much detail however you can add a text box with a Control Source like:
=DMax(“DateFieldName”, “TableName”)

 

[Gasman]

Well, first you need to store this data.
Then when you login, you look for that data.
I would use a record for each login, so you can DMax() on the DateTime, then store a new record as you log out, or even as soon as you log in.

 

[GPGeorge]

Further to what has been suggested, you need a table called something like "tblLogin". It will need fields like "Login" and "LoginDateTime". In an AuthoExec macro, call a function that captures the UserID of the person starting the application and the date and time of that login. Store that in your Login table. From that data, retrieving the most recent login for each user is straightforward using DMax().

 

[Gasman]

Further to what has been suggested, you need a table called something like "tblLogin". It will need fields like "Login" and "LoginDateTime". In an AuthoExec macro, call a function that captures the UserID of the person starting the application and the date and time of that login. Store that in your Login table. From that data, retrieving the most recent login for each user is straightforward using DMax().

I would retrieve before storing, else you will always get the current login?

 

[GPGeorge]

I would retrieve before storing, else you will always get the current login?

Good point.

 

[The_Doc_Man]

i want to add for example ,"last login :1-1-2026" to my login form

You have gotten several responses. I will explain a fine point to help you go forward in this issue.

Access is a bare-bones rapid application development system that gives you the tools to do things you want done. With VBA you can be very flexible. You can have all sorts of login and update and visitation statistics in history tables. BUT you have to build them yourselves. The basic rule is that if you want to be able to track something - like a login - you have to write code to STORE that login and define a place to keep that information for future use. For tracking logins, that usually means building a tblLoginHistory that tracks date and user ID for each login. It is possible to keep other things in that proposed table, but for VBA and Access, the rule is "You want it? You build it."

 

[CJ_London]

You’ve been a member for 8 years and asked the same question 2 years ago

record date & time entered user login

I want to log the date and time of each user login and display the last time logged in

www.access-programmers.co.uk

 

[Gasman]

I was beginning to think it was post bait, as o/p has not bothered to come back.
However, I myself have managed to ask the same question twice, as my memory is so bad. :-(

 

[SalmanZeiad]

You have gotten several responses. I will explain a fine point to help you go forward in this issue.

Access is a bare-bones rapid application development system that gives you the tools to do things you want done. With VBA you can be very flexible. You can have all sorts of login and update and visitation statistics in history tables. BUT you have to build them yourselves. The basic rule is that if you want to be able to track something - like a login - you have to write code to STORE that login and define a place to keep that information for future use. For tracking logins, that usually means building a tblLoginHistory that tracks date and user ID for each login. It is possible to keep other things in that proposed table, but for VBA and Access, the rule is "You want it? You build it."

Ok, i understood