form timer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hiya

Sorry to annoy again..

Following from previous posts, I have a form that opens prior to doing some Excel automation (Excel stuff not visible)

I have set the form to have some timer events on it, but the timer events do not operate whilst the automation processes are running - is there any way I can get the timer stuff to run (it simply changes the text on a label every 0.6 seconds - "please wait." to "please wait.." to "please wait..." and then loops

Here is the basic code to open the form and do the automation

DoCmd.OpenForm ("Report Running"
DoEvent
ViewPatXLRep 'automation bi
DoCmd.Clos

Thanks so much

Karen
 
Have you tried using DoEvents inside the ViewPatXLRep procedure to allow the
timer to run?

--
Wayne Morgan
Microsoft Access MVP


KT said:
Hiya,

Sorry to annoy again...

Following from previous posts, I have a form that opens prior to doing
Click to expand...
some Excel automation (Excel stuff not visible).
I have set the form to have some timer events on it, but the timer events
Click to expand...
do not operate whilst the automation processes are running - is there any
way I can get the timer stuff to run (it simply changes the text on a label
every 0.6 seconds - "please wait." to "please wait.." to "please wait..."
and then loops.
 
Is there a loop in the ViewPatXLRep procedure where you could update the
label from there each time you go through the loop?
 
Yeah, but that would pretty much defeat the purpose of the timer. It is set to update every 0.6 seconds

If the form timer can't work on its own whilst running other processes, then I will have to give up on it

Is there any way to make this happen

Thanks for your time and thought..

Karen
 
If putting DoEvents inside the loop in the procedure doesn't allow the timer
event to run, I don't know what would. Just putting it "once" in the
procedure won't work if the procedure has a loop, it will need to be placed
in that loop.

--
Wayne Morgan
Microsoft Access MVP


KT said:
Yeah, but that would pretty much defeat the purpose of the timer. It is
Click to expand...
set to update every 0.6 seconds.
If the form timer can't work on its own whilst running other processes,
Click to expand...
then I will have to give up on it.
 
Back
Top