I would like to have a query run automatically each morning and export
onto my office share drive. I cant figure out how to set a timer of
some sort to schedule the daily run.

Is this something that can be done easily with a Macro or in some
other way in Access?

On Wed, 07 Nov 2007 01:00:23 -0000, (E-Mail Removed) wrote:

>I would like to have a query run automatically each morning and export
>onto my office share drive. I cant figure out how to set a timer of
>some sort to schedule the daily run.
>
>Is this something that can be done easily with a Macro or in some
>other way in Access?

It's really easier to use Windows Scheduler to launch Access to run it. You
can have a Macro (one of the few cases I use macros) that launches the query
or code and then exits, and use the /x macroname command line switch to run
the query in the Scheduler command line. It would be something like

"%programfiles%\Microsoft Office\Office11\msaccess.exe"
"K:\somepath\yourdata.mdb" /excl /x macroname


John W. Vinson [MVP]

hi John,

I understand your idea, and it sounds great. I only know how to launch a
file by using Windows Scheduler.

but i have no idea how to let it run a Macro.


and i do not understand the command line code that you have written. Will
you kindly explain it.

thanks a lot john !

--
Allen Phailat Wongakanit


"John W. Vinson" wrote:

> On Wed, 07 Nov 2007 01:00:23 -0000, (E-Mail Removed) wrote:
>
> >I would like to have a query run automatically each morning and export
> >onto my office share drive. I cant figure out how to set a timer of
> >some sort to schedule the daily run.
> >
> >Is this something that can be done easily with a Macro or in some
> >other way in Access?
>
> It's really easier to use Windows Scheduler to launch Access to run it. You
> can have a Macro (one of the few cases I use macros) that launches the query
> or code and then exits, and use the /x macroname command line switch to run
> the query in the Scheduler command line. It would be something like
>
> "%programfiles%\Microsoft Office\Office11\msaccess.exe"
> "K:\somepath\yourdata.mdb" /excl /x macroname
>
>
> John W. Vinson [MVP]
>