Search results

Thank you for the advice, June7. I'll try to do it

Yes, June7. I am still waiting for any solution on my problem - to sum up for each type of objectrecords in my qryCountInspectionTypes_Crosstab (as I showed in pic2 in my post #19). Аnd then I can search by name and date how many checks have been completed. If there is another solution to...

Thank you for the advice. I'll try. I keep waiting for help and advice. When you have free time about the decision, please write.

The code I use in my "Split Form" is from http://allenbrowne.com/casu-08.html. For my purpose it works perfectly. I use it often. I am very grateful for your help, isladogs. I hope there is a solution and an opportunity for the task.

Тhank you very much in advance, isladogs! Sorry I didn't understand what you mean

Hi Thanks again for the help you give me! I created emulated split form (ESF) with cbo and Date from/ To filters. The query works perfect. It show records sorted between dates and sorted by workes. But the records into the (ESF) are not united for each Object. Here's what I mean:

I apologize, but I cannot understand the meaning of the small or big issuе. I try to explain to myself how it is possible to look for something in the Crosstab that is missing. I mean that in the Crosstab there are none fields - "Workers" and "Date". When I add these fields to the...

Oh, I can't figure out how to apply these codes to mine query. I will not be able to handle it! :eek:

isladogs, the link does not opening....

Everything works perfectly. Thank you, isladogs Now the big question is how to filter the crosstab query in SplitForm with cbo_worker and txt_dateForm and txt_DateTo. How to do it?

I couldn't find where to change the order on the objects type of the column "ObjectType" to be same as tbl_CodeObject :banghead: But I want to do somethig more - to create this crosstab query on a splitform with comboboxes and dates and use them for filter data by cbo amd date form - to. How...

I have one more question - In my "qryCountInspectionTypes_Crosstab" I do not want them to be arranged in alphabetical order, but to preserve the order as they are in the table. How to do it?

I'll don't want to include RZI in it, because I will include it in a report. Тhat's exactly what i need.Тhank you very much, isladogs!!! Тhank you for your advice, theDBguy!

Hi, I need some help, please! I have table “tbl_CodeObjets” with fields “ObjectType” and “CodeObjectID”. I have another table “tbl_Objects” with fields “NameObject” and “CodeObjectID”. And I have “tbl_Inspections” with fields “TypeOfCheck” and “ObjectID. So, I want to sum and calculate...

Уоu're right. I'll try through the Tab controls

Еxactly! I am using a true navigation form. I think it will be able with reference a sub-subform in a navigation form. May I ask why you are never Navigation Form? and how to create form with tabs for subforms?

Oh, sorry. I type Master link field "InspectionID" and Child link "Inspection" it does nothing. No reaction. I want to mention that the subform "Inspection" is into in Navigation Form (which is not Main form) on "NavigationButton7"

I have tried, but it show me "Can't build a link between unbound forms".

I have to link to 3 subforms on Navigation form "NavForm" to main form "Inspection" because link Master link to Child Link is not allowed for unbound forms. The field name on subform "Products" is "InspectionID", same as the field name in the main form "Inspection". How to link them?

I changed the fields name (date names) with the same names in both tables as you said! I added the code you wrote for me...... .......and everything works exactly as I want!Тhank you very much, June7 !!!