John, what if I need to do this for some other date fields. I have more than 15 fields of date that need to be related to each other in the same manner. Should I write up all validation rules in the table properties, or should I write each one separately in each field's properties? Please advice.
Thank you for your great help!
Marwa
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Marwa-
>
> It must be a Validation Rule on the table, not on a field. Did you open the
> table's Properties window?
>
> 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 m.statalex
> Sent: Wednesday, June 29, 2011 2:32 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Validation Rule for Date
>
> John, Thank you!
>
> I still have a problem, when I entered that validation rule I got the message:
> Invalid SQL syntax - cannot use multiple columns in a column-level CHECK
> constraint.
>
> I don't know what this means. Can you help??
>
> Thanks once again!
>
> Marwa
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > 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
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar