By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,562 Members | 956 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,562 IT Pros & Developers. It's quick & easy.

Invalid Procedure Call or Argument (Left, Mid, etc.)

P: n/a
I am so frustrated - any help is appreciated.

When trying to use common functions like Left and/or Mid I get the
following error:
Run-time Error '5':
Invalid Procedure Call or Argument

In my searches it appears I am not the first, but the solution seems to be
missing references. When I check my references, none are labelled as
missing. I've removed all references and re-added them and the error
persists.

I am using Access 2000 on Windows XP. I uninstalled Office 2000 and
reinstalled, but it did not resolve the issue.

Any suggestions?

--
email: my*****@canada.com // my_nick = mork
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies

P: n/a
TC
er, show some code?

TC
"mork" <my*****@canada.com> wrote in message
news:op**************@news.ss.shawcable.net...
I am so frustrated - any help is appreciated.

When trying to use common functions like Left and/or Mid I get the
following error:
Run-time Error '5':
Invalid Procedure Call or Argument

In my searches it appears I am not the first, but the solution seems to be
missing references. When I check my references, none are labelled as
missing. I've removed all references and re-added them and the error
persists.

I am using Access 2000 on Windows XP. I uninstalled Office 2000 and
reinstalled, but it did not resolve the issue.

Any suggestions?

--
email: my*****@canada.com // my_nick = mork

Nov 12 '05 #2

P: n/a
mork wrote:
I am so frustrated - any help is appreciated.

When trying to use common functions like Left and/or Mid I get the
following error:
Run-time Error '5':
Invalid Procedure Call or Argument

In my searches it appears I am not the first, but the solution seems to be
missing references. When I check my references, none are labelled as
missing. I've removed all references and re-added them and the error
persists.

I am using Access 2000 on Windows XP. I uninstalled Office 2000 and
reinstalled, but it did not resolve the issue.

Any suggestions?


What references to you have and what is their order?
Nov 12 '05 #3

P: n/a
>> When trying to use common functions like Left and/or Mid I get the
following error:
Run-time Error '5':
Invalid Procedure Call or Argument
I am using Access 2000 on Windows XP. I uninstalled Office 2000 and
reinstalled, but it did not resolve the issue.


What references to you have and what is their order?


Visual Basic for Applications
Microsfot Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
Microsoft DAO 3.6 Object Library
Microsoft Outlook 9.0 Object Library

The app does some work with Outlook automation objects, etc. etc. It all
worked just dandy in the past. Cam back to it after a while to add some
functionality and this error started cropping up (I had not edited
references of any sort. I haven't had a chance yet to try this on another
system.. I assume it's a system problem moreso than a code error.)

Code that had been working is now also failing with that error.
Specifically on Left(..) and Mid(..) function calls.

--
email: my*****@canada.com // my_nick = mork
Nov 12 '05 #4

P: n/a
mork wrote:
When trying to use common functions like Left and/or Mid I get the
following error:
Run-time Error '5':
Invalid Procedure Call or Argument
I am using Access 2000 on Windows XP. I uninstalled Office 2000 and
reinstalled, but it did not resolve the issue.

What references to you have and what is their order?


Visual Basic for Applications
Microsfot Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
Microsoft DAO 3.6 Object Library


Move DAO3.6 up and place below Object Library. See if that helps

Microsoft Outlook 9.0 Object Library

The app does some work with Outlook automation objects, etc. etc. It all
worked just dandy in the past. Cam back to it after a while to add some
functionality and this error started cropping up (I had not edited
references of any sort. I haven't had a chance yet to try this on another
system.. I assume it's a system problem moreso than a code error.)

Code that had been working is now also failing with that error.
Specifically on Left(..) and Mid(..) function calls.

--
email: my*****@canada.com // my_nick = mork


Nov 12 '05 #5

P: n/a
>> >> When trying to use common functions like Left and/or Mid I get the
>> following error:
>> Run-time Error '5':
>> Invalid Procedure Call or Argument
>>
>>
>> I am using Access 2000 on Windows XP. I uninstalled Office 2000 and
>> reinstalled, but it did not resolve the issue.
>>
>
> What references to you have and what is their order?
>


Visual Basic for Applications
Microsfot Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
Microsoft DAO 3.6 Object Library


Move DAO3.6 up and place below Object Library. See if that helps


Woa. That did something! Sort of. So, now if I go into the module and
hit F5 to run it, it works. If I execute from within the app (this
particular case I'm testing is a menu item running a macro which executes
a function) it still errors out. I'm going to keep experimenting here
right now. I'll let you know if I make any progress.

email: my*****@canada.com // my_nick = mork
Nov 12 '05 #6

P: n/a
>>> >> When trying to use common functions like Left and/or Mid I get the
>> following error:
>> Run-time Error '5':
>> Invalid Procedure Call or Argument
>>
>>
>> I am using Access 2000 on Windows XP. I uninstalled Office 2000 and
>> reinstalled, but it did not resolve the issue.
>>
>
> What references to you have and what is their order?
>

Visual Basic for Applications
Microsfot Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
Microsoft DAO 3.6 Object Library


Move DAO3.6 up and place below Object Library. See if that helps


Woa. That did something! Sort of. So, now if I go into the module and


Well, I was sorta wrong when I got excited there in my testing, what I did
realize is that the functions were working in a different mdb.

which got me to wondering.. what makes this one unique? Nothing as far
as I was concerned.. but it was somehow related to this particular file.
Did a good ol' "compact and repair" and the problem seems to have vanished.

Thank you very much for taking the time to respond and help me out.

P.S. U N Me, I think someone has taken to immitating you elsewhere in
this newsgroup.. posting innapropriate links and such. Just a heads up -
in general I'd say to ignore him/her and it'll go away.

--
email: my*****@canada.com // my_nick = mork
Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.