No Minimize/Maximise/Close Control Box for Access

[Russie]

Hi.

I've managed to get rid of the File, Edit etc menu from Access using code..

Does anyone know how to eliminate the control box from the main Access window?....

My applications are run entirely with the use of forms and code and I want to eliminate the main control box in favour of a coded application quit.

Anything appreciated.

A star for the answer.

Russie

 

[BSman]

I wish there was a way.....

The only "alternate" I've been able to come up with that will handle the situation when the user closes the application by clicking on the Access close window X instead of clicking on the appropriate button in the application is to open a hidden form when the application starts. For the OnUnload (or OnClose) property of that form put the code you want to execute when the application is closed. Then, whether the user closes the "right" way (through the application) or by clicking the Access close window X, the hidden form will be unloaded and the closing code will be executed.


I've looked at the possibility of disabling the control box for Access itself, but it can't be done, probably because there would then not be a way to close Access if there was a problem with an application.

 

[combo]

The way to manipulate windows are API functions.
To see what can you do (with source code) with excel user form (and also standard VBA user forms), download FormFun.zip from

http://www.bmsltd.co.uk/Excel/Default.htm

I hope this will be useful in your digging in API functions for access application.

 

[cranebill]

This may sound cheesy but would there not be a way that if all your access needs are done with the use of code and forms, could you not just write it in Visual Basic instead?

Bill