![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
Good afternoon everyone,
I am a beginner level Microsoft Access 2003 user. One of the questions raised at my work place was, "Would it possible to automate Microsoft Access 2003 to run a particular task on a scheduled time and date of each month?" For example, could Microsoft Access 2003 be run at 12:00 am midnight of the last calendar day of a given month (i.e. Jan 31, Feb 28, Mar 31, Apr 30, etc.)? Simply put, can Access be run at a pre-scheduled time automatcially? Thank you, SP |
#2
|
|||
|
|||
![]()
Yes! You can use the Windows Scheduler to open an Access application at a
prescheduled time. Then you can create an autoexec macro in the application to perform a certain task when the allication opens. Look in Windows Help for the Windows Scheduler and Access Help for the autoexec macro. Steve "SP" wrote in message ... Good afternoon everyone, I am a beginner level Microsoft Access 2003 user. One of the questions raised at my work place was, "Would it possible to automate Microsoft Access 2003 to run a particular task on a scheduled time and date of each month?" For example, could Microsoft Access 2003 be run at 12:00 am midnight of the last calendar day of a given month (i.e. Jan 31, Feb 28, Mar 31, Apr 30, etc.)? Simply put, can Access be run at a pre-scheduled time automatcially? Thank you, SP |
#3
|
|||
|
|||
![]()
Yes, you can run access at set times using windows task scheduler.
Another way, probably not as advisable, but possible, would be to have your db open on a machine and set a form's timer event to continuously check the date/time and execute your action per your code. But like I said, Task Scheduler is a better approach. -- Hope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access Tips and Examples: http://www.devhut.net Please rate this post using the vote buttons if it was helpful. "SP" wrote: Good afternoon everyone, I am a beginner level Microsoft Access 2003 user. One of the questions raised at my work place was, "Would it possible to automate Microsoft Access 2003 to run a particular task on a scheduled time and date of each month?" For example, could Microsoft Access 2003 be run at 12:00 am midnight of the last calendar day of a given month (i.e. Jan 31, Feb 28, Mar 31, Apr 30, etc.)? Simply put, can Access be run at a pre-scheduled time automatcially? Thank you, SP |
#4
|
|||
|
|||
![]()
Hi
Have a look at this post I made a while ago - it deals with one methods you can use to automate an access task using windows scheduler http://groups.google.com/group/micro...d542bc771f5144 Hope this helps -- Wayne Manchester, England. "SP" wrote: Good afternoon everyone, I am a beginner level Microsoft Access 2003 user. One of the questions raised at my work place was, "Would it possible to automate Microsoft Access 2003 to run a particular task on a scheduled time and date of each month?" For example, could Microsoft Access 2003 be run at 12:00 am midnight of the last calendar day of a given month (i.e. Jan 31, Feb 28, Mar 31, Apr 30, etc.)? Simply put, can Access be run at a pre-scheduled time automatcially? Thank you, SP |
Thread Tools | |
Display Modes | |
|
|