Timer before report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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/
 
Back
Top