Thanks for the quick and thorough reply, Toby. Will do. Thanks for the extra tip. Jim --- In [email protected], "Toby Bierly" <[EMAIL PROTECTED]> wrote: > 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=12hstrkrh/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124839773/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</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/
