Disappearing Forms

Hello and thanks for any help on this as it has now happened twice.

I have created a new database in Access 2000. I have imported some
tables and forms from an older database. I have made some changes to
the forms. Things seem to work fine. Sometimes I mess up with VBA cose
and it locks up. I close Access and then re-open the database.... most
of the Forms I had are missing ... yet, the underlying VBA designer
still shows the code for them. If I try and re-create the form, it
won't allow me to use the same name. If I try to re-import it, that
one disappears also. F5 does not do anything. The forms are not
hidden. Compact and repair does not help.

I've re-created from scratch twice now .... what a waste of a lot of
time... HELP please.

Guess I should mention I am using Access 2003 SP3 and working with an
Access 2000 file format.

That is corruption of the database. See this link about recovering from
corruption.
http://www.allenbrowne.com//recover.html



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"SilvrT" wrote in message
...
Hello and thanks for any help on this as it has now happened twice.

I have created a new database in Access 2000. I have imported some
tables and forms from an older database. I have made some changes to
the forms. Things seem to work fine. Sometimes I mess up with VBA cose
and it locks up. I close Access and then re-open the database.... most
of the Forms I had are missing ... yet, the underlying VBA designer
still shows the code for them. If I try and re-create the form, it
won't allow me to use the same name. If I try to re-import it, that
one disappears also. F5 does not do anything. The forms are not
hidden. Compact and repair does not help.

I've re-created from scratch twice now .... what a waste of a lot of
time... HELP please.

On Nov 17, 11:58*am, "Jeanette Cunningham"
wrote:
That is corruption of the database. See this link about recovering from
corruption.http://www.allenbrowne.com//recover.html

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"SilvrT" wrote in message

...



Hello and thanks for any help on this as it has now happened twice.

I have created a new database in Access 2000. I have imported some
tables and forms from an older database. I have made some changes to
the forms. Things seem to work fine. Sometimes I mess up with VBA cose
and it locks up. I close Access and then re-open the database.... most
of the Forms I had are missing ... yet, the underlying VBA designer
still shows the code for them. If I try and re-create the form, it
won't allow me to use the same name. If I try to re-import it, that
one disappears also. F5 does not do anything. The forms are not
hidden. Compact and repair does not help.

I've re-created from scratch twice now .... what a waste of a lot of
time... *HELP please.- Hide quoted text -

- Show quoted text -

Thanks... didn't work :-(

SilvrT wrote:
"most of the Forms I had are missing ... yet, the underlying VBA designer
still shows the code for them."

This really makes no sense, as written. How can the code in the form's module
be visible if the form itself is missing?

Perhaps if you explained exactly what you mean by "missing."

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200911/1

Sorry to hear that you the recovery process didn't work for you.
When this happens, go back to the most recent backup before the corruption,
you have been keeping regular backups haven't you?



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"SilvrT" wrote in message
...
On Nov 17, 11:58 am, "Jeanette Cunningham"
wrote:
That is corruption of the database. See this link about recovering from
corruption.http://www.allenbrowne.com//recover.html

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"SilvrT" wrote in message

...



Hello and thanks for any help on this as it has now happened twice.

I have created a new database in Access 2000. I have imported some
tables and forms from an older database. I have made some changes to
the forms. Things seem to work fine. Sometimes I mess up with VBA cose
and it locks up. I close Access and then re-open the database.... most
of the Forms I had are missing ... yet, the underlying VBA designer
still shows the code for them. If I try and re-create the form, it
won't allow me to use the same name. If I try to re-import it, that
one disappears also. F5 does not do anything. The forms are not
hidden. Compact and repair does not help.

I've re-created from scratch twice now .... what a waste of a lot of
time... HELP please.- Hide quoted text -

- Show quoted text -

Thanks... didn't work :-(

On Nov 17, 4:54*pm, "Linq Adams via AccessMonster.com" u28780@uwe
wrote:
This really makes no sense, as written. How can the code in the
form's module
be visible if the form itself is missing?

Perhaps if you explained exactly what you mean by "missing."
__________________________________________________ ____

Of course it makes no sense .. that's why I am here asking for help.

"missing" means exactly that .... I had 7 different forms that I'd
imported from an older database. I made code some changes and during
that time, the code "bombed" because I made a mistake in typing. I had
to close Access and when I reopened it, only one of the 7 forms was
still there ... yet in the VBA screen, I could still see the code for
the forms ... makes no sense... yep, you got that right!

