Form does not open - Access says it is open

D

DMUM

Hello

I am developing a new database and created a form that contains 2 subforms.
I created code behind the main form that was connected to one of the command
buttons, but I did not create any other events for this form or the sub forms.
The sub form are based on queries. The Main form is just a container for the
subforms. Today I have been trying to open my form which I will call
frm_Main. When I try to open it, the screen makes a slight blink, but
nothing happens. When I try to open in design view, the tool bar shows up,
but the form never opens. When I attempt to delete the form, Access gives a
message that the form (object)can not be deleted because it is open. I have
compiled and repaired the database. I have also created a blank database and
imported the subforms and frm_main. Same problem. In my original database,
I can't open the subforms or delete them. In my import build, I have been
able to view and delete the subforms, but the frm_main will still not open
even though Access says it is still open. I deleted all the code attached to
all the forms which hasn't changed anything either. I could just re-create
the form, but I'm worried that this will just happen again. So I would like
to identify the problem and the fix if possible first.

Thank you
 
R

RobVT

DMUM,

It sounds like the form might be hidden. Go up to 'Window' then select
"Unhide". You should see your form there. Give that a shot first.
 
D

DMUM

Thanks for the response, but no, that doesn't seem to be the issue either.
When I try to open the form (by clicking on it and then go to WINDOW to see
what windows are open, the form is not listed and HIDE is shadowed. When I
attempt to open the form in design view. WINDOW still shows HIDE as shadowed
but the form does show up as an open window.

Thanks
 
D

Dirk Goldgar

DMUM said:
Hello

I am developing a new database and created a form that contains 2
subforms.
I created code behind the main form that was connected to one of the
command buttons, but I did not create any other events for this form
or the sub forms. The sub form are based on queries. The Main form
is just a container for the subforms. Today I have been trying to
open my form which I will call frm_Main. When I try to open it, the
screen makes a slight blink, but nothing happens. When I try to open
in design view, the tool bar shows up, but the form never opens.
When I attempt to delete the form, Access gives a message that the
form (object)can not be deleted because it is open. I have compiled
and repaired the database. I have also created a blank database and
imported the subforms and frm_main. Same problem. In my original
database, I can't open the subforms or delete them. In my import
build, I have been able to view and delete the subforms, but the
frm_main will still not open even though Access says it is still
open. I deleted all the code attached to all the forms which hasn't
changed anything either. I could just re-create the form, but I'm
worried that this will just happen again. So I would like to
identify the problem and the fix if possible first.

Thank you

Possibly the form has somehow been positioned offscreen. After you have
opened it, can you make it appear by clicking menu item Window ->
Cascade?
 
D

DMUM

Ok this is really wierd. As I mentioned before. The Form will NOT Open when
you click on it directly and it doesn't show up in the WINDOW drop down as an
open object. Therefore your suggestion below did not work either. However
when I attempt to Open in design view and the toolbar shows up (left side of
my screen) the form does show as an object in the WINDOW list. I was also
able to see the Form in design view by using your suggestion(it appears at
the center of my screen - not off screen). I was then able to use the OPEN
icon on the Database Window to view the Form. However when I closed the form
and tried to open again, it will not open.

Thanks

Dirk said:
[quoted text clipped - 20 lines]
Thank you

Possibly the form has somehow been positioned offscreen. After you have
opened it, can you make it appear by clicking menu item Window ->
Cascade?
 
D

Dirk Goldgar

DMUM said:
Ok this is really wierd. As I mentioned before. The Form will NOT
Open when you click on it directly and it doesn't show up in the
WINDOW drop down as an open object. Therefore your suggestion below
did not work either. However when I attempt to Open in design view
and the toolbar shows up (left side of my screen) the form does show
as an object in the WINDOW list. I was also able to see the Form in
design view by using your suggestion(it appears at the center of my
screen - not off screen). I was then able to use the OPEN icon on
the Database Window to view the Form. However when I closed the form
and tried to open again, it will not open.

Is this a popup form, by any chance? That would explain why it doesn't
appear in the Window list. Is there code in the form's Open, Load,
Activate, or Current event? If so, does it do anything that involves
positioning the form -- calling the MoveSize method, or setting the
WindowLeft or WindowTop property, for example?

If the form's PopUp property is set to Yes, try opening the form in
Design View, changing it to No, and saving the form. Then open the form
normally and see if/where it appears. Position it on the screen
wherever you want, then click the Save button on the toolbar, then close
the form. Open the form in Design View again and set the PopUp property
back to Yes, then save the form. Maybe that will reset the form's saved
coordinates.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top