If you need to print out an Access report by 10:00 every Friday morning, you don't have to do it manually. Follow these steps to create a macro to print the report and schedule it to run at that time — automatically.
If you need to print out an Access report by 10:00 every Friday morning, you don't have to do it manually. Follow these steps to create a macro to print the report and schedule it to automatically run at that time:
- Open the database that contains the report.
- In the Database window, click Macro Under Objects.
- Click the Design button.
- Click in the first cell under Commands and select OpenReport.
- In the Action Arguments, click the Name Of Report box and select the name of the report you want to schedule.
- Save your macro.
- Go to Windows Explorer and open the folder where you want to save the macro shortcut.
- Right-click the Windows taskbar and click Tile Windows Vertically.
- Drag the icon of the macro you created from the Database window to the opened folder on your desktop.
- Close both windows.
- Click the Start button, click All Programs, point to Accessories, point to System Tools, and then click Scheduled Tasks.
- Double-click Add Scheduled Tasks and then click Next.
- Click the Browse button.
- Navigate to the folder containing the shortcut to the macro command and select it.
- Click Open and then click Next.
- Click Daily.
- Click the arrows of the Start Time box until you reach 10:00 AM. Click Next.
- Enter your password in the Password text box.
- Enter your password in the Confirm Password text box and click Next.
- Click Finish.
Miss an Access 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.