Results 1 to 4 of 4
  1. #1
    rmoreno is offline Advanced Beginner
    Windows XP Access 2000
    Join Date
    Apr 2013
    Posts
    51

    Run Code Module Automatically

    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.

  2. #2
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    Please give us a little more detail as to what you want or are trying to do.

    I am a little lost.

    Dale

  3. #3
    rmoreno is offline Advanced Beginner
    Windows XP Access 2000
    Join Date
    Apr 2013
    Posts
    51
    What I am needing help with is a timer code module that will run another code module every 15 minutes and upon database startup.

  4. #4
    rmoreno is offline Advanced Beginner
    Windows XP Access 2000
    Join Date
    Apr 2013
    Posts
    51
    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?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Running Code from a Module in a Macro
    By ReadyReckoners in forum Modules
    Replies: 2
    Last Post: 05-08-2013, 04:45 AM
  2. Replies: 4
    Last Post: 07-13-2012, 06:30 AM
  3. Code to automatically set date on form
    By meissnerb in forum Programming
    Replies: 1
    Last Post: 05-03-2012, 02:47 PM
  4. Saving Module Code to Text Files
    By ioMatt in forum Modules
    Replies: 2
    Last Post: 07-02-2011, 08:18 AM
  5. Replies: 3
    Last Post: 10-15-2010, 11:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums