Removing Close Button

H

Haynesey

Registered User.

Local time

Today, 08:10

Joined

Dec 19, 2001

Messages

190

• May 30, 2003

• #1

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

Back once again...

Local time

Today, 08:10

Joined

Dec 10, 2002

Messages

11,316

• May 30, 2003

• #2

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.

 

H

Haynesey

Registered User.

Local time

Today, 08:10

Joined

Dec 19, 2001

Messages

190

• May 30, 2003

• #3

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

Old registered user

Local time

Today, 08:10

Joined

Feb 22, 2002

Messages

9,451

• May 30, 2003

• #4

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

Back once again...

Local time

Today, 08:10

Joined

Dec 10, 2002

Messages

11,316

• May 30, 2003

• #5

Here you go.

 

Attachments

• dbclose.zip

  12.6 KB · Views: 309

M

minder

New member

Local time

Today, 00:10

Joined

Jun 10, 2004

Messages

8

• Jul 16, 2004

• #6

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

thanks
rob