[AccessD] = NULL

Oleg:

You might also try IsDate(txtStartDate) and error message read date is
missing or invalid.  This would catch both missing and invalid dates.


Rocky

----- Original Message ----- 
From: <Oleg_123 at xuppa.com>
To: <accessd at databaseadvisors.com>
Sent: Friday, February 06, 2004 1:29 PM
Subject: Re: [AccessD] = NULL


> thank you :--)
>
> >
> > try
> >
> > If isnull(txtStartDate) Then
> >     MsgBox "Please fill in the required dates", , "dates missing"
> >     Exit Sub
> > End If
> >
> >
> >
> >                     Oleg_123 at xuppa.com
> >
> >                  Sent by:
> > To:     accessd at databaseadvisors.com
> >
> > accessd-bounces at databasead       cc:
> >
> >                  visors.com
> > Subject:     [AccessD] = NULL
> >
> >
> >
> >                     02/06/2004 02:49 PM
> >
> >                  Please respond to "Access
> >
> >                                   Developers
> > discussion and
> >
> >       problem solving"
> >
> >
> >
> >
> >
> >
> >
> >
> > I know i am not suppose to write = Null, but is null doesn't work
> > either, whats the correct coding ?
> >
> > If txtStartDate.Value = NULL Then
> >     MsgBox "Please fill in the required dates", , "dates missing"
> >     Exit Sub
> > End If
> >
> >
> >
> > -----------------------------------------
> > Get Breaking News from CNN, ABC, NBC, CBS Now.
> > http://www.xuppa.com/news/?link=webmail
> >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
> >
> >
> >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
>
>
>
> -----------------------------------------
> Get Breaking News from CNN, ABC, NBC, CBS Now.
> http://www.xuppa.com/news/?link=webmail
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com