Forms, how to show the function that is running to the user

[mfaqueiroz]

Hi!

I'm quite newby at forms.
I have a button that runs a lot of functions and takes almost 10 hours to finish that!
I want to show in the form the function that is running in one box, something like that:

"running the Maintenance Function (1-50)"
"running the Alarms Function (2-50)"





Thank youu !

 

[jdraw]

10 hours of processing????
What are you doing? How many records? How many users?

 

[mfaqueiroz]

10 hours of processing????
What are you doing? How many records? How many users?

Hei,
I'm using complex algorithms.
I'm processing 500.000 records ......:/ but it stills to much?

 

[Minty]

Use SQL server ?
Seriously if this is in a multi-user environment you would need to lock everybody out of being able to run this process once it has started, what if two people press the go button within a couple of minute of each other ?

So if you have them locked out just tell them when the process started and an estimated time of completion. Either that and/or put a completion flag in a table of your process steps, that you reset once the process is complete.

 

[jdraw]

You might want to try and optimize one or more of the algorithms.

Readers don't know anything about your setup, so focused responses are unlikely.

You can change the caption via vba, but you'd have to know your processing logic.
When you enter a function you could cede operations to the OS by means of DoEvents, change the caption and another DoEvents to effect the change.

see https://support.microsoft.com/en-us/kb/103404