R
RAM
I have a simple payroll application with the following tables : 1)Employees
2) Time
Forms are Employees DTR Form with the Time table as the subform.
Initially, the user types his ID Number on the opening window and when he
presses the Enter Key, Employees DTR Form with his picture, name and Time
subform (where he should type his Time-in) appear. My subform has Form view
property and Time in/Time out fields has TimeValue(Now()) as the default
value.
Now, I want my application to automatically add new records and sets the
focus on Date field. When a user logs in in the morning and go to the last
field which is Time Out field, automatically when an employee punches out in
the afternoon/evening, press a button to save the default time (system time)
because all the fields (time in/time out fields) are all not editable.
Please help me and thank you very much!
2) Time
Forms are Employees DTR Form with the Time table as the subform.
Initially, the user types his ID Number on the opening window and when he
presses the Enter Key, Employees DTR Form with his picture, name and Time
subform (where he should type his Time-in) appear. My subform has Form view
property and Time in/Time out fields has TimeValue(Now()) as the default
value.
Now, I want my application to automatically add new records and sets the
focus on Date field. When a user logs in in the morning and go to the last
field which is Time Out field, automatically when an employee punches out in
the afternoon/evening, press a button to save the default time (system time)
because all the fields (time in/time out fields) are all not editable.
Please help me and thank you very much!