Hi guys,
This is a very frustrating problem. An Access Query that I've written that accesses a method in a module has stopped working, for no apparent reason. Previously, it was working just fine - I haven't changed any of the parameters or values being placed into the methods. Now, whenever I try to run it, I get the message "Compile error in query expression".
Does anyone know what might be causing this? Has anyone here had a problem like this before?
Thanks
EDIT: Problem solved - I was assigning a value to a variable outside one of the methods - D'oh!![]()


Reply With Quote