Failure message -
03-02-2011
, 10:01 AM
I'm getting a message: "The expression you entered has a function name
that Microsoft Access can't find." Access help says nothing about
this message that I can find.
The message appears when I'm running a macro. The condition statement
of the macro is: IsNull([problem]) and the Macro Action is MsgBox.
When I run the macro in single step mode, it fails when
IsNull([problem]) should be the action, but the sample for writing a
conditional macro shows that as the exact text. My goal is to prevent
users from entering duplicate "problems", so I wanted this macro to
first detect the duplication, then flash a message referring the user
to the previously entered "problem". Any help would be appreciated.
By the way, I don't write code, I just use queries and macros. Nance |