I need to run a code module to regenerate a query SQL whenever a new table is created, but to also regen automatically every 15 minutes.
I need to run a code module to regenerate a query SQL whenever a new table is created, but to also regen automatically every 15 minutes.
Please give us a little more detail as to what you want or are trying to do.
I am a little lost.
Dale
What I am needing help with is a timer code module that will run another code module every 15 minutes and upon database startup.
OK. Maybe I need to describe my problem in greater detail. I have an Access database. In this database I have a code module that when run will read certain table files and combine them into a single query. I would like some help in writing a timer module that will refresh the query data every 15 minutes. The query is tied to an Excel spreadsheet for graphing purposes and therefore the Access database does not use any forms so I cannot use the form timer function. Does anyone have any ideas how to set up a timer module to run my query update code?