Module not found

[Flynny]

G'day,

I have created a fairly big access database, but only through the use of
Microsoft Access for Dummies and the occasional visit to here. So basically I
know nothing about what happens behind the scenes.

I have created forms with command buttons, that when clicked either close
the form i'm viewing or open another form which is filtered to the relevant
record I am viewing.

I have now created a new form and added command buttons to that form, but
when clicking those buttons to open another related form I get a message
saying "module not found" and then taken to a strange screen. When I go back
to my existing forms where command buttons where already in existence and
working and then click those buttons I again get the message "module not
found". By not saving the changes to the new form and then closing and
reopening my database, the existing forms and their command buttons are
working again, but the same thing re-occurs everytime I try to add a new
command button (whether it be on a new form or existing form).

As mentioned I'm a bit like Sgt Shultz here on the behind the scenes stuff,
so please make your answers as idiot proof as possible.

Cheers,

 

[Arvin Meyer [MVP]]

Your database is probably corrupted.

First make a copy of your database file. Next do a repair and compact on the
copy (Tools ... Database Utilities ... Compact and Repair)

Make a new empty database and import the objects, with the exception of the
offending form. Try importing the offending form, and if you have any
trouble, just recreate it. Compile your database by going to any code window
and choosing Debug ... Compile from the menu.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com