Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / December 2005

Tip: Looking for answers? Try searching our database.

Form does not open - Access says it is open

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DMUM - 14 Dec 2005 17:24 GMT
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
RobVT - 14 Dec 2005 18:22 GMT
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.
DMUM - 14 Dec 2005 18:46 GMT
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

>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.
Dirk Goldgar - 14 Dec 2005 20:29 GMT
> Hello
>
[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?

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

DMUM - 14 Dec 2005 21:01 GMT
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

>> Hello
>>
[quoted text clipped - 5 lines]
>opened it, can you make it appear by clicking menu item Window ->
>Cascade?
Dirk Goldgar - 14 Dec 2005 21:32 GMT
> 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
[quoted text clipped - 6 lines]
> 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.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.