Hello every one:
I am doing a small project using Ms Access. I don't know how to get system time and use it in Event function. For example, there is a due time in database(oct 10,2001), I will be get a notice at 1 week ago, so it should give me warning on oct 3,2001.

Another problem is how to change some record background color when some event happens.