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"
 
Try: Not IsNull()

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

Steve
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

code will run using And IsNotNull 2
Help with If statement 17
validation rule - IsNotNull 4
Cond. Formatting w/ DLookup 18
Listbox Image 3
Increment a Short Time Field by 15 minutes 2
How do i do a notnull statement? (If (IsNotNull(..) Then ...) 4
BeforeUpdate 1

Back
Top