Thread: keep time and date

Hi people i need all your help!!

i have a login form, that i enter my username and password, and then i enter to my main menu!!

well my question is, how cabn i create a history table, so i can have wich person enter to the sistem

i make another table

- id_user
- username
- time
- date

so if someone can help me please!

thanks to all!

Originally Posted by jmurrayhead

What exactly do you need to know how to do? This is done easily via an INSERT SQL statement. Simply run the statement when the user logs in and you have a history of each time.

im really bad for coding, because im a rookie on this

do you have an example???

or some page i can read to learn how to do this??

i finally did it!!

thanks i use this cod

ok i did it

i use this


Quote:
Private Sub cmdEnter_Click()
On Error GoTo Err_cmdEnter_Click
Dim rst As DAO.Recordset
Set rst = CurrentDb.TableDefs("historialacceso").OpenRecords et
rst.AddNew
rst!Username = Me.cmbLogin
rst!Fecha = Now()
rst!Hora = Now()
rst.Update
rst.Close
Set rst = Nothing

Exit_cmdEnter_Click:
Exit Sub
Err_cmdEnter_Click:
MsgBox Err.Description
Resume Exit_cmdEnter_Click
End Sub

just did it, thanks!