General question about dates and expiration

[yanliang]

I am a new starter on learning about access and database.
I ran into a problem that is in the field of CardExpirationDate. An expiration date that has past or is within 30 days of the current date should not be allowed. Any expiration date that is more than 30 days into the future is acceptable.

I don't know what to type into the violation rules.
Please help.

Thank you

 

[theDBguy]

Hi. Welcome to AWF!

Didn't you already get some help on that same question in your other thread?

Basic database leaning

Hi, I am a student that just started learning about data and access. I ran into a problem with creating a rule in the field of CardExpirationDate. The question is how do I set up a command which tells the people to enter a Credit Card number which pastes or is within 30 days of the current...

www.access-programmers.co.uk

 

[isladogs]

Something like

If CardExpirationDate-Date>30 Then
   'process valid, run your code here
Else
   'show a message and block code
    MsgBox "Your card is close to or has passed its expiry date", vbCritical, "Card validation failed"
    Exit Sub
End If