Hello friends of Access 
Lately I've been struggling with some issue and I've come to this point that I need some help, because it is driving me a little crazy
So, I would like to have a form, where I would chose year and month and also employee name and then I would be able to write down hours and type of work that he/she did for each day of selected month.
So far I've created table ST where are just number 1 to 31 and then with query and few expresions I get dates and for month I select.
I also have table Employee with ID, Name, Surname (and some other stuff that doesnt imply to this problem).
Then I also have table MDL where is also ID(of employee), Date, Hours and TypeOfWork.
I've managed to create querys which show all 31 or 30 days for all employees, but when I want to enter hours and type of work it says that recordset is not updatetable.
So please can anyone help me and tell me if this thing I'm trying is even possible?
Thank you very much to everyone here on this forum and happy Easter
Lately I've been struggling with some issue and I've come to this point that I need some help, because it is driving me a little crazy
So, I would like to have a form, where I would chose year and month and also employee name and then I would be able to write down hours and type of work that he/she did for each day of selected month.
So far I've created table ST where are just number 1 to 31 and then with query and few expresions I get dates and for month I select.
I also have table Employee with ID, Name, Surname (and some other stuff that doesnt imply to this problem).
Then I also have table MDL where is also ID(of employee), Date, Hours and TypeOfWork.
I've managed to create querys which show all 31 or 30 days for all employees, but when I want to enter hours and type of work it says that recordset is not updatetable.
So please can anyone help me and tell me if this thing I'm trying is even possible?
Thank you very much to everyone here on this forum and happy Easter
