How to run a Query at specific hour??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RicardoLH - 08 Mar 2007 21:52 GMT

Someone knows how do this:??
1.- Start Access at specific time lets say 20:00
2.- Run a make table query
3.- Exit Access

I was looking for OnTime event such as is in Excel with no success, can
someone give a clue??

Signature

+RL

Reply to this Message

Trever B - 09 Mar 2007 00:11 GMT

Hi,

Try this

1) Write a mdb that on startup runs a from.
2) In on open run the query in vba
3) on the oncurrent event quit the database.

This should run your task whenever you want. (This is all the database does)

To run it at a specific time do following.

Look at system tools in programs of windows and run schedule tasks to open
your file at a time requested.

Hope this helps

Trev

> Someone knows how do this:??
> 1.- Start Access at specific time lets say 20:00
[quoted text clipped - 3 lines]
> I was looking for OnTime event such as is in Excel with no success, can
> someone give a clue??

Reply to this Message