Search results

  1. L

    Any free template on diary exercise available on the net?

    Hi Larry E That is very helpful, super! Thank you very very much. I will expand this and create more reports.
  2. L

    Any free template on diary exercise available on the net?

    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...
  3. L

    Any free template on diary exercise available on the net?

    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.
  4. L

    Any free template on diary exercise available on the net?

    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.
  5. L

    Any free template on diary exercise available on the net?

    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...
  6. L

    Resize main form and subform

    I put it into detail and now it looks better. I'll see how it will work. Thank you very much
  7. L

    Resize main form and subform

    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?
  8. L

    Resize main form and subform

    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...
  9. L

    Conditional formatting based on the values in another table

    Yes, DoEvents helped. No more error messages. Thanks a lot.
  10. L

    Conditional formatting based on the values in another table

    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...
  11. L

    Conditional formatting based on the values in another table

    MajP, how did you manage to create dropdown box cbo_rota_choose situated on unboud form and it filters records in subform Dates?
  12. L

    Conditional formatting based on the values in another table

    Yes it worked. No more errors
  13. L

    Conditional formatting based on the values in another table

    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?
  14. L

    Conditional formatting based on the values in another table

    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.
  15. L

    Conditional formatting based on the values in another table

    Fantastic! Works well. It's a big step forward in my database. I am very grateful to you MajP!
  16. L

    Conditional formatting based on the values in another table

    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...
  17. L

    Conditional formatting based on the values in another table

    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
  18. L

    Conditional formatting based on the values in another table

    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...
  19. L

    Conditional formatting based on the values in another table

    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.
Top Bottom