Timer before report

[Guest]

My reports take a minute before someone can view them. Can i add a timer/egg
timer or something that will tell the user that it is loading.

Please reply the steps in detail and basic

 

[Mark]

Hi,

The code to change the mouse cursor to an hourglass is:

DoCmd.Hourglass True

To set it back to normal:

DoCmd.Hourglass False

You can also enter a message in the status bar using:

SysCmd acSysCmdSetStatus, "The report is loading please wait..."

To clear the message:

SysCmd acSysCmdClearStatus

HTH


--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/