Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

satans_banjo

macrumors regular
Original poster
Sep 12, 2005
218
0
SE London
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:

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
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.