Forms missing from "All Forms" in Customize

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

I recently developed 3 new forms for my Access 2000 front end and
wanted to add one of them to my toolbar. When I went to use the
Customize and selected "All Forms", for some reason, the new forms
were not in the list of forms in the right-hand panel. The other 100
or so forms all seemed to be there.

I am absolutely stumped. I have Compacted & repaired the front end,
closed out of Access and opened the DB over and over again and I
cannot get the forms to show up in the Customize window. I have
examined every property I can think of and can't find one that seems
like it would control this. Any one ever seen this weirdness before?
Any suggestions?

There is another phenomenon going on that I don't understand also.
Perhaps it is related in some bizarre way, so I will mention it and
maybe people can answer one or the other problem (both would be
miraculous!). After opening (and closing) those new forms a number of
times, the tables involved with the forms can no longer be opened in
design view. I am the owner of all the tables and I am sure that I
have closed all the forms and the only way to get access to the table
design ( aside from read-only) is to close the database and re-open
it. However, I cannot reproduce the problem on purpose. When I am
trying to make it happen, so I can maybe solve it, I keep opening and
closing the forms and cannot make the tables lock up.

It is all very bizarre and confusing. Any insight or suggestions would
be very much appreciated.

TIA,
Christine
 
Hi Christine. Symptoms suggest an incipient corruption.

1. Create a new (blank) database.

2. Immediately turn off the Name AutoCorrect check boxes under:
Tools | Options | General

3. Import everything:
File | Get External | Import

For information about the problems with Name AutoCorrect, see:
http://allenbrowne.com/bug-03.html

If that does not solve the 2nd problem, look for any code that opens a
recordset and fails to close it, or that fails to set objects to Nothing on
exit (such as a Recordset variable pointed to a form's RecordsetClone).
Concurrency issues might also be worth considering (where 2 forms into the
same data could be dirty at once).
 
Thanks Allen,
I recreated the new DB as you suggested and sure enough, the new forms
were available in the Customize Window for "All Forms". Time will tell
whether it took care of the other problem or not.

G'day and thanks for your help,
Christine
 
Back
Top