Form calculations

[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?

 

[Wayne-I-M]

try this

http://msdn.microsoft.com/en-us/library/aa212420(office.11).aspx

 

[hor vannara]

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?

 

[hor vannara]

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]

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?

 

[Wayne-I-M]

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