{"id":42,"date":"2007-10-17T06:08:14","date_gmt":"2007-10-17T10:08:14","guid":{"rendered":"http:\/\/alsplace.aldenbaker.com\/alsplace\/ms-access\/42\/have-access-automatically-print-your-reports\/"},"modified":"2007-10-17T06:08:14","modified_gmt":"2007-10-17T10:08:14","slug":"have-access-automatically-print-your-reports","status":"publish","type":"post","link":"https:\/\/alsplace.info\/?p=42","title":{"rendered":"Have Access automatically print your reports"},"content":{"rendered":"\n\n

Date<\/span>: October 16th, 2007<\/p>\n

Author<\/span>: Mary Ann Richardson<\/p>\n

 <\/p>\n

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:<\/p>\n

 <\/p>\n

    \n
  1. Open the database that contains the report.<\/li>\n
  2. In the Database window, click Macro Under Objects.<\/li>\n
  3. Click the Design button.<\/li>\n
  4. Click in the first cell under Commands and select OpenReport.<\/li>\n
  5. In the Action Arguments, click the Name Of Report box and select the name of the report you want to schedule.<\/li>\n
  6. Save your macro.<\/li>\n
  7. Go to Windows Explorer and open the folder where you want to save the macro shortcut.<\/li>\n
  8. Right-click the Windows taskbar and click Tile Windows Vertically.<\/li>\n
  9. Drag the icon of the macro you created from the Database window to the opened folder on your desktop.<\/li>\n
  10. Close both windows.<\/li>\n
  11. Click the Start button, click All Programs, point to Accessories, point to System Tools, and then click Scheduled Tasks.<\/li>\n
  12. Double-click Add Scheduled Tasks and then click Next.<\/li>\n
  13. cialis 2.5mg<\/a> Verdana”>Click the Browse button.<\/li>\n
  14. Navigate to the folder containing the shortcut to the macro command and select it.<\/li>\n
  15. Click Open and then click Next.<\/li>\n
  16. Click Daily.<\/li>\n
  17. Click the arrows of the Start Time box until you reach 10:00 AM. Click Next.<\/li>\n
  18. Enter your password in the Password text box.<\/li>\n
  19. Enter your password in the Confirm Password text box and click Next.<\/li>\n
  20. Click Finish.<\/li>\n<\/ol>\n

     <\/p>\n

    Miss an Access tip?<\/p>\n

    Check out the Microsoft Access<\/span><\/a> <\/span><\/a>archive<\/span><\/a>, and catch up on our most recent Access tips.<\/p>\n

     <\/p>\n

    Pasted from <http:\/\/blogs.techrepublic.com.com\/msoffice\/?p=299&tag=nl.e056<\/a>><\/p>\n

     <\/p>\n\n

    \nBookmark to:<\/em><\/strong><\/a>\n
    \n
    \n
    \n
    \n    Hide Sites<\/a>\n<\/div>\n<\/div>\n\n