Satishwasamkar
Programmer
i wish to run micro at perticuler time to execute some append queries.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how can run micro automatically at perticuler time (ex daily 23:59hrs
- Thread starter Satishwasamkar
- Start date
- Status
The easiest way is to create a windows "Scheduled Task" that opens the database and fires the required Macro.
Set your task to run:
Ben
----------------------------------------------
Ben O'Hara
Set your task to run:
Code:
"C:\<Path to MSAccess.exe>" "<Path to database.mdb>" /x <name of macro>Ben
----------------------------------------------
Ben O'Hara
David W. Fenton said:
Yep!
If you use a split front-end/back-end solution, you can create a separate front end that contains the macro.
Just set the macro to run on the form load event and have that form be the one that the front end loads up on startup.
After the macro runs, just add another line to quit the application.
If you use a split front-end/back-end solution, you can create a separate front end that contains the macro.
Just set the macro to run on the form load event and have that form be the one that the front end loads up on startup.
After the macro runs, just add another line to quit the application.
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question