Search results

Yes, a calendar view is much better. The only problem is how to incorporate such complexity as in my rota in one form. I think I though about Union query and tried to build it at the beginning but I failed and instead someone on this forum advised and helped me to use concatenate function to...

Thanks a lot Bib Fitz. The messaging system works. The only thing is it shows a message when it should not. I understand you coded that a message displays when a consultant is allocated some activities on another day. Actually I meant that there was no overlap of Activities with MDTs or PMs on...

Many thanks MajP. It works! Now I will write similar functions to use it when I allocate MDTs and PMs.

That's great!

Actually Activities, MDTs, PMs are quite similar in hierarchy. First I usually allocate MDTs, then PMs, then Activities. But later I can edit records of any of them and I wanted to be prompted if there is an overlap.

You are absolutely right. It's too complex for me. I will read about DLookup () and Count(). I'd very much appreciate if you show me how to do this in one form so that I can do it in the others.

But the thing the data is in different tables. For example, I allocated 1 Cutup to TM on 28/12. And made sure she is not allocated anything else on that day. But later, I had to swap MDTs (data stored in different table) so that TM got Gynae MDT. I don't want it and it happened only because I...

Because I don't want access to prevent validation. There will be situations when we are short of staff and I will need to allocate two activities on the same day. I just want this is highlighted and then make my own decision keep it or change it. For the same reason unique indexes will not help me.

Hello I would appreciate any advice. I have a form showing dates and within it several subforms showing data from other child tables all related by dates. When I write a rota, I am struggling with errors like I allocate someone for an activity when they are already are allocated to another...

I think this may be the problem. I actually added one consultant and may be after that the problem arose. But then I tried multiple things. I even deleted all data for the last several days. But it didn’t help. One think is clear - it is concatrelated function which causes the problem.

At home I’ve got access 19. At work I am not sure. I need to check tomorrow. It started at work and then continued on my home laptop. how should I analyse Db?

I solved the problem for now. I realised (too slowly of course) that on my google drive there should be many previous versions in trash. So I took one two weeks ago version and manually added all data for those two weeks table to table. Now everything works. But still to me it's a mystery what...

Thank you very much The_Doc_Man. I’ll keep trying to do something although it seems very complicated. I am just puzzled why it happened. It worked fine for many months. I didn’t make any changes, only added data. And all of a sudden the glitch started. I am frustrated about how unstable ms...

How do I put a breakpoint? I am not very sophisticated In this. I constructed this db year ago and since then Becaus€ everything worked fine and didn’t require tuning I forgot most of the plot.

The full message is this The SQL is probably this: SELECT q_s_00_rotas_dates.Year, q_s_00_rotas_dates.rota_id, q_s_00_rotas_dates.Rota_duration, q_s_00_rotas_dates.Week_no, q_s_00_rotas_dates.week_day_name, q_s_00_rotas_dates.week_day_date, t_r_14_activities_n.date_act...

Imported into a blank database. same problem

The project compiles. I did compact and repair to no avail. How to decompile? I will try now to import everything to a blank database

It started at work and continues with the same file o my home computer. The last update was 3 days ago and it stopped working today. Yesterday was fine

What is interesting, when I switch to design view and then back to form view this message is gone. But after I close the form and open it, it's back again.