Error loading form_location when I open my Menu form

[vivasuzi]

Hello,

I made this database in Access 2000. We now have Access 2003, and now I have problems.

When I open my database, the startup form is the Menu. It just has a bunch of buttons on it. When the menu opens it says:

Box Title: Microsoft Visual Basic

Box Text: An error occurred while loading 'Form_Location'. Do you want to continue loading the project?

I say Yes, the form loads, but every single button (in the entire database) now gives the error "Invalid procedure call or argument"

Does anyone have a clue what is going on? I have another Access 2000 database with buttons and macros that works fine in Access 2003. Any help is appreciated!!!

*Suzanne*

http://www.vivasuzi.com

 

[PHV]

Check the references:
when in VBE (Alt+F11) menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[vivasuzi]

Ok, more info. I soon realized that I have a form named Location, so VBA was referring to that form. So I went to VBA, and under Form_Location, all my buttons code was gone! I tried to edit it, but it seems there's some kind of error. So I copied the form, and deleted the one that had the error.

Now there are no errors but I have to redo all my buttons. Is there anyway to run the button wizard without having to make a new button? I'd much prefer to leave all my buttons as they are all already designed and run the wizard to change the events. Any suggestions?

*Suzanne*

http://www.vivasuzi.com

 

[vivasuzi]

btw - thanks for the quick response!

*Suzanne*

http://www.vivasuzi.com