Question about MS Access

[DaveJP7232]

Hello, I hope someone can help me. I'm designing a Billing/Collection System with MS Access 2000 (which I'm new to), I've had some experience with Oracle PL/SQL but very little with Access & VB.
I need text to be entered in a "notes" field (for an existing record) when a customer's due date is a certain number of days away (60 days before due date "call customer to ensure satisfaction", 30 days before, "mail invoice"). I created a form in Access that contains text boxes with the "notes" and "due_date" fields (and others of course) but I can only figure out how to build an event that updates the notes field when the due_date field is entered as a new record (using an afterUpdate event). I need the notes field to be updated automatically for the due_date fields that already exist within the database. If anyone can help me out, I would greatly appreciate it, thanks, Dave

[opel]

Hi Dave,

I run lots of 'auto tasks' on my company access databases and have always found the easiest way is to create either a macro or a module(called from a macro) which does the work and then on the server/pc thats never turned off set a scheduled task,

ie:
C:\PROGRA~1\MICROS~3\Office\MSACCESS.EXE i:\choice\contracts.mdb /x reminder

the macro : reminder
in the database : contracts.mdb
is scheduled to run on the 1st of every month.

This is a great way to set it and forget it,
I have built into the macro error handling as well so that should the macro/module fail -I get an email telling me the database name, macro name and the error, so I can sort out the problem.

Also, I would advise to start with have the macro/module send you an email to let you know it worked!

hope this helps.