IsNotNull

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

Guest

Try checking the table's default field. If it is of a number type then the
default is 0. delete the 0 and try it again.
 
In
DS said:
This IsNotNull Doesn't seem to return the MsgBox...should I be doing
something else other than IsNotNull ?

Thanks
DS

If IsNull(Me.TxtDateStart) And IsNotNull(Me.TxtDateEnd) Then
MsgBox "Date Start Empty"
ElseIf Me.TxtDateStart > Me.TxtDateEnd Then
MsgBox "Date Start > End"
ElseIf IsNull(Me.TxtTimeStart) And IsNotNull(Me.TxtTimeEnd) Then
MsgBox "Time Start Empty"
ElseIf Me.TxtTimeStart > Me.TxtTimeEnd Then
MsgBox "Time Start > End"
ElseIf IsNull(Me.TxtCheckStart) And IsNotNull(Me.TxtCheckEnd) Then
MsgBox "Check Start Empty"
ElseIf Me.TxtCheckStart > Me.TxtCheckEnd Then
MsgBox "Check Start > End"
ElseIf IsNull(Me.TxtAmountStart) And IsNotNull(Me.TxtAmountEnd) Then
MsgBox "Amount Start Empty"
ElseIf Me.TxtAmountStart > Me.TxtAmountEnd Then
MsgBox "Amount Start > End"
End If
Click to expand...

Have you defined some function named "IsNotNull"? There's no built-in
function of that name, nor any real reason to create one. I would use
"Not IsNull()" instead. For example,

If IsNull(Me.TxtDateStart) And Not IsNull(Me.TxtDateEnd) Then
MsgBox "Date Start Empty"
 
This IsNotNull Doesn't seem to return the MsgBox...should I be doing
something else other than IsNotNull ?

Thanks
DS

If IsNull(Me.TxtDateStart) And IsNotNull(Me.TxtDateEnd) Then
MsgBox "Date Start Empty"
ElseIf Me.TxtDateStart > Me.TxtDateEnd Then
MsgBox "Date Start > End"
ElseIf IsNull(Me.TxtTimeStart) And IsNotNull(Me.TxtTimeEnd) Then
MsgBox "Time Start Empty"
ElseIf Me.TxtTimeStart > Me.TxtTimeEnd Then
MsgBox "Time Start > End"
ElseIf IsNull(Me.TxtCheckStart) And IsNotNull(Me.TxtCheckEnd) Then
MsgBox "Check Start Empty"
ElseIf Me.TxtCheckStart > Me.TxtCheckEnd Then
MsgBox "Check Start > End"
ElseIf IsNull(Me.TxtAmountStart) And IsNotNull(Me.TxtAmountEnd) Then
MsgBox "Amount Start Empty"
ElseIf Me.TxtAmountStart > Me.TxtAmountEnd Then
MsgBox "Amount Start > End"
End If
 
Dirk said:
In


Have you defined some function named "IsNotNull"? There's no built-in
function of that name, nor any real reason to create one. I would use
"Not IsNull()" instead. For example,

If IsNull(Me.TxtDateStart) And Not IsNull(Me.TxtDateEnd) Then
MsgBox "Date Start Empty"
Click to expand...
Thanks,
Worked perfect!
DS
 
SteveM said:
Try: Not IsNull()

IsNotNull() isn't a function I am aware of...
Click to expand...

I'd also check that you have Option Explicit in every class module.

Keith.
 
Back
Top