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

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_nick@canada.com // my_nick = mork

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

er, show some code?

TC


"mork" <my_nick@canada.com> wrote in message
news:oprz6nseg7ttcg7w@news.ss.shawcable.net...[color=blue]
> 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_nick@canada.com // my_nick = mork[/color]

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

mork wrote:
[color=blue]
> 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?[/color]

What references to you have and what is their order?

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

>> When trying to use common functions like Left and/or Mid I get the[color=blue][color=green]
>> 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.
>>[/color]
>
> What references to you have and what is their order?
>[/color]

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_nick@canada.com // my_nick = mork

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

mork wrote:
[color=blue][color=green][color=darkred]
> >> 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.
> >>[/color]
> >
> > What references to you have and what is their order?
> >[/color]
>
> 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[/color]

Move DAO3.6 up and place below Object Library. See if that helps
[color=blue]
>
> 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_nick@canada.com // my_nick = mork[/color]

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

>> >> When trying to use common functions like Left and/or Mid I get the[color=blue][color=green][color=darkred]
>> >> 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?
>> >[/color]
>>
>> 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[/color]
>
> Move DAO3.6 up and place below Object Library. See if that helps
>[/color]

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_nick@canada.com // my_nick = mork

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

>>> >> When trying to use common functions like Left and/or Mid I get the[color=blue][color=green][color=darkred]
>>> >> 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[/color]
>>
>> Move DAO3.6 up and place below Object Library. See if that helps[/color]
>
> Woa. That did something! Sort of. So, now if I go into the module and[/color]

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_nick@canada.com // my_nick = mork