Block a command button

[mrsshap]

I have a module that is executed by a command button. While this module is running, I would like to know how to keep all other users out until it is finished.

I would really appreciate any ideas or suggestions someone might have.

 

[DougP]

Out of the whole .MDB file or out of a particular form ????? DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[mrsshap]

I just don't want them to be able to execute the code behind the command button until the module is finished.

 

[BlackKnight]

Hi,

You can disable the command button once the process is started by setting the command button's ENABLED property to false. This way once the button has been clicked the button is disabled and people can click on it all they want but it won't trigger the click ervent. Ber sure to set the enabled property back to true at the end of the process.

Have a good one!
BK

 

[llkhoutx]

Turn the hour glass on and off to let the user know that work in in progress:

docmd.hourglass true

your code

docmd.hourglass false

You can also let the user know what is going on by filling the status bar at the bottom of the windows window. check Syscmd in the Help menu to see how this is used.