Hey guys does anyone here knows what is the code for inserting the current day in a form? I'm creating an Employee Monitoring System. I have here a part of the codes of my program
Private Sub Command1_Click()
If Text1.Text = "2036251" Then
Adodc1.RecordSource = "select * from Table4 where Employee_ID= 2036251"
Adodc1.Refresh
Adodc1.Recordset.Fields("Time- In") = Time
Adodc1.Recordset.Fields("Date Log") = Date
Adodc1.Recordset.Fields("Day") = Day
Adodc1.Recordset.Update
End If
The code above generates an error and I think it is because of the line Adodc1.Recordset.Fields("Day") = Day. The problem is that I don't know what is the right code for that. The logic of my program is that once you typed in your employee_id number, the database should be updated. The database should display the current time, date and day of your login. Please help me. Thanks in advance :)