opening form on process

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

Guest

Hi

I have a process that runs when you click a button. It takes a fair while to run and involves Excel automation (all hidden)

I want a form to open up when the button is clicked before the whol process starts, to say: "Please wait whilst the report is running"

I feel like an idiot, but I can't figure out the code to get the form to open and then close after the process is done. The form name is "Report Running". Please help..

Many thanks

KT
 
The way that I have tackled this in the past is to put the
Excel process in the form. I have made the form a pop up
and stripped it of all buttons so that the user cannot
close the form before the processing has completed. Where
the process is particularly long, I have introduced
messages and/or progress bars on to the form to keep the
user informed of progress. When the process is complete, I
just issue a DoCmd.Close to terminate the form.

Hope That Helps
Gerald Stanley MCSD
-----Original Message-----
Hi,

I have a process that runs when you click a button. It
Click to expand...
takes a fair while to run and involves Excel automation
(all hidden).
I want a form to open up when the button is clicked before
Click to expand...
the whol process starts, to say: "Please wait whilst the
report is running".
I feel like an idiot, but I can't figure out the code to
Click to expand...
get the form to open and then close after the process is
done. The form name is "Report Running". Please help...
 
Back
Top