Rounding error message

G

George Schneider

I get an error message when I try to use the built in round function on a field. The error I get is a compile erro rin express ion Round([wks],2).Why is this.
 
J

John Vinson

I get an error message when I try to use the built in round function on a field. The error I get is a compile erro rin express ion Round([wks],2).Why is this.
Click to expand...

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.
 

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

Compile error in table level validation expression in ms access office 2019 0
Round up or down to nearest 5, but not 10 2
MS Project - error message when checking "Critical tasks" 1
Macro warning in word 1
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
"Compile error in table level validation expression " after format 0
Rounding number 15
Round DOWN in Access 3

Top