Dec 142017
 
MS Access. Turn off system menu on access forms. Pretty good.
File CNTRL.ZIP from The Programmer’s Corner in
Category Databases and related files
MS Access. Turn off system menu on access forms. Pretty good.
File Name File Size Zip Size Zip Type
CONTROL.MDB 65536 10741 deflated
README.TXT 1438 710 deflated

Download File CNTRL.ZIP Here

Contents of the README.TXT file


18 Apr 1993
10:30 AM

Ken Getz
76137,3650

CONTROL.MDB contains a module and a test form, demonstrating how you can remove and replace the
System menu, the maximize and the minimize buttons from your forms.

To use the function HandleSystemItems(), first Import the module "Handle System Items" from
Control.MDB. Then you should be able to call the function HandleSystemItems() from any
place on your forms.

Syntax:

HandleSystemItems(formObject, SystemMenu?, MaximizeButton?, Minimize Button?)

Example:

Attached to the OnPush event of a button, try:

=HandleSystemItems(Form, False, True, True)

This will turn off the System menu and turn on (or leave on) the two buttons in the
upper right corner of the form.

WARNINGS:

Access doesn't know that you've turned off these items. Because of that, I've found two
cases that act strangely:

1.) If you turn off the system menu and then maximize a form, Access turns ON the
system menu, and there really isn't any way to remove it while the form is maximized.

2.) If you remove the System menu and minimize a form, attempts to restore the form
to its original size will crash Access (at least, this is the behavior I saw on my machine).

Therefore, if you remove the System menu, I suggest you also remove the max/min buttons
on the form. I haven't found any problems with removing just the max and min buttons at run-
time.



 December 14, 2017  Add comments

Leave a Reply