I created a database, thought all was fine until I quit it and opened it
again. The VB wouldn't run, I couldn't open the editor from design view
of any form, and when I tried to open it through the menu, all I would
get is a corrupted window (no scroll up button, no way to access the
Project Explorer) containing just the one module I had, but I couldn't
get to the Class Objects.
I tried to compact and repair it, and decompile (that crashed Access).
I then made a copy, set the Has Module property for all forms to No,
imported everything into a new database, and wrote the code again (this
time I exported all the class objects and the module before quitting in
case I need them later). It was working fine until I quit it and opened
it up again.
Something else I tried (well I've tried all sorts of things) was to
import just the tables and queries into a new database, create new
forms, and copy and past the form objects on to them. I then copied and
pasted the script back into the Class Objects. I thought there might
have been something that was corrupted in one of the forms, and this was
a way to avoid it. No joy.
From much playing, I've come to the conclusion (I think) that if I
import anything from this database into a new one, it will screw up the
new one in the same manner.
What's left to try? I'm not starting again so I'm prepared to give this
up, it was just a more improved version of an already existing database
I'm using personally - for me only, in my job.
Thanks in advance.
