Results 1 to 4 of 4
  1. #1
    Alongi
    Guest

    Is there a autoaction based on time

    Need to know if it is possable to have a series of reports to run automaticly in access2000 with out promting the user to do it and have it based on a time of say as in

    If it is 6 am in the morning automaticly run such and such reports.

    Dom

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is there a autoaction based on time

    Hi Dom,

    There have been several threads discussing automating things in Access to happen at a certain time. The best way I would recommend is to create a macro for the desired process, then use the Windows Task Scheduler and an Access Command-Line switch to have the process run at a desired time. For example, if your macro is named "mcrPrintMorningReports" you could put the following command line in the Windows Task Scheduler (for 6AM every weekday):<pre>"C:Program FilesMicrosoft OfficeOfficeMSAccess.exe /x mcrPrintMorningReports"</pre>

    Post back if you need more info...HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

  3. #3
    Alongi
    Guest

    Re: Is there a autoaction based on time

    MarkJ

    THANK YOU VERY MUCH

    That saves me alot work soon as I try it. Now I just need to get them to get the actions they want me to do for it.

    Dom

  4. #4
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is there a autoaction based on time

    Good Morning,

    I am currently running reports and other tasks by using the Scheduler program which you can download for free from ..<A target="_blank" HREF=http://www.mvps.org/access/>http://www.mvps.org/access/</A>.

    What I did was write a public function to determine what day it was and in the OnOpen event of a hidden form, which is loaded OnOpen of the db, is call the public function. After the reports print, a PrintLog is updated with what reports were printed and when. A dialog also informs of the reports that printed, I click OK...the db closes...until the next day. This way the REPORTS db could house ALL reports that are printed progmatically.

    The scheduler program knows what day, time and database to open...then Access does the rest...

    Hope this helps and good luck.
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •