Search results

If I try this I I get

If I try this I get the wrong Number of arguments

Hi folks, I am trying to write a multiple-expression but do not know how to connect them properly. Help is appreciated. =IIf(not IsNull( [CompleteDate] , "Complete", " ", IIf(IsNull( [ReviewDate] , "Not Started)," ", IIF( [DueDate] > Day(), "Inprocess","OverDue")))

I am going to mark this as Solved. Thank you all very much for the help.

I am sorry I was not ignoring you. I could not get it to work. I got #Name! #size! and type errors. I was trying to figure out what I was doing wrong while also trying to follow other advice. I am sorry all the contributions to my learning are greatly appreciated.

Issue #1 I think I have resolved this issue. I found this code in one of the other discussions. It appears to be working.

Ok I dummied down my DB. I am not sure about asking the right question in the right order. I am new to writing expressions, macros, and VBA. I am never sure when to use which. I was using the expression builder in my report to have specific fields return specific results. I guess I should...

Sorry I just saw that it said file is too large

I am attaching a copy of my DB. I am now thinking that I need to write the expression based in if the complete date is filled in. So something like =IIF(txt_completeDate <0, Null, txt_duein) I put this in the complete date field but it did not work The form I am working on is the EventStatus_Sfrm

The best way to do this is with conditional formatting if the Due value is <= 0 then make the forecolor and backcolor White. I am not sure that would work, more like I am not sure how to write the expression. What I am attempting is If the [daysLate] has data, clear the data from the [DueIn]...

Hi guys I was not sure where this topic fit in the discussions. What I am trying to do is if the days late has data I want the due in field to clear Here is the expression I used so far. The piece I am missing is clearing (Hiding) the data in the due in field...

Thanks for this.

frmCourse Details is the main form I was playing around with nesting the subforms. Trying to make sure everything rolls-up and links back to the correct course.

Yes, I have done this. This is currently what I have. It is a bit messy and not easy to navigate. I was just looking for different suggestions and options for working with sub-forms. Sorry for any trouble.

My problem is my main form is based on the Course table then my lesson table is related to my course table then my topic table is related to my lesson table then my event table is related to my topics table and finally the review cycle is related to my events. Using tabs I have to link forms to...

Could you expand on the thought of one subform control and simply change the source object to view a different subform? I am not familiar with this method.

I am getting a better understanding of forms and sub-forms. I have found that I can hide sub-forms using a command button. My question is, is there a way to make the sub-form popup when the show hide button is selected? I have 7 sub-forms, I was hoping to make navigation a bit more friendly...

Oh, no. Please do. I am learning and want the advice. Just don't judge me based on my lack of knowledge.

I was trying to make my course details form page cleaner. I still have 2 subforms to add. Changes and Issues these need to link to the course ID and also the event ID. Please don't judge I am still learning and know that things could be cleaner. Any advice is greatly appreciated.

I guess I could put everything in one very long table...LOL