opening form on process

[KT]

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

 

[Gerald Stanley]

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

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...