Form doesn't exist but shows in Object Library 1

[Lynne41]

Hi there

I created a test form in my Access dbase but deleted it. I now can't open any form from a command button as I get an error message "Module not found". Having looked at the Object Library my deleted form is showing there but on clicking it it says "Form_Form1 not found". I know that coz it aint there! How on earth can I delete it from the Object Library and why does it do that??

Thanks for your help

Lynne

 

[Hap007]

Dear Lynne,

I have seen this before. Sounds like access is now mad.
I am guessing that you are running Access 2000 or XP.

Anyway:
1) Open the 'bad' database, open a code window, and then go to Tools >References and make sure of what references are checked off. Now exit db.
2) Create a new blank database.
3) Import everything from the the bad db to the new db except the one bad form.
4) Now open a code window, and make sure the same references are checked off (And in same sequence)
5) Now Compile the code (You must do this) and get a good, error free compile.
6) Now, it should be good to go.

Note: In Access 2000 and XP, whenever you copy or import a form, report or module that has code with it, you must compile the 'code' or access will barf.

Good Luck,
Hap


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

-
Specializing in Access based Add-on Solutions for the Developer

 

[Lynne41]

Hap - thanks very much for replying. I had copied into a new dbase after it went haywire the first time but I have compiled as you advised. I am using Access 2000. Obviously a strange package!

Lynne