C chas1416 Guest May 5, 2006 #1 I have check box [yes/no] on a form. I want to be able to tick check box only if today is Friday or Saturday. Any ideas please?
I have check box [yes/no] on a form. I want to be able to tick check box only if today is Friday or Saturday. Any ideas please?
Smart Registered User. Local time Today, 07:32 Joined Jun 6, 2005 Messages 436 May 5, 2006 #2 Place the following code in the forms on open or on load Dim 2day as integer checkbox.enabled = false 2day = format(date(),"d") Disable checkbox on form open or close if 2day = 5 or 2day = 6 then checkbox.enabled = true end if (5 = friday 6 = saturday)
Place the following code in the forms on open or on load Dim 2day as integer checkbox.enabled = false 2day = format(date(),"d") Disable checkbox on form open or close if 2day = 5 or 2day = 6 then checkbox.enabled = true end if (5 = friday 6 = saturday)
C chas1416 Guest May 8, 2006 #3 Many thanks Smart said: Place the following code in the forms on open or on load Dim 2day as integer checkbox.enabled = false 2day = format(date(),"d") Disable checkbox on form open or close if 2day = 5 or 2day = 6 then checkbox.enabled = true end if (5 = friday 6 = saturday) Click to expand...
Many thanks Smart said: Place the following code in the forms on open or on load Dim 2day as integer checkbox.enabled = false 2day = format(date(),"d") Disable checkbox on form open or close if 2day = 5 or 2day = 6 then checkbox.enabled = true end if (5 = friday 6 = saturday) Click to expand...