scheduled events

[bpaquette]

Picture this: a member of your squadron goes on Quarters (that is, they're on medical leave at home). They're on this for 72 hours. You have a field in your database called status wherein one of the values is Quarters. So on 1 Feb you set it to Quarters from Active. Is there any sort of tomfoolery or shenanigans I can perform to enter values on a limited basis? ie it will change back to whatever it was (or simply to whatever I define) in 72 hours?

Is such a thing possible? Or am I just a dreamer?


BP

 

[Mile-O]

UPDATE query that runs when the database is open.

The DateDiff() function...

 

[The_Doc_Man]

Or, if there is at least one machine running that is "awake" overnight and has Access installed and has rights on that system, you could look at the Access command line switch -x

That switch runs a macro. The macro could contain your update query and a Quit action.

Then put a command line in the night-shift machine's Windows Task Scheduler to run your query once per night.

If the machine ain't awake at the time, this won't work.