Where to start?

[Newbiee]

I was presented with a project to repair Access Forms.
There is one master forms and tons of "subforms".

"subforms" - I found that these are actually normal forms.
Somehow, the previous programmer were able to paste these
forms on top of the master forms. I have looked through
the code but it leads me to NorWay (no way).

Seems to me, the master forms is a few subforms sticking
together.

They didn't have any documentations and I don't know who
the original programmer was.

That's all I found out right now. I'm hoping for some hint
on where to start? By the way, they have lots of tables,
forms and queries that they never use. Should I delete
these useless thinggy?

 

[Albert D. Kallal]

While it looks like the form was pasted, you cant do that.

You can however drag a form into another form. In fact, what you really are
doing is placing a sub-form "control" on the screen. This "control" looks to
that other form. So, the form is not really on, or in the screen (but a
"control" allows you to "use" the from within a form).

If you look at form in design mode and show the tools, you will find that
one of the tools is to put a sub-form on a screen.

Here is some ideas as to why those sub forms are so cool...
http://www.attcanada.net/~kallal.msn/Articles/fog0000000005.html

As for deleting that stuff that is not used, well, gee it takes VERY GOOD
and intimate knowledge to know if a query or table is in use. You will have
to check all the reports, forms, queries, code to ensue that the table, or
query or form is NOT in use. Use extreme caution in deleting anything, and
before you do, ALWAYS make a backup, so if you delete something you need,
you can go back...