Andrea:
Put a subform (Tasks due) in your starting page, the one that opens
first when you open your database (Switchboard or similar)
If you want to enter your tasks due separately you need a "Tasks"
table with fields for Date (Date/time), Time (Date/Time), Done (Yes/No check
box), and a Notes (Text with at least a 200 field size).
Put a condition in the underlining query to the field "Done" to be
No. Also an Event Procedure in the Current property of the form to
Me.Requery
So you enter your tasks by date and as you do them they get ticked
and disapear, making roon for the undone ones.
If all you use is your Contacts table and it is connected to a tasks
table, the same thing will also show your contact name with both tables as
the Record Source for the subform.I found that by entering the tasks
manually I can use it for any tasks, not just the ones relating contacts.
Once you get used to check them it works fine.
Additionally you can add a reminder to the "Open" property of the
Switchboard form to popup a message telling you to check your appointments
every time there is an outstanding task., for instance:
Private Sub Form_Open(Cancel As Integer)
If [Tasks due]![Date] < Date Then
MsgBox "There are outstanding tasks, please have a look. If they are
completed then tick the Done box. If they are not then leave them as they
are. This is only a reminder, thank you."
End If
End Sub
You could also run the Open event on the form timer and have it run
every hour for instance. Then it'll remind you of hourly appointments, not
just daily ones!
You could do the setting of new tasks with a popup form with a
calendar control in it and a tasks subform with Date;Done as the
Child/Master fields. An option box will let you see day tasks or tasks done
only, or all tasks too. I love this popup because it looks like Outlook. For
this you have to set event procedures for the Option box that change the
values of the Child/Master fields.
You could also have a small popup form to show instead of the MsgBox
where you could tick of the tasks as you do or acknowledge them. For this
you have to create the popup form based on the tasks or Contacts table and
make it open instead of the message box example above.
Hope it helps,
Phil
Is there a place I can set up a reminder alarm for notes.
Example: I need to call someone in a week from my contact
list. Something similar to Outlook calendar
