Access 2000 BUG

[Rob]

All of the sudden, for no reason at, all some string functions do not
work....

I know the expressions are valid, but I am getting a error message stating
that...
"The expression you entered contains invalid syntax. You omitted an operand
or operator, you entered an invalid character or comma, or you entered text
without surrounding it in quotation marks."

Any ideas ? I Tried re-installing, no help.

 

[Chris Mills]

It's not a known Access2000 bug, after 6 years. (it came out in 1999!)
(though Access2000 was a bit flakey)

Your first sentence suggests a References problem.
But that would be a reason, and you said "no reason at all".
Where is this expression? If in code, does it compile?
Does such an expression typed in Debug work?

Chris

 

[Rob]

Hi Chris,

Used the expression as a field in a query...
For example... Expression1:Mid$([ColumnA],1,6)
I did check the References... nothing was missing.
The formula is correct... worked on another machine ok...

Thanks,
Rob