"Application.EnableCancelKey" - Access equivalent.

[LEXCERM]

Hi there,

In Excel, I use Application.EnableCancelKey to stop a user from interrupting a macro whilst it's running. Is there an equivalent piece of code in Access so that it stops a user from using ESC or CTRL+BREAK to stop/interrupt a code from running?

Or can someone suggest an alternative way of achieving this?

I have some code which runs a query and then exports the data to an Excel file and I do not want a user to interrupt or cancel the routine.

Rgds,
Paul.

 

[ghudson]

You could use the AutoKey macro to re-assign those key combinations but those are basic windows commands that programmers use to allow a user to stop an action if and when needed.

Search the Access help files for how to setup an AutoKey macro.