I have a c# program with a microsoft access database.
open the form and you will see a time sheet form.
I have 3 employees Ed Adkins, Vija Jones, and Tom Smith.
The way the form works now.
1.user selects his name and his id number is automatically entered.
2.user enters regular hours or sick or overtime- etc…..
and then clicks Calculate- and then user click Submit button.
( data is then entered into tblTimeSheet)
question:
1.Can employee have a name and password to open individual form?
2.Next Can employee then add data each day to this form and have the data stay displayed on form – untill end of week when employee clicks submit button to have data sent to tblTimeSheet.
3.the next week when user enters name and password – a blank form opens.
example:
On Monday Vija Jones enters name and password and opens his form.
and enters 8 hours for Monday and closes the form.
On Tuesday Vija Jones enters name and password and can see he entered 8 hours on form for Monday and now enters 8 hours for Tuesday and 2 hours overtime and closes the form.
On Wednesday Vija opens enters name and password and can see the hours he entered for Monday and Tuesday and now enters 2 regular hours and 6 hours for sick time for Wednesday- because he is going home sick.
etc….
ON Friday Vija enters name and password and opens form and after he checks his hours and calculates the hours- Vija clicks Submit button and data is entered into tblTimeSheet.
When the next Monday comes- Vija enters his name and password and a blank form opens for him to start entering hours for the week again.
I need the process above accomplished- if you have another way of doing it – I will look at it- I just need it to work like I have explained.
If you can provide this- I need to see an example to let you know that this is what I am looking for
password for access database is 123abc
thank you
