var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
How would you automatically send an email to certain user when a deadline is set in the database?eg..when an error is due to be fixed?
The link above would help with the emailing portion of your problem.
In regards to your automating problem, I have a batch file on a server that is run nightly via Window's scheduled tasks program. The batch file is something along the lines of:
I have a macro that calls a function which calcualtes who needs emails and then sends those emails. The last thing the macro does is a .quit to exit msaccess.
"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "c:\my.mdb" /x "macro_name"