Stop access to Access :-/

[Nirious]

I currently use this code (with thanks to Ray) to start a porgram and let access wait for it to finish before continuing code.

The problem is, the code waits but access itself doesnt. Which mean that the user can start the program again, or close the form where the results are going to be, etc.

Is there a way to refrain the user from doing anything in the access while the program is running?
I have change the cursor to the houreglass, but it still lets you click on everything

 

[FoFa]

Could you minimize Access, and restore it when the process is done, but when it's restored have it check to see if the process is running and minimize it again if it is running. That way if the user restores it it to do "something", it will minimize itself again if the process is still running.
Just a thought.

 

[Nirious]

That would work, but it wouldn't be nice to look at because the program that needs to be executed is only a very small window.

I was thinking about using a form with no borders and no way to close it and showing it as a dialog form. I'd put a label"please wait" on the form. Then on the dialogform I execute my my program and when it finishes I self-close the dialogform, returning to the original code?

Only problem is that I need an event that happens when the (dialog)form is already showing, so I ca execute my code, because else (eg open or load) the program will run and the "unclosable" form will be shown afterward=> big problem.

Does anyone know of an event that happens after the form is shown, or how I can create one or something? I'm thinking of the timer here?

Nirious

 

[Nirious]

The only event that seems to occur after the form is loaded is the timer event. so i used that one and it works fine.
The program is only run once because the access code waits and the timer event never gets called a second time, because it closes the form before it leaves the first time.