Recent content by Jun91

Again thanks for your support. I have one final question ! Is there a way the code will determine the difference between a 0 and a null? sometimes the code will not exit and will add the number of days to 0. Resulting in days like Dec.30-1899 If not, its Ok. Thanks.

Thanks for all your support. One final question. If I use, If IsNull(StartDate) Then Exit Sub Some times the code will not be able to tell the different between a 0 and a blank. And will try to add the number of days to 12/30/1899. Is there an expression other than null to prevent this?

Wow that got a bit complicated... So, it would end up like, Dim StartDate As Variant StartDate = Nz(Me.[TextBox Startdate], 0) If IsNull(StartDate) then Exit Sub ElseIf Me.[TextBox Projectsize] = "Small" Then Me.[TextBox Enddate]= DateAdd("d",20,StartDate) ElseIf Me.[TextBox Projectsize]...

Sorry !! One last question !! what can i do to prevent the error which occurs when [TextBox Startdate] is blank? Dim StartDate As Date StartDate = Me.[TextBox Startdate] If StartDate = Null then End ElseIf Me.[TextBox Projectsize] = "Small" Then Me.[TextBox Enddate]=...

thank you !! finally got it going !!! :rolleyes:

Hi pbaldy, Thanks again for getting back. I've tried your revised code but it did not work… Just checking but is the correct place to save it under, form > text box property (for TextBox Enddate) > Event > On change > code builder ? Hope you can help me get this going… Appreciate your...

Hi pbaldy, thanks for getting back again. Let me try this again. Dim StartDate As Date StartDate = TextBox Startdate If Me.[TextBox Projectsize] = "Small" Then Me.[TextBox Enddate].Visible = DateAdd(d,20,StartDate) ElseIf Me.[TextBox Projectsize] = "lagre" Then Me.[TextBox...

Thank you for your response!! I have some follow-up questions. 1) Do i insert the "source name" into the "ControlName" ? 2) Where do I insert the "DateAdd()"? Sorry these must be simple questions for someone more advanced... tried my best below... If [TextBox Projectsize] = "Small" Then...

Hi everyone, I’d like to know how to auto calculate on a table depending on the drop-down value I chose, to show a specific date. For example…. Drop down value: Small project, then start date + 20 days auto calculated Drop down value: large project, then start date + 60 day auto...