VBA functions seem to disapear or disfunction

[ekoren]

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

 

[AbvAvgUser]

I am neither a MS Office expert nor VBA expert.

Some .dll file containing the codes of these functions must have been corrupted.

There is a repair function in Access 2000 under the Help menu. Try that. It may repair or replace the corrupted .dll file.

If repair doesn't solve ir, triy to uninstall and re-install Office XP. That may solve it.

Hope your Anti-Virus is updated and you have checked your system for viruses.

 

[Anne Troy]

This is clearly an Access question, so I'll move it where the Access geeks hang out.