Auto Export Query
in [General]
|
From: AJOLSON on 28 Apr 2010 11:32 I would like have access import a file, then export a query based on that file. However I would like that to happen automatically, based on a recurring date and time. Say Every Monday Morning at 8:am. Can anyone point me in the right direction? I have the code to do it via a command button but I would like to automate it. Thanks
From: Arvin Meyer [MVP] on 28 Apr 2010 14:56 Either use the Windows Task Scheduler (this is preferred) to open a database front-end and accomplish the action, or leave a database open with the Timer event set to run if it's Monday 8:AM. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "AJOLSON" <AJOLSON(a)discussions.microsoft.com> wrote in message news:9D493A8B-4F10-4E28-A2B0-8EC497DDA1B6(a)microsoft.com... >I would like have access import a file, then export a query based on that > file. However I would like that to happen automatically, based on a > recurring date and time. Say Every Monday Morning at 8:am. > Can anyone point me in the right direction? > I have the code to do it via a command button but I would like to automate > it. Thanks >
From: ericsmith1172 via AccessMonster.com on 12 May 2010 09:14 I use the Windows Task Scheduler to run a macro in access at a certain point during the day/week. Although, my question related to this is how do I get MS Access to automatically name the file based on a date or time. Ex: I am exporting a numerical summary into excel automatically named "SumAVP. XLS" If I forget to pull the file or rename it, the next time the macro runs it will overwrite the original. I would like to see something like SumAVP(Date)(Time).XLS (SumAVP0512201091235.XLS) How can this be done? Arvin Meyer [MVP] wrote: >Either use the Windows Task Scheduler (this is preferred) to open a database >front-end and accomplish the action, or leave a database open with the Timer >event set to run if it's Monday 8:AM. >>I would like have access import a file, then export a query based on that >> file. However I would like that to happen automatically, based on a >> recurring date and time. Say Every Monday Morning at 8:am. >> Can anyone point me in the right direction? >> I have the code to do it via a command button but I would like to automate >> it. Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access/201005/1
|
Pages: 1 Prev: How do I "tie" fields together. Next: Moderator Bewerbung |