Hi all,

I have a database about employee file management (human resources). Each employee is identified by his serial number ("EmployeeID" fileld).

There is the login system (for admin: admin as username and admin as password; for normal user: user1 as username and user1 as password) and you have the list of all registered employees.

A normal user can access each file only if it is previously approved, otherwise he or she must request it.

Once a file is opened, there is the main screen about the personal data and basic information of each employee, and below the sub-files, which are the most important part of everything.

Each hiring/termination period has a startdate and (possibly) a enddate, and I wanted to calculate each period actually worked. More or less through VBA code I was able to get the individual periods worked, the partial totals (of the sub-files) and finally the global total worked by the employee.

However, there are several problems and now I'm stuck:

- Meanwhile the partial total queries don't consider the days and I don't know why;

- Then I have problems with showing the record count in the tabs, it always gives me errors;

- But now my big problem is about calculation of periods worked. For example, if everything works and I have all the totals I want, then I will no longer be able to modify the records because using that (very complex) query then blocks the subform and I can no longer add new periods, nor modify existing ones or even delete them.

It's obviously a huge and messed up code, furthermore if I use the query (which necessarily has union, various joins, etc.) then I can't longer edit the records of the subform, therefore I can't modify, add or delete individual work periods.

So is it better to create another form linked to the subform to be able to add or edit records from there? Or is there another way to have the work periods easily?

Or also make period calculations completely separate but still visible near each record?  

In any case in a way that is "simple" for me to understand, because if in the future I have to modify or add other functions I wouldn't want them to cause conflicts.. :(

I quickly translated the attached file into English (I'm Italian) so I apologize for the errors.
In my access file (in Italian) for example the subforms linked with the queries (with calculated periods) are clearly visible, but the records are not updateable. In the English file version perhaps I didn't change some controls but the problem of the non-updatable record would still remain.

Link: https://we.tl/t-iaSf4PGNTb

Thank you very much in advance