I've been messing around trying to get the hourglass to start while I am in Access, and continue while I am in Excel.

IE) I have a report form in Access. When the user clicks "Print Report", it brings up the hour glass, opens excel, and starts populating a report in excel.

The problem is, when excel opens, the hourglass goes away. I have tried looking up the hourglass method to see if there is a solution, but I couldnt find one.

I would post my code, but its mostly just the printing of the report. The line I am trying to use right now is

VB Code:
  1. DoCmd.Hourglass True

Any help, even a keyword to search would be very much appreciated