Auto-update table possible?

[Slippenos]

I have a db: front-end is web-based and back-end is MSAccess.

I created a utility that tracks when employees are late.
If they are late, they receive 4 pts. This data is inputted on Monday:

-The date last week when they were late
-The amount of points (sometimes its more than 4).

When they accumulate 20 points- they receieve their first warning.

As it stands, I have 2 tables: an employee table and a tracker table.

At the end of the week (Sunday) I would like to be able to fire a query or insert a record into a table that sums up last week's absence time (no human intervention).

What I'm looking for is an auto-updated record insertion.
I was thinking a third table- Warnings. This is where the record would be inserted.

Is this possible?
Any thoughts or suggestions are greatly appreciated.

[blue]Go to work to learn. Don't go to work to earn.[/blue]

 

[dhookom]

This isn't possible in an Access table. You could use the Windows scheduler to open and Access mdb and run a macro that would append records to a table.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Slippenos]

Right. I was thinking something along those lines as well. Thanks.

[blue]Go to work to learn. Don't go to work to earn.[/blue]

 

[mp9]

Also look at Handy Access Launcher for scheduling tasks within Access - can be used to run macros (which in turn can run VBA) at set intervals, as well as perform db admin tasks. HAL can be obtained from

http://www22.brinkster.com/accessory/resources/001.html

 

[Slippenos]

Yes- good suggestion.

I did find something similar. I can use the scheduled task manager to fire a macro like so:

"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\YourDB.mdb" /x NameOfMacro

Or I can use the scheduled task manager to open my db and execute VBA code and run a scheduled procedure; similar to this procedure in Excel:

[URL unfurl="true"]http://www.vbaexpress.com/kb/getarticle.php?kb_id=162[/url]

Thanks for the post.



[blue]Go to work to learn. Don't go to work to earn.[/blue]