Some Forms Not Displaying

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Some forms are not displaying in a db I set up, but haven't seen for a while.
It is used by the office I built it for. When I last saw them, the db was
duplicating itself, but they were unable to pay me to look into it. Also, at
that time, they found that their hadware/network guy was sabotoging their
system, causing sharing problems for Access (I think). Sob story, I know,
but it is relavent. Today when I looked at it, not only was it duplicated
eight times (ten by the time I left), but the two most important forms would
not display. All of the subforms seemed to be okay, and the clerk can enter
data into the tables.

When I checked the database's properties, the Statistics tab showed that the
db was created March 12th, 2002, which seems reasonable. The General tab
shows that it was created July 19th, 2005. I was about 900 miles away at
that time on a family vacation.

Could I have some suggestions on what went wrong and how to fix it? Thanks
in advance.
 
When you say they don't display, do you mean that when you look in Forms in
the database window, they don't show up or are you saying when you try to
open them, you get nothing?

If it is the first case, they may be there, but hidden. Look in
Tools->Options->View, check Hidden Object and System Objects and see if the
show up.
 
Indeed, it is the first case. I'll have to check your solution when I can
get over to the database. Do you know why the duplicates? I'm afraid to
delete any.

Shannon
 
I have no idea why that would be happening.

Shannon said:
Indeed, it is the first case. I'll have to check your solution when I can
get over to the database. Do you know why the duplicates? I'm afraid to
delete any.

Shannon
Click to expand...
 
I've seen duplicate databases happen when there are data corruption
issues... If it were me I would simply created a new clean database, bring
the tables in, inspected them all including realtionships, then the balance
of the objects, then open each form to be sure no corruption was there and
you dodn't have to recreate something. Real pain but worth it...
 
to do this correctly, for each report or form that has a module, open the
object in design mode, open the code module, copy it and paste it to a text
file. Then delete the code in the object and set the Has Module property to
No. Once you get all the objects into the new database, open them in design
view and paste the code back in. When you have done all that, compile the
database.
 
Back
Top