Is there a way to stop event from trigerring in access? Application.EnableEvents = False

[pedie]

Hi,
'm trying to prevent form from closing exept through button click....how can i do this in access? the below code wont work in access form

I only till now know how to set warning to false...
And is there anything like screenupdating to false that can also speed up access codes? Just curious.

Thanks in advance.

[/FONT]
[FONT=Courier New]'Prevent user from closing with the Close box in the title bar.
    If CloseMode <> 1 Then Cancel = 1
    me.Caption = "The Close box won't work! Click me!"

 

[Smitty]

Check out the Echo method.

HTH,

 

[pedie]

Check out the

Echo method.

HTH,

Hi Smitty, can make it work...still reading but...
can someone help me out!?
It does not let me close my form....

[/FONT]
[FONT=Courier New]Private Sub Form_Close()
Application.Echo False
DoCmd.Close
Application.Echo True
End Sub
Private Sub Form_Unload(Cancel As Integer)
Cancel = True
MsgBox "Use close button to close me..."
End Sub
Private Sub Command14_Click()
Application.Echo False
DoCmd.Close
Application.Echo True
End Sub

 

[xenou]

In form properties, set the "ControlBox" property to No. There will then be no close button for the user to press and they will have to use your button instead. This is simplest and best, if you want users to use your close button.

 

[Norie]

Pedie

Access doesn't really have the kind of events you disable in Excel.

Most events will only be triggered because you've created code that triggers them intentionally.

Also, you can't turn offScreenUpdating.

That could be because you don't need it in Access.

If your code is running slowly you really need to look at the code and what it's doing.

You might even be doing something in code that you don't need to do in code.

 

[pedie]

Thanks Xen, thanks Norie for clarifying...
Xen, that was cool. i like that but i will not like someone to open it in edit mode and change the setting which i think they might do...

So if there is a vba way to stop that then it will be great!
Else if there is any way to stop users from changing settings i have set....

 

[xenou]

So why do you think a user would do this? That's somewhat strange behavior - though if anyone knows enough to know how to do this, they should also know enough to tell if it will break the form or not. You really want to avoid writing so much vba for everything. Lots of vba = lots of errors. Keep it simple.

 

[pedie]

Yes, i think anyone determined to do this can anyways take care of it...I'll go with less VBA then
Thanks for the support!

 

[Norie]

Pedie

How about no VBA?

There's plenty if things you can do in Access that don't require code.