Format([Hours] * -1,"Fixed") ERROR

  • Thread starter Thread starter Andre Uys
  • Start date Start date
A

Andre Uys

Good day,
I have a time and attendance database that holds hours for
employees in a Single Number field.

Using a query, I convert all the negative values to a positive value. The
hours are in decimal values I.g. 30 minutes = 0.50 hours.

Using format([Hours] * -1,"0#.00") to convert the negative values to
positive values, I get the following error:

Runtime Error 3075, Function is not available in query expression
'Format([Hours]*-1,"Fixed)'.

This application runs on several Win98 PC's and only one PC has this
problem. We re-installed access but the problem remains.

I guess this has something to do with a bad Reference after reading some
posts here.

Could this be the problem? (I am not at the office now and will only be able
to check the PC in question on Monday)

I originally thought that the format function was a core function in Access
and that it would not require a specific Reference DLL to enable the use of
it, and hence never even checked it while back at the office.

Also, what would be the best way of determining which function belong to
what DLL ?

PS Why is my format changed by Access from "0#.00" to "Fixed" ?

Thank you in advance

Andre
 
Runtime Error 3075, Function is not available in query expression
'Format([Hours]*-1,"Fixed)'.

This application runs on several Win98 PC's and only one PC has this
problem. We re-installed access but the problem remains.

I guess this has something to do with a bad Reference after reading some
posts here.
Click to expand...

Almost certainly so.

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.
 
Thanks John, I will give it a try and advise if it does not work, but what
you recommended makes sense

Andre
John Vinson said:
Runtime Error 3075, Function is not available in query expression
'Format([Hours]*-1,"Fixed)'.

This application runs on several Win98 PC's and only one PC has this
problem. We re-installed access but the problem remains.

I guess this has something to do with a bad Reference after reading some
posts here.
Click to expand...

Almost certainly so.

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
.DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.
Click to expand...
 
Back
Top