General discussion


Access 2002

By jan10_w ·
Do you know how to get an email notification or a prompt in Access 2002, reminding you to do a certain task? I?m using a database in Access to keep track of my projects at work but I would like to get an email or some sort of prompt reminding me toupdate my info in the database. If so, does Access need to be open before the prompt can be sent?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Visual Basic

by carquiza In reply to Access 2002

Hi Jan10,

Do you know Visual Basic?
Here is a simple code on VBA insert on Access.
Create a Module

Sub Message()
Dim Start, Finish, PauseTime
PauseTime = 100
Start = Timer
Do While Timer < Start + PauseTime
MsgBox "It's time to take a break"
Finish = Timer

Exit Sub
End Sub

Hope it helps.

Related Discussions

Related Forums