Minimise/maximise button removed but still one button visible menubar 1

[WillemdeNie]

On my form I do not want the user to use buttons availanle on the menu bar. Whatever I try I cannot remove the last button "Restore window"

How to solve?

 

[CautionMP]

The button cannot be removed, two work arounds;
1) Set the OnResize event to DoCmd.Maximize
2) Sety the Border Style to 'None'

 

[WillemdeNie]

Thanks for quick response, but problem is not solved. Any idea why?

 

[annsolomon]

I recently saw an article in Microsoft's KB explaining that because Access is a multiple document interface application the Restore button is always available when a form is opened in the maximized state. They suggested forcing the form to occupy a specific amount of space on the screen but that solution doesn't work for me because my users have different size monitors. I sure hope someone here has a better solution.

Ann

 

[Ryon]

there is also some code on this site that actually hides the access widow completely. making the forms appear by themselves with the desktop in the background. it will require some code in the on open and on exit event of every form but it would also solve your problem.

if this intrests you post back and I will help you find the details you need


Ryan

 

[annsolomon]

Ryan, are you referring to thread181-8442 or something else? I haven't had a chance to try this code yet so I don't know yet if it will do what I want. If you have something else, I'd be interested in seeing it. Thanks.

Ann

 

[Ryon]

I just read the post again, if you are trying to hide all of the buttons on the FORM, then just set the form properties for control box to no.

if you are trying to hide controls in the access window then you are on the right track:

yes, its the same code, this removes all access built in funtionallity when the window is minimized. ex: when you right click on the top of any form it gives you a menu, not if you use this code.

The only problem I have fould with using this code is on reports.

Say you have a report open up and maximize. there is no toolbar so you cant print it. you could add one preview button and one print button. What I did Was add code to the on close event for the report to ask the user if they want to print the report, therefore minimizing the ammount of controls on your forms.


make sure you backup you DB before you use this.

after you have it working,if you right click on access on the bottom toolbar and click restore, it should bring back SOME access funtionallity. be carefull not to lock yourself out completely

Let me know how it works

Ryan