Community archive

Ask something
Discussion Locked

Access 2002

0 helpful
1 reply

by jan10_w

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

1 reply

by carquiza

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
DoEvents
MsgBox "It's time to take a break"
Loop
Finish = Timer

Mel:
Exit Sub
End Sub

Hope it helps.

This discussion is closed to new replies.