Removing Close Button

[Haynesey]

Hi,

Is there any way of removing the close button in Microsoft Access so that the user has to use the exit button that I have created. I have managed to get rid of the close button on each of the forms but not that of Microsoft Access in general.

Please help

Thanks in advance

Lee

 

[Mile-O]

Not exactly remove it but:

In a module create a public variable with this line:

Public pbooClose As Boolean


Make a new form, call it frmHidden
On it's unload event put this code

If No pbooClose Then Cancel = True

On your main menu's exit button put this line:

pbooClose = True


Finally, in your autoexec macro (I'm assuming you have one) ensure that it opens frmHidden first (with a hidden view) and then your switchboard.


Your user can click on the 'x' all they like but they database shouldn't close until they click that exit button.

 

[Haynesey]

Hi,

Not sure I understand what you mean. Is there any chance that you could do me an example??

Thanks, I appreciate your help.

Thanks
Lee

 

[ColinEssex]

In addition to Mile-O's example, have a look at Ghudsons reply here

http://www.access-programmers.co.uk...?s=&threadid=46169&highlight=disable+X+button

Col

 

[Mile-O]

Here you go.

 

[minder]

thanks Mile-O-Phile just used code spot on as usal

thanks
rob