Search results

I don't think it's wrong data. The database is fully normalised and everything i choose from dropdown boxes

Hello! I have been using my database for quite a long time. BTW I constructed it with a great help of experts on this forum. So, today, out of the blue, each time I move to the next record on one of the forms, I started receiving a message: Expression too complex in query expression...

Tried is and still Macro is created.

Do you mean the form which I want to open by this button?

My settings are UK

Is anyone experiencing the same issue as I am? When I create a button to open a form with filter, access creates a macro for that. I don’t like macros and I then convert macro to vba by clicking appropriate button on ribbon. Then the button would not work because during the process access puts &...

Yes I can. Actually I have other activities such as MDT and absentees in normalised way and to have them in one line in report I used concatenate function. May be I will have to use concatenate here as well to get a string like Cutup 1 Ls; Cutup 2 Tw; Cutup 3 Aw

Ok, thanks. I will now try to normalise. I’ll see what I can achieve. Unfortunately I am not so sophisticated in access. I d Ed Ben don’t know what is to hack form)

I tried normalised first before I desired to use unnormalised. I did not get to edit or enter records in crosstabs. Also reports for cross tabs are possible only if you define the columns somewhere in query design. This is not ideal for me. Yes ideally I should go normalised. But I have to...

The reaso why I used unnormalised is I wanted to get a report looking like a spreadsheet, rather than a stepped or blocked report. This is the only pitfall I came accross and this is not crucial for me. I have just two unnormaised big tables which accumulate into one spreadcheet in the final...

I know it is not a good practice but I had to do that because i needed a form fr entering data like in the attached picture. Otherwise I would not be able to have such a form

Yes I know It is not particularly normal from access point of view. But I had to do this because it was easy for me to enter data most user friendly. So what will happen now? Shall I forget this?

I am sorry the attached file was bad and I am attaching another one

Hello, I came across a task which I can't resolve. As it is shown in a table attached I have three fields, namely Cutup 1, Cutup 2 and Cutup 3. These fields contain values (allocated consultants) related to the same table. I need now to calculate how may cutups in total each consultant has...

MajP, Many many thanks. It works fantastically. I can now use the same for other forms.

Sorry for confusion If you go to the Main Main Menu form and click MDTs. There will be a subform MDT register. There will be a combobox Connsultant. Inn that combobox dropdown list I'd like to see Connsultants not absent on that day.

Yes, I attached the db. There are certain consultants registered absent in Absentees (t_r_11_cons_absense). When I allocate consultants to MDTs (t_r_10_MDT_reg) I want that in the combobox for consultants I see only thise consultants who are not absent on that day. Similar for Activities and SPR...

I am still struggling to find a solution. How can I filter combo box items so that only consultants available (not absent) on the day appear on the list.

Thank you Ranman256. The thing is I need this filter in one form for MDT_reg and the absentees are in another table. So how can I get around this?

Hello experts I've got a difficult question) I have these tables: table_Consultants which has a field Cons_id. This table contains all consultants. table_Dates. This table contains all dates for departmental rotas table_absentees. This table has a field Date which is related one-to many to...