Interrupted Process Error 2486

[KWHAT]

Hey Everyone,

Quick question i have an access form fully functional works every time, however in some cases there are slight delays, for example even though the loading sign i display turns visible=false after a recent button click, i later access a different button, but this leads to an error 2486 "You can't carry out this action at the present time." I want to avoid this error and make sure the first process is fully complete even though the second button has been clicked, how do i go about doing this??? Is there another way than me locking all the buttons?
Thank you for your time.

 

[RuralGuy]

Add a DoEvents to your code maybe. Give the event engine a chance to run.

 

[theprez]

You could also display a polite screen that comes up that says.

Please wait while your (Query, Addition or whatever you are doing) is processing. Have the screen pop up. Use the timer Event to wait for however long you want, placing the Docmd Close form in this event. Make this "Polite Form", pop-up, modal, so the user cannot go anywhere else.