How do I add data to the same row in a table...?

[Bongazi]

Hello Everyone,
I am totally new to access 2007. I have created a logon form that gets data from a "Employees" table.

I want to add logon date and time information to the same row of a logged on user. If possible add the logout date and time too.

Is it better to create a second table or possible to do everything in one table..?

herewith the logon code used:

----------------------------------

Option Compare Database
 
Private Sub cmdLogin_Click()
'set the variable for the invalid login retry
Static intLogonAttempts As Integer
'Check to see if data is entered into the UserName combo box
    If IsNull(uname) Or uname = "" Then
      MsgBox "You must choose a User Name.", vbOKOnly, "Required Data"
        uname.SetFocus
        Exit Sub
    End If
 
    'Check to see if data is entered into the password box
 
    If IsNull(passw) Or passw = "" Then
      MsgBox "You must enter a Password.", vbOKOnly, "Required Data"
        passw.SetFocus
        Exit Sub
    End If
 
    'Check value of password in tblEmployees to see if this
    'matches value chosen in combo box
If passw.Value = DLookup("Password", "Employees", _
                                  "[ID]=" & uname.Value) Then
 
    ID = uname.Value
 
    'Close logon form and open Control Panel screen
    'CurrentDb.Execute "INSERT into Employees (LogonDate) VALUES (date())"
    DoCmd.Close acForm, "LogonForm", acSaveNo
    DoCmd.OpenForm "Control Panel"
    intLogonAttempts = 0
 
  Else
      MsgBox "Password Invalid. Please Try Again", vbOKOnly, _
            "Invalid Entry!"
        intLogonAttempts = intLogonAttempts + 1
        passw.SetFocus
 
    End If
 
    'If User Enters incorrect password 3 times database will shutdown
 
 
    If intLogonAttempts > 3 Then
      MsgBox "You do not have access to this database.Please contact admin.", _
               vbCritical, "Restricted Access!"
        Application.Quit
    End If
 
End Sub
 

---------------------------------------
The table is called "Employees"
with fields:
ID - Autonumber
FullName - Text
Password - Text
LogonDate - Date/Time

Thanking you in advance,
Bongazi

[Mariostg]

It depends what you want to achieve. If you want to keep a history of a given user logon, you will need a table to keep track of the logon through an insert statement. If you are only interested in the most recent logon, then you could do it in the employee table through an update statement.

[Bongazi]

Mariostg,

thank you for your quick reply. Could I do both? Keep a logon history in a different table through the insert statement and update the current "Employee" table?
And how would I go about that?

Thank you again for your patience and willingness to share information :-).

Regards,
Bongazi