Help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to build an expression. I have one froma previous post but I
don't know what I am doing wrong. I tried to build one from scratch but I
still cant figure it out. Her is what I built from scratch

If Is Not Null [ me.SABC]then me.SABC <Date then Msgbox"Must be Retrained!"
End If

Here is what someone else offered me as code

If Not IsNull(Me.NameOfDateField) then
If me.NameOfDateField < Date then
Msgbox "The Biology exam date is past due!"
End IF
End If

Can't firgure this crap out and I need to get this project done today!
 
Hi

If Not IsNull(Me.NameOfDateField) then
If me.NameOfDateField < Date then
Msgbox "The Biology exam date is past due!"
End IF
End If

This means
If there is nothing in the Datefield then do nothing
If there is something in the Datefield then check to see if the contents of
the Datefield are before todays date (I assume that you Datefield contains a
time/date). If they are then display the message ""The Biology exam date is
past due!"

To use this code follow the instrcutions I gave this morning

Hope this helps
 
I did write a more detailed post here but I have just deleted it. My
grandmother always told me "if you have nothing nice to say - don't say
anything".

I will leave one section here for you.

What is the point of asking a number of questions and then not even
bothering to answer any of them when you are offered assistance, except with
another question and with no acknowledgment of the assistance?
 
Back
Top