compile error - module not found

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone help please - I seem to have a corruption - Access is looking for
Form1 which doesn't seem to exist - the error occurs continually and opens
the code window which also has the name Form-Form1 - As I don't know where
this is I can't delete it - if anyone can help I would be very grateful
 
Yep, sounds like corruption. I would try in this order:
1. Compact and Repair
If that doesn't work
2. DeCompile
Start-->Run, Then type in
msaccess /decompile "C:\Documents and Settings\Bozo\My
Documents\DatabaseName.mdb"
Compact and Repair again
If that doesn't work we are down to the ugly and tedious
3. Copy all your modules to text files
For Form and Reports that Have modules, after copying their modules to
text, Set thier Has Module property to No
Create a New Database
Copy all the objects from the old database to the new
Paste in your standard modules
Open each form and report that had a module in design view
Click on the Code icon
Paste the original code back in place
Compile your database
Compact and Repair
Make a donation to a worthy charity and pray.
 
Thanks for your assistance Klatuu

I managed to sort out my problem I think - a module was looking for Form1
which didn't exist - so I created it - now it seems to be OK - I will keep
your recomendations for my future reference as I have been corrupted before
and had to start again - Many thanks for your prompt reply and assistance

Atlas
 
Back
Top