Question Maximize/Minimize Issue

[RexesOperator]

This is a little bizarre. I am using Access 2003.

If I maximize any window, the max/min/close buttons disappear on all objects. (see examples). The only way I can stop this behaviour is to close the database. This is occuring in all databases.

What might have happened and how can I fix this?

 

[Rabbie]

I couldn't actually see anything wrong in your screen shots. They all seemed to have the correct icons.

However have you tried a "Compact and Repair" of your DB. If that doesn't help try opening a new bank DB and then copy everything over to it.

 

[gemma-the-husky]

clcik the resize button to get a visible inner pane? maybe?

with forms you should see the forms control buttons nested just beneath the applications control buttons - ie your form example but you may need to mess around with the form to make them visible. [edited - ive just checked - its on the menubar, so if you have dispensed with the menubar, that might be the issue]
i have one app where they got me to put a large CLOSE button at the bottom right of every form - just a command button

the click event is =formclose()

and the close function in a module is (i think)

function formclose()
with screen.activeform
docmd.close acform
end with
end function

just copy the button from form to form to reuse it, because ut carries the event handler with it

 

[RexesOperator]

I couldn't actually see anything wrong in your screen shots. They all seemed to have the correct icons.

Notice that the Maximize/minimize/close buttons do not show up on any db objects, except for the MAIN Access Window Frame

However have you tried a "Compact and Repair" of your DB.

I have done that.

If that doesn't help try opening a new bank DB and then copy everything over to it.

And that.

I also just read gemma-the-husky's reply - the clue is

[edited - ive just checked - its on the menubar, so if you have dispensed with the menubar, that might be the issue]

I was playing around with menubars so I must've deleted it. Oops.

 

[Rabbie]

Since I couldn't actually make out that there were dtabase objects in the little snippets of pictures that you posted It was hard to put your screen shots into context.

I am sorry if I couldn't help you but I will ignore your posts in future as I don't need a lecture when I am trying to help you

 

[RexesOperator]

I am sorry if the pictures weren't explicit enough. I found that usually pictures make it a lot easier to explain what's going on.

Perhaps I should have said I had done a "compact and repair" as well as import the db objects into a new db in the original post. I did not intend for my comments to be a "lecture". If I have stepped on your toes - I apologize.

I have always appreciated everyone's help here - even on the rare occasion when no answer was forthcoming.

 

[RexesOperator]

Apparently this is not a new issue restricted to me:

http://www.eggheadcafe.com/forumarchives/accessformscoding/jul2005/post23549526.asp

This example refers only to the problem on maximized forms. My problem extends to queries and tables as well (I have attached a more explicit example).

I have tried playing with the various menus but I can't seem to locate anything that covers these controls.

I thought I was missing something obvious, but maybe not. Do I have to resort to reloading Access to get everything back to normal (since the problem exists in ALL Access databases on this computer)?

 

[DCrake]

If you care to look more closely you will see the the menu query Design is not visible. This handles the min max controls. Customise you QBD and select Query Design this will invoke your min max icons.

If you are using macros or code to hide/show menubars in your app make sure you reset them when you go into development mode by using the following code

    DoCmd.ShowToolbar "Query Design", acToolbarWhereApprop

David

 

[Rabbie]

I am sorry if the pictures weren't explicit enough. I found that usually pictures make it a lot easier to explain what's going on.

Perhaps I should have said I had done a "compact and repair" as well as import the db objects into a new db in the original post. I did not intend for my comments to be a "lecture". If I have stepped on your toes - I apologize.

I have always appreciated everyone's help here - even on the rare occasion when no answer was forthcoming.

Apology accepted. The more information you give the easier it is to avoid suggesting you do something you have already tried. Pictures are usually useful but I have always had problems putting extracts from pictures into context.

 

[RexesOperator]

If you care to look more closely you will see the the menu query Design is not visible. This handles the min max controls. Customise you QBD and select Query Design this will invoke your min max icons.

If you are using macros or code to hide/show menubars in your app make sure you reset them when you go into development mode by using the following code

    DoCmd.ShowToolbar "Query Design", acToolbarWhereApprop

David

OK - this explains how to fix the problem for queries in this db. The same issue extends to forms and reports so I can add the same code. How do I fix the problem for tables and the database window? Can they be controlled in the same way?

The problem seems to be more generic though - since it affects all dbs on this computer. That's why I was thinking of simply reloading Access.

 

[DCrake]

Have you checked you settings in Tools Startup Allow built in menus

 

[RexesOperator]

Yes I have.

I will have more time on the weekend to play with this. I have done some research on acToolbarWhereApprop and found this:

http://www.utteraccess.com/forums/s...=127476&page=1&view=collapsed&sb=5&o=&fpart=1

I will see if that helps.

 

[RexesOperator]

Have you checked you settings in Tools Startup Allow built in menus

Under Menu Bar:

I have (default) and

Allow Full Menus checked and
Allow Default Shortcut Menus checked

Under Shortcut Menu Bar:

I have (default) and

Allow Built-in Toolbars checked and
Allow Toolbar/Menu Changes checked

However this issue extends to any Access db I try to open.

Are there any other ideas?

 

[gemma-the-husky]

what about just

customize menus, and click

MENUBAR

 

[RexesOperator]

I don't have MENUBAR on the Toolbars list. I have even tried opening ALL the toolbars. I have checked with our IT people. They're willing to unload and reload Access to see if that clears the problem. Are there any issues that might crop up during this process that I need to be aware of?

 

[RexesOperator]

In case this happens to someone else:

I finally took the problem to our IT staff (they're usually only interested in network issues - not software issues). After several hours of trying to recover the MENUBAR option they unloaded and reloaded Office. Somehow there was a setting change that was specific to my Windows network setting - as well as whatever damage I had done (by deleting/moving items) to the menus. So the issue involved three things - my network settings, my Office 2003 settings and the menu options that I had chosen. ALL MY FAULT

Lesson learned - use vba to control the menus (as per the link above), NOT Access's options menus.