Invalid procedure or call argument

  • Thread starter Thread starter mgp
  • Start date Start date
M

mgp

I've been using an application for some time now but just
recently get an "Invalid procedure or call argument" when
trying to run a form. When I "ok" the error prompt, it
brings me to the code section with the Global Code window
but nothing highlighted as the problem. This application
was generated by the A2K microsoft wizard.

I don't remember changing anything recently but since I
have the error, I've tried to compile the code for one of
the forms that generates the error and it also gives me
the same error.

What do I need to do to troubleshoot this problem?

HELP!!!!

mgp
 
sounds like you have lost a reference. Open the code window with
{ALT}{F11}and open the tools menu, references submenu. look to see if
MISSING: is in front of any references. ( Be sure to note all references) If
so uncheck the reference and select it again. Else try unchecking all
references ( microsoft wont allow you to deselect two), then close the
reference dialog. reopen references and select references again. reselect
the two by navigating to the location on disk. ( when reference is selected
it shows the path at the bottom of the dialog box.) the two references are
Visual Basic for Applications and Microsoft Access (version number) Object
Library. This is a known issue and the above should fix the problem.
THT
 
William,

Thanks for your help ... unfortunately, none
had "MISSING" in front of it.

However, I tried to run the form again, the error
occured, I OK'ed the error window, the code window opened
up but this time I scrolled down all the codes. I
found "Private Sub Form_Open(Cancel As Integer)"
highlighted in yellow.

I checked the form to see if the event ON OPEN was set
and it is. If I remove the event, the form loads without
an error. If I reset the event, it errors. If I comment
out all the lines in the event, it still errors.

HELP!!
 
Back
Top