That's exactly what I do in situations like this. Use the Windows Task Scheduler to open a database (or version of the database -- different front end if needed) that automatically runs the query (using either the autoexec macro or by setting a startup form and then entering VBA code in the Open event of that form).
HTH, Toby ----- Original Message ----- From: "jmw95823" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, August 23, 2005 2:12 PM Subject: [AccessDevelopers] Auto-Make Table Same Time Each Month Is it possible to run a make table query in an Access db that will run by itself based on date and time (whether the db is open or not)? I need to make a table each month of current staff salaries for that month. I would like to do it programmatically to ensure it doesn't get forgotten prior to entering new salaries for the next month. Is this something I would need to set up in Windows Task Scheduler?.. possibly set to open an Access db that would run the query from autoexec and then quit? Thanks for any help. Jim Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h57qs68/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124839342/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font> --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
