Marwa-
You can do it in the table directly. Open the table in Design view and then
open the Properties window. In the Validation Rule, enter:
=IsNull([Date Of Death]) Or (([Date Of Death] > [Date of Birth]) And ([Date Of
Death] < Date()))
In Validation Text, put a meaningful message such as:
Date of Death must be later than Date of Birth and earlier than today.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Marwa Abo Amra
Sent: Wednesday, June 29, 2011 1:23 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Validation Rule for Date
Hi All,
I need help in writing a validation rule for entering a date in a field. I have
a form that has two dates to be entered: Date of Birth and Date of Death. I
would like to write a validation rule in the Date of Death control so that users
can only enter values greater than date of birth and before today. I am not sure
what to write in the validation rule of that field in the table that I created
the form from so the form cannot accept any values of date that I mentioned.
Waiting for your assistance, pals!
Thank you.
Marwa
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar