setting a reminder

P

paulxmw

hi,
im trying to set a reminder based on a date which I type into a field called
"transd" what I would like is 30 days after the date I typed in a message box
or feild box would pop up and tell me that i need to look at the "name"
displayed so something like this. I thought but Im well off target ,lol.

if transdate =Date. >="30"
Mesagebox [name]" notify mesage"

I hope some takes pitty on me and helps, thanks
 
O

Ofer

What happen after you get a reminder, do you get it again the next day?
Can you have more then one reminder?
How do you start your mdb, autoexec macro or a start up form?
What is the name of the table, the date field and the name field?
 
A

Allen Browne

Create a table to handle the reminder messages.
The fields might be:
ReminderID AutoNumber primary key.
transd Date/Time when the reminder should be shown
Message Text the reminder message.
IsCompleted Yes/No A way to mark the reminder as done.

Create a continuous form to show the reminder messages. It will be based on
a query such as this:
SELECT tblRemind.* FROM tblRemind
WHERE (transd <= Date()) AND (IsCompleted = False);

Open this form to show the reminders at the time you desire. For example,
you could use the AutoExec macro to OpenForm.

To suppress the display of the form if there are no reminders, cancel the
form's Open event. The Event Procedure to silently suppress the opening of
the form would look like this:
Private Sub Form_Open(Cancel As Integer)
If Me.RecordsetClone.RecordCount = 0 Then
Cancel = True
End If
End Sub

You could spruce the form up by adding a command button to postpone the
reminder, by using DateAdd(), e.g.:
Me.transd = DateAdd("d", 1, Me.transd)
 
Top