Form calculations

  • Thread starter Thread starter tommal
  • Start date Start date
T

tommal

I have a form that calculates totals when it is opened. I do not want the
user to be able to do anything until the form completly calculates, this may
take up to 10 seconds. how do I keep the user from clicking on anything
until the form is calculated?
 
tommal said:
I have a form that calculates totals when it is opened. I do not want the
user to be able to do anything until the form completly calculates, this
may
take up to 10 seconds. how do I keep the user from clicking on anything
until the form is calculated?
Click to expand...
 
tommal said:
I have a form that calculates totals when it is opened. I do not want the
user to be able to do anything until the form completly calculates, this
may
take up to 10 seconds. how do I keep the user from clicking on anything
until the form is calculated?
Click to expand...
 
This turns the hourglass on, but how do I keep them from doing anything and
how does it know when to turn back to the mouse pointer?
 
Hi

You can use DoEvent but a simple trick is to open a popup with the words
"please wait" - have the form close on timer after 5 or 10 seconds or
whatever.
Make sure you open the the popup in mondal only that why the user can't do
anything until it closes.

Docmd.OpenForm "YourPopUpForm", , , , ,acDialog

Dead simple
 
Back
Top