How on earth do I do this?????

[rnickels]

I would like to know if it is possible to have a query automatically run on the first day of each month. I want to be able to enter data into a table automatically using a query on the first day. I would prefer not to use Windows Task Scheduler as I will be distributing this database and want Access itself to automate the process

This would help me so much.

Rob

 

[ajetrumpet]

You could write a simple IF, THEN statement in an AutoExec Macro to check the current date. That would work if you are wanting this process to run when you start the program.

 

[pdx_man]

If you don't have a scheduled Windows task, then how can you ensure the database is open and working on the first day of the month?

Basically you need to ensure a form is open and have the timer event set to check if Day(Date()) = 1

 

[boblarson]

And then you have to set a flag, or something, in a table that would let you know it has already run for that month so it wouldn't do it every time.

Plus, what if you don't open it on the first (for example if it were a holiday or a weekend)? You would need the logic for it to check to see if it has run yet this month, regardless of what day it was. If it was, say Monday the 2nd, then it could run and then set the flag and not run again until it was the next month. But you would need to tell it how to determine what is next month.

 

[Guus2005]

Seeing the subject of the thread i thought : "Hey i know that!"
Only to find that three other guys also knew that...

Good luck!