Re: Date Query

On Tue, 27 Dec 2005 17:26:58 GMT, "SJJ via AccessMonster.com"
<u16634@uwe> wrote:

>thanks a lot john. it works :)
>
>one more question please.
>
>how do u run a query for every fortnight on a monday.

Use the Windows Scheduler to open Access (set the schedule there). Run
the query from a Macro (named RQ let's say); in the command line in
the scheduler, open the macro with the X command line switch:

"C:\Program Files\Office\msaccess.exe" "K:\path\yourdata.mdb" /x RQ


John W. Vinson[MVP]
.

Relevant Pages

  • Visible Command Button
    ... I have a command button which has a macro running in it. ... an update query would run... ...
    (comp.databases.ms-access)
  • Re: VB Macro Command to close MS Access application
    ... You did not mention the details of what the scheduler actually does, nor the details of your macro, and I don't know how the VBA code comes into it. ... "Scheduler" option available in Windows XP. ... Will "DoCmd.Quit" command not close the application completely. ...
    (microsoft.public.access.macros)
  • Re: Automatic Regular Macro Running
    ... Is it possible to have a Macro that runs (importing tables) at a specific ... You can use Windows Scheduler (in Administrative Tools under Start... ... and use a command line switch /x RunStuff in the ...
    (microsoft.public.access.gettingstarted)
  • Re: Receiving an error when scheduling Macros from Windows Task schedu
    ... Steve Schapel, Microsoft Access MVP ... command from access, but when I use the windows task scheduler to run this macro I receive a warning, stating: If you're running a Visual basic module that is using OLE or DDE, you may need to interrupt the module. ...
    (microsoft.public.access.macros)
  • Re: Run Macro Problems
    ... even if the query or table has only one record (as I presume is the case ... > a macro to send an email to certain persons. ... > In the macro we are using the SendObject command to send ... In the second macro we are using the ...
    (microsoft.public.access.macros)
Loading