Query conversion function problem in Access, please help.

[Clipper2000]

Hi there,

I used to be able to use function like this in my queries:

Cstr(), Clng() etc.

Then suddenly Access tells me compile error where time I run a query with these function(s) on.

Is there something in the options I can set to restore this?

Thanks.

 

[PHV]

Check your references:
while in VBE (Alt+F11), menu Tools -> References ...
You may also consider compiling the database (menu Debug).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Clipper2000]

Thanks PHV. It worked !