i have this VBA program (on access in office XP). Now, when i try to activate some string handling functions like Split or Replace (full name VBA.Split, VBA.Replace) the debugger stops in their lines with the next error message:
"invalid procedure call or argument"(run-time error #5)
i tried to perform several watches on these functions, but it always presented the same message, no matter what arguments i entered. the weirdest thing of all in here, that sometimes after i restarted my computer and tried it on again, it worked just fine, but today even that doesn't seem to help.
I have also checked the VBA references, and all that is needed is in there, and i can also see these functions and their details in the object browser.
any ideas how i can bring back to life those functions?
ekoren
"invalid procedure call or argument"(run-time error #5)
i tried to perform several watches on these functions, but it always presented the same message, no matter what arguments i entered. the weirdest thing of all in here, that sometimes after i restarted my computer and tried it on again, it worked just fine, but today even that doesn't seem to help.
I have also checked the VBA references, and all that is needed is in there, and i can also see these functions and their details in the object browser.
any ideas how i can bring back to life those functions?
ekoren