A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Is it possible to run Access Database at a pre-set time?



 
 
Thread Tools Display Modes
  #1  
Old April 22nd, 2010, 07:14 PM posted to microsoft.public.access
SP
external usenet poster
 
Posts: 43
Default Is it possible to run Access Database at a pre-set time?

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  
Old April 22nd, 2010, 07:24 PM posted to microsoft.public.access
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Is it possible to run Access Database at a pre-set time?

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  
Old April 22nd, 2010, 07:35 PM posted to microsoft.public.access
Daniel Pineault
external usenet poster
 
Posts: 658
Default Is it possible to run Access Database at a pre-set time?

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  
Old April 22nd, 2010, 08:00 PM posted to microsoft.public.access
Wayne-I-M
external usenet poster
 
Posts: 3,674
Default Is it possible to run Access Database at a pre-set time?

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.