Display an hourglass while your Access application is running

Access may be loading or executing its macros when opened, but it's often hard to tell where it is in the process. In this tip from Mary Ann Richardson, learn how to set up Access to display an hourglass to let you know when it's safe to begin working.

You've set up your Access application so that when a user opens a form, a macro performs multiple actions first. Do your users complain that they're not sure when they can begin working, pressing keys or clicking menus while your macro is still executing?

Don't keep your users guessing as to how long an operation should take — let them know when they can begin working by having your macro display an hourglass while it is running and then beep when it's done. Follow these steps:

  1. In the Database window, click Macros under Objects.
  2. Select the macro and click the Design button.
  3. Right-click the first Action row and click Insert rows.
  4. Click the Action cell in the inserted row and select Hourglass from the drop-down list.
  5. Click a blank Action cell after the last command in the macro and select Beep from the drop-down list.
  6. Close and save the macro.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox