Disable Acces close button 1

[diezzz]

How can i disable the acces close button, using vba? I managed once when i was working for school only in vb6 to pop up a msg box everytime the user click on the close button "please use the quit button on the form".

I'm talking of the big acces button, not the ones for forms, reports etc.

Can anyone help me?

 

[ProgramError]

set the control box property of the form to false


Ian Mayor (UK)
Program Error
Programming is 1% coding, 50% error checking and 49% sweat as your application bombs out in front of the client.

 

[ProgramError]

Sorry that was VB

set the close button in the format properties of the form to no or set control box to no

Ian Mayor (UK)
Program Error
Programming is 1% coding, 50% error checking and 49% sweat as your application bombs out in front of the client.

 

[LarrySteele]

diezzz, here's a link to Calvin Smith's method of disabling the control box on the Access window:

http://www.calvinsmithsoftware.com/DisableControlBox.htm.

I've used his method on several applications and it works well. Once you have his code stored in a module, you then disable the control box using [tt]EnableDisableControlBox False[/tt] and enable the control box using [tt]EnableDisableControlBox True[/tt].

Hope this helps,
Larry

 

[diezzz]

thank you very much, it works