Startup code calling for a Form I can't find

[Guest]

How do I locate the code that is referencing on StartUp a form that is not
showing up anywhere? I have searched all the macros manually and can't find
it anywhere.

 

[Rick B]

Is it the Tools/Startup form that is being referenced?

 

[Guest]

You probably calling that from the startup box
right click on the top of the MDB box, select StartUp, in there you have a
text box "Display form", check if the form name written there

 

[Guest]

It could also be called from a Macro named Autoexec

 

[Guest]

I tried each of the suggestions but still no luck.

 

[Guest]

Here is a technique that should help you find the problem.
Determine what code executes for startup. It will either be a function
identified in a macro called Autoexec or in a form called by startup. You
can check Tools->Startup from the menu, and see what is in Display Form/Page:
Once you have that determined, open the code module for the form, or the
module the function from Autoexec is in and set a breakpoint on the first
line of executable code. Then open the startup form or call the function
from the immediate window. Then when it tries to open the mysterious form,
you will see what the name of it is and where it is called.

If you know the name of the form, then you can go into Tools->Options and
check Show hidden objects on the view tab. It may be that the form is hidden.

 

[Guest]

Still struggling with these two forms that bring up error messages on startup.
The only place I can find them mentioned anywhere in the database is in the
Project Manager page in Visual Basic. When I right click on the form (any of
the forms actually) the 'Remove the form' command is grayed out so I can't
select it.

Any ideas on why this would be so? I am the one with all the read/delete
rights for the database so I can change any setting that might be messing
with my mind here.

Thanks.

 

[Guest]

It is possible you are suffering a weird corruption problem. I did have a
problem once where some tables were doing almost the same thing. I checked
show system objects, and they showed up as being system tables owned by
"system". I had to do the old start with a new mdb and import everything
from the old one routine.

 

[Guest]

Klatuu
You are my new best friend! It worked. The new database did not import the
two forms because (of course) they were not really there!!
Thanks so much.

 

[Guest]

Great! Glad you got passed it.
When Access goes Schitzoid, it can make you crazy.