[AccessD] Syntax question

No problem, makes a change helping someone on the list....lol
Paul




Message date : Dec 17 2003, 03:00 PM
>From : Christian, Lorraine 
To : Access Developers discussion and problem solving 
Copy to : 
Subject : RE: [AccessD] Syntax question
Brett and Paul,

Thank you two very much! That did the trick.

Have a great Holiday!..... :)

Lorraine

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Brett Barabash
Sent: Wednesday, December 17, 2003 9:49 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Syntax question


That should be:
If cmdPositiveEmail.Enabled = True And IsNull(txtEmailDate.Value) = True
Then
...


-----Original Message-----
From: Christian, Lorraine [mailto:LChristian at massmutual.com]
Sent: Wednesday, December 17, 2003 8:45 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Syntax question


Good morning,

I can't figure this out.

Private Sub cmdNew_Click()
If cmdPositiveEmail.Enabled = True And txtEmailDate.Value = Null Then
MsgBox "You must send an email before leaving this record." &
vbNewLine & _
"To send an email, click the email button."
Else
Call adhNavNew([Form])
End If

End Sub

On the above event even though cmdPositiveEmail.Enabled = True And
txtEmailDate.Value = Null 
the routine pops to the else portion of this event. Can someone direct me
on what maybe wrong?

Thanks

Lorraine




---------------------------------------------------------
This e-mail transmission may contain information that is proprietary,
privileged and/or confidential and is intended exclusively for the person(s)
to whom it is addressed. Any use, copying, retention or disclosure by any
person other than the intended recipient or the intended recipient's
designees is strictly prohibited. If you are not the intended recipient or
their designee, please notify the sender immediately by return e-mail and
delete all copies. 

---------------------------------------------------------
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--------------------------------------------------------------------------------------------------------------------
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed.
If you have received this email in error please notify the
originator of the message. This footer also confirms that this
email message has been scanned for the presence of computer viruses.

Any views expressed in this message are those of the individual
sender, except where the sender specifies and with authority,
states them to be the views of Tappe Construction Co.

Scanning of this message and addition of this footer is performed
by SurfControl E-mail Filter software in conjunction with 
virus detection software.

_______________________________________________
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
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
www.freeserve.com/anytime