Forms not being recognised

[Deborah Benham]

Would appreciate some help:

For some reason my Access database will now not load
properly. Nothing seemed to happen inbetween openings, it
was just okay one minute and not the next. When I opened I
got this message:

1 errors occured when you loaded the form or report.

You loaded a form or report that NameOfDB doesnt recognise
and will ignore.

So, I went into the database bypassing the switchboard and
tried to open the switchboard form from within the
database. This gave the following error message:

The form name "Switchboard" is mispelled or doesn't exist.

So I reasoned that somehow it couldn't now find the
Switchboard form and so I deleted the one that was there
and tried to create a new one based on the table of
Switchboard items that was there. This gave me the
following message:

Undefined function "is numeric" in expression.
Invalid use of Null.

I'm also finding that I cannot view the code behind either
the switchboard or any other form. The error message
given is:

"Invalid Data Format"


It looks like somehow its got corrupted. I've done a lot
of work since the last copy, so would appreciate any ideas
how I could fix this one easily.

Thanks

Deborah
Wellington, New Zealand

 

[Nikos Yannacopoulos]

Deborah,

Open the database bypassing the switchboard and any startup macro / code (by
holding down the Shift key while you open it), and try to compact and repair
it (Tools > Database Utilities > Compact and Repair database). With some
luck it will work. Just to be on the safe side, that is to be able to take
the next step if this fails catastrophically, make a back-up copy of it
before you do.
Failing this, make a new, blank database and import all objects (tables,
queries, forms, reports, macros, code modules) form the old database (File >
Get External Data > Import). You stand a good chance that the new .mdb will
work.
(Even if a plain compact and repair solves the problem, it's not a bad idea
to produce a new, clean copy by following the second suggestion on the
repaired .mdb!)

HTH,
Nikos