schedule a macro to run

[aftershokk]

I want a macro to run every day at 7:30am with no manual intervention.

Can this be completed n Access?

 

[jfgambit]

You need to set-up a Scheduled Task in Windows:

Start>Control Panel>Scheduled Tasks

to open the database at a specific time.

Then call your Macro AutoExec.

Access will run any AutoExec macro automatically on start-up

HTH

 

[aftershokk]

response

I use autoexec for opening the DB.
other thoughts?

 

[jfgambit]

What do you mean you use AutoExec for openeing the db?

What are you doing on the Opening of the DB? Perhaps we can convert that to code.

 

[aftershokk]

something small

my switchboard form never maximizes so I run an auto-exec

 

[jfgambit]

On the On Open Event of the Switchboad form add

Docmd.Maximize

Then you can do away with the AutoExec.

 

[aftershokk]

what about?

my auto exec contains an 5 e-mails, I will not be in too prompt them? is there a way around this

 

[jfgambit]

Aftershock...

Could you restate that...sorry, but what you wrote looks a little confusing.

Thanks

 

[aftershokk]

form

The docommand on my form does not work because it does not allow the buutons on my form to work. I believe auto exec works when the database is opened and I do not want this to run every time it opens. Only one time a day.
thanks,

 

[Tezcatlipoca]

Hmmm...I understand what aftershokk is saying, but am not too sure that a scheduled task (such as running a Macro) can be done from within Access.

Aftershokk, jfgambit is quite right about a regular task being best handled by Windows' own task scheduler, but it may not be the best option for you.

Perhaps if you tell us exactly what you want this scheduled Macro to do, we can better assist you.

 

[aftershokk]

response

every morning at 8:00am (only once a day) I want a macro to automatically run.

it imports a file
renames files
updates records
runs queries and
send reports via outlook

right now I have to actually be at the PC and click my button to run the macro every day

we need it to be automated in case workers come in very early and need to see these reports

i hope this helps!
thanks,

 

[jfgambit]

Since you are already running an AutoExec in the main database, create an additional database that points to the main one and set-up you AutoExec Macro to import your information, and run the updates from the new db.

Then you can use Windows Task Scheduler to Open the database everyday at 8:00 am

HTH

 

[jeff_i]

You can call the macro something other than autoexec then edit the task to use a command line switch to run a macro.

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\yourdatabase.mdb" /wrkgrp "C:\program files\common files\system\system.mdw" /User Admin /pwd /x mrc939

mrc939 is the name of the macro to run

 

[aftershokk]

I cannot get this to run in the scheduler:


"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE\network\Mrk04\MrktDB\brian.mdb\x mrcDaily Run"

network = a location on the network

thanks,