I was thinking about workbook or excel. I’ve got even a ready to use excel template from BMA. The thing is this all looks quite complex and rigid. I want it in access. I have already started designing the DB. Hopefully I will manage to do it myself. I just thought if there has already been...
I don’t think a phone app would suit us. Our manger will gather data from everyone for analysis. So it has to be a file on a computer. It’s on departmental level so we don’t have funding to purchase expensive system like fitness tracking.
Yes, there will be a standard list of activities divided in two categories, same for each employee. each Employee records their activities individually. They select activity and click start button. When finished they click stop button.
Hello.
The hospital asks us to do a 6 months diary exercise in order to improve and balance our job plans. Every day we will need to record our activities and time spent on each activity. I think I will do it with the help of MS Access. I wonder if there is anything already created for this...
Thank you amelgp for looking into it.
The height is already small 1.698cm. The anchors changed as you told. But still all the same. My subform is in form footer. Does it nee to go into the detail section?
Hi all. Sorry if this already exist. I couldn't find a simple solution without VBA.
My problem is I have a main form which has just a few fields and should be quite small in height. The subform however has multiple related records and it should be in the form of dataset and occupy the most of...
Hello MajP
Many thanks for all your tips. I learnt a lot from you.
I am keep tuning my DB. Now I have this problem. I set f_f_00_Main as starting form and the app starts with error message:
Then, when I close debug and choose the rota, it's OK. How can I sort it? I think I need to force the...
I owe much more than beer. How do I repay???
This is exactly how I wanted to. But unfortunately now when I play with all sunforms every now and then it stops with error messages. Is this because before all the forms were in one Form footer before and now they are in different Tabs?
Yes, that's definitely looks more elegant. I also would like to save more space by arranging dates in parent form on the left and the child content on the right. But it seems impossible. The best would be to have some sort of a horizontal linear calendar but it's beyond my capabilities.
everything works perfectly well. I am going to use my concatenate to accumulate all potential conflicts in one place and remove unnecessary subforms for MDTs and PMs. That's a huge help and thank you so much! I only wonder what to do to refresh conflicts as I update activities. At the moment I...
I am sorry I was not clear in the previous post regarding Saturday/Sunday. Actually what may happen, for example, the Absent tomorrow date may be Saturday. Because we don't work during weekends, I will not see this date as conflict. I would like that the query instead picks the next working day
That's absolutely marvellous! Thank you very much!
The second table All conflicts should be called Potential conflicts. I am going to add 4th and 5th days absent. And I was wondering if I can make sure that if some days absent fall on Saturday/Sunday they would be ignored and the next working...
MajP, I've been playing with your code and what I found that for some reason it doesn't show the 3rd day. It shows next day, 2 days after, but not 3 days after. I can't figure out why.