I know this isn't really Mac software, but there doesn't seem to be a forum for this kind of thing and this site seems to be full of very knowlegeable people.
Anyway - I'm working on an Access database and I need to put a validation rule into a field, but I need that validation rule to only be applicable in a given situation. Here's some sketchy pseudocode for what I need to do:
This could be in VBA, or possibly (and preferably) something easier. I just need this to finally finish it off
Thanks - any help is greatly appreciated
Anyway - I'm working on an Access database and I need to put a validation rule into a field, but I need that validation rule to only be applicable in a given situation. Here's some sketchy pseudocode for what I need to do:
Code:
IF [Table].[Field] = 0 THEN // This field is boolean
Field.ValidationRule = "(<now()+60) AND (>now()+7)"
ELSE Field.ValidatonRule = ""
End IF
This could be in VBA, or possibly (and preferably) something easier. I just need this to finally finish it off
Thanks - any help is greatly appreciated