opening form on process


K

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
 
Ad

Advertisements

G

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top