Disable Escape Key while processing

[P_Henry]

Hi,

I have gone through the posts and found out how to trap the escape key (By using the Keydown event). However, I want to be able to disable escape key when processing .
The process includes the following:
Update status fields in the form --> Compose and send email --> Write audit trail --> Update table using query --> Finally display message to say processing is comeplete.

The whole thing runs really fast but one of the users had hit the escape button in the middle of the processing. So, what has happend is the status fields are updated but none of the other processing has happened. There is no rollback mechanism here. If I trap the escape key, the system does not resume processing. Iguess what I want is undisturbed processing. Is there a possibility to do this?

Thanks,
Priya:banghead:

 

[John Big Booty]

Perhaps this link will give you some pointers.

 

[P_Henry]

Hi John,

I did add this code from this website- what it does its that it disables the key when it is pressed but the processing does not continue.

Tx,
Priya

 

[John Big Booty]

To be honest I would have thought that if the ESC was disabled it should have had no effect on your code. However it may be interrupting a process (Sending Email) external to Access which then stops the rest of your process from completing.

 

[P_Henry]

Thanks John..in this case it is stopping further processing - even running the queries. Is there any other solution?

 

[P_Henry]

Thanks Bob...Seems to be complex but will have a go.