VBA functions seem to disapear or disfunction

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

ekoren

Thread Starter
Joined
Jun 2, 2002
Messages
39
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
 
Joined
Oct 3, 2002
Messages
2,281
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

Anne
Joined
Feb 14, 1999
Messages
11,746
This is clearly an Access question, so I'll move it where the Access geeks hang out. :)
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top