Search results

Hi, I need to change my Macro to VBA code, but I'm wrong somewhere. So I have this Macro on my command button "cmd_1": UG Added Code Tags SetTempVar Name: temVarLaboratory Expression: [LaboratoryID] OpenForm FormName: sub_Indicators Where condition =...

I found and corrected my errors. I had to replace the new [fieldname] from function IIF([fieldname] = 0, Null, [fieldname]) into the Query2 and Query3. May be it has another way to by done, but for me (with my basic knowledge) it works. Every time I learn something new from you and from my...

What have I done so far: I'm not sure that I am corect, but I added into Query1 IIF([fieldname] = 0, Null, [fieldname]) and it is work. SELECT tbl_CodeOjects.CodeObjectID, tbl_CodeOjects.ObjectType, tbl_Inspections.DateTask, tbl_Inspections.Worker, IIf([Current]=0,Null,[Current]) AS Current_...

I apologize for my mistake in making you misunderstood and my bad English :banghead: isladogs, The_Doc_Man, you are absolutely right. I did not explain correctly. I wanted to replace zeros with blank fields. I apologize again for confusing you with my statement! Now I will try the new advice you...

Thanks to all of you who have responded with the feedback and advice. My idea is to change the zeros to blank fields in Query1, Query2 and Query3 because when I run the Report_1 I want no zeros to appear in the fields on the Report. Keep fields blank. Whene I tried to add into Query1...

I have not. I'll try with Nz() function. Thanks for the advice.

Hi all, I have Sql in my query: SELECT tbl_CodeOjects.CodeObjectID, tbl_CodeOjects.ObjectType, tbl_Inspections.DateTask, tbl_Inspections.Worker, Count(tbl_Inspections.TypeOfCheck) AS CountCheckTypes, Count(IIf([TypeOfCheck] Like "Current*",1,Null)) AS [Current], Count(IIf([TypeOfCheck] Like...

isladogs, I tried to understand what you were asking me and give you an answer, but I might have missed something. I will certainly continue to rely on other people (as well as you), (especially here in this forum) because I know that they have a lot of knowledge, skills and extensive experience...

I tried with Debug, but when I start it no error occurs. I'm sorry I didn't mention it in the specific comment, because I wrote about it in the comments above. I'm quite a beginner and trying to learn from the things you do and the suggestions you offer. This task is impossible for me and my...

I use MS Access 2016, 64-bit. For every button, the error is the same as the one I showed in the picture. Just the exit button does not show me an error! By the way, I should mention that when I looked carefully at the latest version you built - Database_EN_v7.4, if I don't apply folter...

isladogs, When I try to open the IncidentAnalysis db it shows me this Error:

Thank you again, isladogs. Works great. That's what I wanted. Now I try to set up the second criteria - Date range in the "qryTypes_Crosstab1"but it doesn't work: Between [Forms]![fm_Report2]![txt_DateFrom] And [Forms]![fm_Report2]![txt_DateTo] I want to set up criteria like that: If...

Maybe I should explain a little more why I added those additional fields from tbl_Code_Objets in Query 1. My idea is when I generate a report, it must be displayed all the entries in the fields "CodeObjectID" and "ObjectType" аnd then if there are records for the specifically filtered worker...

Hello again, I am still looking for a solution to my problem with reporting in the appropriate form. Here's what I've built so far with the huge help of isladogs and June7: I have query "qryTypes_Crosstab1" and "Query1". NowI'm trying to set the "Query1" as RecordSource to report but it shows...

Thanks, June7. I'll try to solve the problem!

I totally agree with that. I learn many things every time and then practice and develop them.Thanks June7. I built Query with your code: SELECT tbl_CodeOjects.CodeObjectID, tbl_CodeOjects.ObjectType, tbl_Inspections.DateTask, tbl_Inspections.Worker, Count(tbl_Inspections.TypeOfCheck) AS...

So, is this the best way to apply a worker and/or date filter with the dynamic parameterized query? I'm afraid I won't be able to do it. Seems pretty complicated to me. Would you do it on my latest version of db, please?

This is my latest version of db:

I am trying to look for a solution to this case, but so far I am not succeeding. When I apply in my QUERY RIGHT JOIN and run it the objects that have no entries (Value=0) do not appear, but I want to be there. When I use LEFT JOIN in QUERY everything is fine. So, when I run Crosstab query it is...

I built a report with the 1st method and now it works fine (Thanks again June7). What I'm trying to do now is this - When I do not set a filter all objects appear and those that do not have inspections.When I filter with the filterform I want the objects that are not inspected (with value 0) to...