Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Detecting if a Class module procedure is running

Status
Not open for further replies.

sellert

Programmer
Nov 18, 2004
36
US
Greetings!
I have an application where the user can start a procedure that pulls and compiles data into a spreadsheet that is used in various metrics. I want to be able to disable the Exit button based on whether or not this procedure is currently running. Exiting prematurely causes errors. The procedure name is Run_QCMetrics_Click. I know how to do this by setting a flag when the procedure starts and having the exit button check the flag before exiting. But is there a more efficient way using a built in Access function or API?

Thanks,
SELLERT

If I'm not learning I must be coasting. If I am coasting I must be going down hill.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top