|
||||||
Greetings. I need to fire an Update Query in Microsoft Access at midnight, every night. I figure Task Schedular is what I'm looking for. I've set up a reminder to |
Microsoft OS Forum to Usenet Gateway is a gateway to Microsoft Windows operating system newsgroups. If you use Windows XP, Windows Vista or any other Microsoft Operating System then this is the community for you.
You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!
If you have any problems with the registration process or your account login, please contact us.
Once you register you'll stop seeing this message.
You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!
If you have any problems with the registration process or your account login, please contact us.
Once you register you'll stop seeing this message.
 |
|
|
Thread Tools | Display Modes |
10-14-2008, 09:29 AM
|
#1 | ||
|
Guest
Posts: n/a
|
Greetings.
I need to fire an Update Query in Microsoft Access at midnight, every night. I figure Task Schedular is what I'm looking for. I've set up a reminder to pop up on my screen everyday at midnight. This becomes an issue on nights I've had too much to drink!! Can I make Schedular run an update query in Access at a set time everyday? I haven't a clue how to program, but if someone could point me to some links..or better yet...give me some examples of what I need to do...I would be most grateful. Thank you ahead of time. -- Big Beu |
||
    
|
|
10-14-2008, 11:22 AM
|
#2 | ||
|
Guest
Posts: n/a
|
You would need to write a script to run the update. You would need to
understand the use of the Application Object in Access http://msdn.microsoft.com/en-us/libr...76(VS.60).aspx -- Please use the Communities guidelines when posting. http://www.microsoft.com/wn3/locales...help_en-us.htm Use the "Ratings" feature. It helps the new users. Mark L. Ferguson MS-MVP https://mvp.support.microsoft.com/profile/Mark.Ferguson "Beuferd" <beuferd74@yahoo.com> wrote in message news:443DFC22-8AD8-4215-AB1B-CD1490DCFF77@microsoft.com... > Greetings. > > I need to fire an Update Query in Microsoft Access at midnight, every > night. > > I figure Task Schedular is what I'm looking for. > > I've set up a reminder to pop up on my screen everyday at midnight. > > This becomes an issue on nights I've had too much to drink!! > > Can I make Schedular run an update query in Access at a set time everyday? > I haven't a clue how to program, but if someone could point me to some > links..or better yet...give me some examples of what I need to do...I > would > be most grateful. > > Thank you ahead of time. > -- > Big Beu |
||
|
|
|
| Tags |
| access, schedular, task |
«
Previous Thread
|
Next Thread
»
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Schedular just won't work | livetohike | Windows XP | 5 | 06-05-2008 02:04 PM |
| scheduled task can not access shared drive | powdered_toast_man | Windows 2000 Workstation | 13 | 06-04-2008 11:00 AM |
| Auto entry of Tasks in Windows Task Schedular using Vbscript...? | oc9ine | Windows XP | 1 | 05-18-2008 05:49 AM |
| ntbackup can't find tapestreamer from commandline/schedular | freaky | Windows 2003 Server | 3 | 08-20-2007 11:29 AM |
| access denied - in task manager | Wisperer | Windows Vista | 2 | 08-14-2007 07:50 AM |
This is a Schwarz Network site.