Disappearing Forms

[SilvrT]

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.

 

[SilvrT]

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

 

[Jeanette Cunningham]

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]

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








- Show quoted text -

Thanks... didn't work :-(

 

[Linq Adams via AccessMonster.com]

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."

 

[Jeanette Cunningham]

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

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








- Show quoted text -

Thanks... didn't work :-(

 

[SilvrT]

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!

 

[SilvrT]

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







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.

 

[Jeanette Cunningham]

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


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

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







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.

 

[Jeanette Cunningham]

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



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!

 

[SilvrT]

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

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

That may well be true; however, as a professional "experienced
developer" in MS Access & VBA for some 15 years now, I rarely backup
my work that often, if ever... Backing up the entire database in 20
minute intervals ??? sorry ... I find that a hard one to
believe ... This thing I reported I have never seen before. Certainly
appears to be a BUG in Access 2003.

Thanks again... seems there is no CLEAR explanation for this as
everyone is offering "try this... or try that...".. most of which I've
done.

 

[SilvrT]

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

Thanks, however some forms are dependant on others being there in
order for the changes to be tested. For the most part, this is what I
have been doing ... I will import only those forms that are directly
"connected" ... make my vb code change and test. I don't think any one
form caused this problem ... it was a code statement that was mis-
typed and it caused Access to lock up.

In any event, I am well beyond that now... I've re-done the process
(for the 3rd time), done the changes, done the testing, and I'm onto
the next series of forms.

Oh yes... I know all about references... thanks.

thx.

 

[Linq Adams via AccessMonster.com]

I asked for clarification on the 'missing" thing because posters will often
use this term to describe a form when no controls show up, as when there is
no data in the underlying recordsource abd the form is read-only.

When you're in one of these code modules, what happens if you click on the
Access 'red key?' Does it take you to Design View for the form?

 

[AccessVandal via AccessMonster.com]

After the locked up, what did you do? Did you go into Task Manager to end the
msaccess.exe?

 

[SilvrT]

When you're in one of these code modules, what happens if you click on the
Access 'red key?' Does it take you to Design View for the form?

If you are referring to the very left button on the Toolbar that takes
you to "View Microsoft Office Access" ... no, it does not take me to
design view of the form ... just to the Database Window. Unfortuantely
I can't test this on the file that was missing the forms as I've
started over and deleted the one that was "messed up".

 

[AccessVandal via AccessMonster.com]

SilvrT,

If you encounter this again, let me know.

I have just recoverd my damaged DB from what you had discriped where the
Forms goes missing but the code is still in the project explorer in the VBA
editor. But of course, you need a back up of the last original. I had a
backup of the original condition. Even without the original form, creating a
new form without the controls, I believed, you still can recover your DB.

But I believed it's not worth the effort if there are very very little coding
or work, unless you had spend a lot of hours design you DB.

 

[SilvrT]

But I believed it's not worth the effort if there are very very little coding
or work, unless you had spend a lot of hours design you DB.

Correct... not worth the effort...for this situation -BUT- what's a
guy to do if it happens further on...after I've imported 50 forms?? I
guess to safeguard I should backup after each form design change ...
kinda ridiculous IMHO. It would sure be nice to know why this happens
and what a specific fix is. Gotta be a bug in 2003 as I've developed
in all versions of Access from 2.0 on up to 2003 and never seen this
before. Sure, I've had crashes and had to fix a corrupted file but
never have any objects completely disappeared from the database
window, yet leave the code section behind.

Gotta love these "challenges" eh? LOL

 

[AccessVandal via AccessMonster.com]

I failed to mention I was using A2000. This even could happen in A2007 or
A2010.

The problems might come from Internet security, anti-virus software that
might interfere Access or the problems might be hardware like RAM, Harddisk
corruption.

I my case, none of the above (not yet). Access sometimes appears to freeze
for more than 1 minute which I accidentally use the Task Manager to shutdown
Access. As I was in a hurry, I forgot about leaving it alone and take a break.
On reopenning the DB, I had two forms missing except the codes.

I did all you had posted, none work including decompiling the DB. I had this
problem for more than three weeks. I had to think out of the box.

 

[SilvrT]

I failed to mention I was using A2000. This even could happen in A2007 or
A2010.

The problems might come from Internet security, anti-virus software that
might interfere Access or the problems might be hardware like RAM, Harddisk
corruption.

I my case, none of the above (not yet). Access sometimes appears to freeze
for more than 1 minute which I accidentally use the Task Manager to shutdown
Access. As I was in a hurry, I forgot about leaving it alone and take a break.
On reopenning the DB, I had two forms missing except the codes.

I did all you had posted, none work including decompiling the DB. I had this
problem for more than three weeks. I had to think out of the box.

Interesting ... sometimes I get the same symptoms. Another one is when
I'm in a code window that has a lot of code and I use the mouse wheel
to scroll .... the screen just "takes off" on me... scrolls to the
bottom all by itself and just "freezes" ... I have to wait maybe 1-2
minutes before I can control it again... can't even type in it, yet I
can jump to another program and work normally. Other times, when I'm
editing the code, and I click the Save button, it takes 1-2 minutes to
save the changes....yet other times it's instantaneous. Too weird!

 

[AccessVandal via AccessMonster.com]

That's odd, as far as I can remember the code window does not work with the
mouse scrolling not in 2000 or 2003 but in 2007.

I have check it in 2003, the mouse scrolling does not work. Maybe you have an
hidden application running behind somewhere or you might be unaware of the
mouse reconfiguration tool installed somewhere. The mouse scroll wheel can
act as a third mouse button or a middle button in most brands/types. Or you
might accidentally made the clicking speed too fast or too slow? Or you might
had something like from Stephen Lebans mouse scrolling utility?

If I were you, I'll start check what's wrong.

I have known some people have problems using mouse where the default speed
was not suitable for them. One double click opens multiple same application!
Even the mouse speed cause problem for them!