Prevent Access from closing? 1

[rickyoswaldiow]

Greetings everyone, I have recently started a new job as a programmer working with Access 2002/VBA and SQL. I am wondering if there is a way to prevent the 'x' button from working in Access, we have removed the 'x' from the VBA forms but somtimes users accidently hit the main one and it can get rather annoying if you are in the middle of doing somthing!

 

[CautionMP]

rickyoswaldiow,
You will need an API. Here is an article for Access 95/97 but it should work in 2002.

MSDN > ACC: How to Disable the Close Button (x) on the Access Application Window (95/97)

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[rickyoswaldiow]

That's excellent, works a treat. I was wondering, what kind of load will this put on the processor? Our databases can be pretty vast and some of our clients have computers from the stone age - will calling these API commands slow down the execution much?

 

[rolandam]

You could try the following

If you have a main form insert the following code:

Option Compare DataBase
Option Explicit

Public bAllowClose as Boolean


Private Sub Form_Unload(Cancel as Integer)
    Cancel = Not(bAllowClose)
End Sub

You would then include a button that the user has to use to logout or close the application. The code would be then as follows

Private cmdClose_Click()
     bALlowClose = true
     DoCmd.Quit
Sub End

 

[rickyoswaldiow]

That method seems a lot neater! But since my boss just uploaded it to the live version, I'll leave it as it is