HELP: Invalid of Unqualified Reference

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed Landau - 29 Aug 2004 23:57 GMT

I'm running Office 2003 on Windows XP SP2.
I just went to the Office Update site and did an update.
Now, When I try to open my custom form in Access, I get the error shown in
the title of this message.
The Microsoft knowledge Base articels instructs me to look for a <missing>
reference in my Tools -> Reference, but nothing is missing (I unchecked most
and rechecked them).

Access is not telling my WHERE the error is.... but simply that there IS an
error. I get it when I opent the form, and when I try to do click ANY
buttons.

OK... there is only 1 reference in the form_load proc. I unchecked that
reference. I then went to re-enable it and it was there in the list so I
assume it is present.

Can anyone help?

Thanks
-Ed

Reply to this Message

Douglas J. Steele - 30 Aug 2004 00:59 GMT

What happens when you attempt to compile your application (first item on the
Debug menu when you're in the Visual Basic Editor)? That should help you
find where the error actually is.

When you unchecked the references, did you close the dialog and then go back
into it before rechecking them?

I'm not sure what you mean that there is only 1 reference in the form_load
proc.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I'm running Office 2003 on Windows XP SP2.
> I just went to the Office Update site and did an update.
[quoted text clipped - 16 lines]
> Thanks
> -Ed

Reply to this Message

Ed Landau - 30 Aug 2004 01:46 GMT

THANK YOU THANK YOU THANK YOU THANK YOU !!!

"Compiling" showed me where the error was. I guess I've never actually
compiled my code. I always thought VB was interpreted so never even thought
about looking for a "compile" option.

For some reason a pound sign (#) ended up in front of a line of code...
which would explain why I was getting errors.

THANKS AGAIN FOR THE FAST REPLY. I hope I can help someone else like you
just helped me !!

-Ed

> What happens when you attempt to compile your application (first item on the
> Debug menu when you're in the Visual Basic Editor)? That should help you
[quoted text clipped - 28 lines]
> > Thanks
> > -Ed

Reply to this Message