Run-time Error 5 "Invalid Procedure Call or Argument"

[Terri]

I have been having a recurring problem with this error, which is occurring on
several lines of code in serveral databases at work. What is most strange is
that the code always runs without error on my computer, but it does on other
ones. Now it’s popping up on our brand new laptop for a new database I’ve
recently created which again, has been working perfectly on my computer.

We have done numerous comparisons between the other computers and mine –
same versions of Access, same service pack updates, (2003 SP3) same version
of Visual Basic, same Library References, same version of Windows (XPPro)...
and we can’t seem to figure out why the code runs without error on my
computer and not on others.

We’ve also checked permissions – I’ve gone to other computers and logged in
and gotten the error on other computers, and others have logged into my
computer and not gotten the error. So it MUST be something to do with my PC,
but I’m not sure what else to check. Very baffled and starting to despair
about this :-0

Any ideas?

 

[Dirk Goldgar]

I have been having a recurring problem with this error, which is occurring
on
several lines of code in serveral databases at work. What is most strange
is
that the code always runs without error on my computer, but it does on
other
ones. Now it’s popping up on our brand new laptop for a new database I’ve
recently created which again, has been working perfectly on my computer.

We have done numerous comparisons between the other computers and mine –
same versions of Access, same service pack updates, (2003 SP3) same
version
of Visual Basic, same Library References, same version of Windows
(XPPro)...
and we can’t seem to figure out why the code runs without error on my
computer and not on others.

We’ve also checked permissions – I’ve gone to other computers and logged
in
and gotten the error on other computers, and others have logged into my
computer and not gotten the error. So it MUST be something to do with my
PC,
but I’m not sure what else to check. Very baffled and starting to despair
about this :-0

Any ideas?

Is it a particular block of code? Can you narrow it down to a particular
statement? Post the code, if you can.