Runtime error

[ChristieB]

I am using a module called TimeToDec to convert a time like: 10:00 Pm to 10
for the purpose of multiplying it with another value to get a dollar amount
for hours worked*pay rate=amount owed. This is taking place in a form and as
I step through the EmployeeID field, I am getting a: Microsoft Visual Basic
RunTime error '94': Invalid use of null. My options are to debug or end.
Does anyone know how to fix this? Thanks

 

[Jerry Whittle]

Check the underlying data at table level. You probably have null values in
the field that TimeToDec uses in some records. TimeToDec probably doesn't
know how to handle null values or something within it takes a time, such as
midnight, and turns it into a null.

You either need to have TimeToDec handle nulls or make sure each record has
a value that TimeToDec to handle.