Community

General discussion

Gravatar
0 Votes
Locked

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

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

Mel:
Exit Sub
End Sub

Hope it helps.

Back to Community Forum

Start or search

Related Discussions

Related Forums