John,
you are right. I put the validation rule in the form instead of the table, and it worked. Thank you so much for your help. You are my angel :)
Marwa
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Marwa-
>
> What are the other date fields? If there are lots of them, maybe they should be
> in another table.
>
> An alternative is to NOT do the validation in the table but to use the Before
> Update event of the form you provide to enter the data. You can do all the
> validation you want there and Cancel the edit if something fails.
>
> 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 3:07 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Validation Rule for Date
>
> 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
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar