Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / December 2005

Tip: Looking for answers? Try searching our database.

compile error - module not found

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Atlas - 12 Dec 2005 19:32 GMT
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
Klatuu - 12 Dec 2005 21:06 GMT
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.

> 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
Atlas - 13 Dec 2005 13:37 GMT
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

> Yep, sounds like corruption.  I would try in this order:
> 1. Compact and Repair
[quoted text clipped - 22 lines]
> > 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
Klatuu - 13 Dec 2005 13:51 GMT
I have been corrupted for years! (and proud of it)

> Thanks for your assistance Klatuu
>
[quoted text clipped - 31 lines]
> > > 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.