Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-20-2006, 11:55 AM   #1
utopianbl
Registered User
 
Join Date: Jul 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
utopianbl is on a distinguished road
Running an automated Query created in MSACCESS

Hello All,

I am new here and new to Access.

I have created a query which allows me to schedule daily events. But I want to automate this. Let me explain what i am trying to do.

Every morning at 7 am I want this query to run and the output of which to be mailed to myself. All this without me having to hit any button of sorts.

I have a long shot but very inefficient answer to this - which would be - having to leave my MS ACCESS running all night with an infinite loop checking to see what the system time is. When the infinite loop equates to 7 am it runs the query. But I think this would be a massive memory guzzler and I don't like this solution. Is there something else I can do?

Thanks for you time.

Regards

utopianbl is offline   Reply With Quote
Old 07-20-2006, 12:00 PM   #2
KeithG
AWF VIP
 
KeithG's Avatar
 
Join Date: Mar 2006
Location: Illinois
Posts: 2,592
Thanks: 0
Thanked 4 Times in 4 Posts
KeithG will become famous soon enough KeithG will become famous soon enough
You could use the On_Timer event on a form. You can write code to check to see if the current time is 7:00 every Hour, minute, or five minutes. Use the timer interval property to set the length of the timer.

Last edited by KeithG; 07-20-2006 at 12:06 PM.
KeithG is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a Auto increment Text/Number elliotth123 Tables 13 05-17-2013 08:30 AM
Running a query produce "square" sign mart1122 Queries 0 05-29-2006 10:35 AM
variation of Running Sum in query lizhaskin Queries 6 09-18-2003 05:41 AM
running a query from form teiben Queries 3 02-12-2003 10:00 AM
Created a query but calulated fields don't show chablups Forms 2 02-10-2002 10:56 PM




All times are GMT -8. The time now is 05:15 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World