On Nov 18, 2:09*am, "Jeanette Cunningham"
wrote:
Sorry to hear that you the recovery process didn't work for you.
When this happens, go back to the most recent backup before the corruption,
you have been keeping regular backups haven't you?

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"SilvrT" wrote in message

...
On Nov 17, 11:58 am, "Jeanette Cunningham"





wrote:
That is corruption of the database. See this link about recovering from
corruption.http://www.allenbrowne.com//recover.html

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"SilvrT" wrote in message

...

Hello and thanks for any help on this as it has now happened twice.

I have created a new database in Access 2000. I have imported some
tables and forms from an older database. I have made some changes to
the forms. Things seem to work fine. Sometimes I mess up with VBA cose
and it locks up. I close Access and then re-open the database.... most
of the Forms I had are missing ... yet, the underlying VBA designer
still shows the code for them. If I try and re-create the form, it
won't allow me to use the same name. If I try to re-import it, that
one disappears also. F5 does not do anything. The forms are not
hidden. Compact and repair does not help.

I've re-created from scratch twice now .... what a waste of a lot of
time... HELP please.- Hide quoted text -

- Show quoted text -

Thanks... didn't work *:-(- Hide quoted text -

- Show quoted text -

Regular backups??? geeeesh, I had only been making changes for 20
minutes. It took 2 minutes to import the 7 forms and I spent 10-15
minutes making some code adjustments ... nobody I know will backup in
that short of a time span.

Anyhoo ... I have started over ... for the 3rd time .... seems to be
going ok so far.

Thanks for all the suggestions.

Lots of experienced developers will back up in that time frame.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"SilvrT" wrote in message
...
On Nov 18, 2:09 am, "Jeanette Cunningham"
wrote:
Sorry to hear that you the recovery process didn't work for you.
When this happens, go back to the most recent backup before the
corruption,
you have been keeping regular backups haven't you?

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"SilvrT" wrote in message

...
On Nov 17, 11:58 am, "Jeanette Cunningham"





wrote:
That is corruption of the database. See this link about recovering from
corruption.http://www.allenbrowne.com//recover.html

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"SilvrT" wrote in message

...

Hello and thanks for any help on this as it has now happened twice.

I have created a new database in Access 2000. I have imported some
tables and forms from an older database. I have made some changes to
the forms. Things seem to work fine. Sometimes I mess up with VBA cose
and it locks up. I close Access and then re-open the database.... most
of the Forms I had are missing ... yet, the underlying VBA designer
still shows the code for them. If I try and re-create the form, it
won't allow me to use the same name. If I try to re-import it, that
one disappears also. F5 does not do anything. The forms are not
hidden. Compact and repair does not help.

I've re-created from scratch twice now .... what a waste of a lot of
time... HELP please.- Hide quoted text -

- Show quoted text -

Thanks... didn't work :-(- Hide quoted text -

- Show quoted text -

Regular backups??? geeeesh, I had only been making changes for 20
minutes. It took 2 minutes to import the 7 forms and I spent 10-15
minutes making some code adjustments ... nobody I know will backup in
that short of a time span.

Anyhoo ... I have started over ... for the 3rd time .... seems to be
going ok so far.

Thanks for all the suggestions.

Another thing to try is to make a backup and close Access.
Sometimes closing Access and restarting it helps.

I suggest to import only 1 form to start with.
Make your changes and make backups.

It is possible that only one of the forms you imported is causing this
problem. If you do it one form at a time, you may be able to pick which form
is giving the problems.

Also check that you have the correct references set to suit all references
needed by the imported forms as well any public functions or subs needed by
the imported forms .


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia



"SilvrT" wrote in message
...
On Nov 17, 4:54 pm, "Linq Adams via AccessMonster.com" u28780@uwe
wrote:
This really makes no sense, as written. How can the code in the
form's module
be visible if the form itself is missing?

Perhaps if you explained exactly what you mean by "missing."
__________________________________________________ ____

Of course it makes no sense .. that's why I am here asking for help.

"missing" means exactly that .... I had 7 different forms that I'd
imported from an older database. I made code some changes and during
that time, the code "bombed" because I made a mistake in typing. I had
to close Access and when I reopened it, only one of the 7 forms was
still there ... yet in the VBA screen, I could still see the code for
the forms ... makes no sense... yep, you got that right!