Flash in Taskbar on MsgBox

W

Widemonk

I have added to my form this piece of code to regularly prompt users to close
the database allowing me to make updates... and so far it works perfectly.
-------------------------
Private Sub Form_Timer()
mytimer = mytimer + 1
If mytimer > 240 Then
If MsgBox("This database has now been open for over 4 minutes." &
vbNewLine & "Have you finished your work and " _
& "would you like to close it ?", vbYesNo + vbCritical) = vbNo Then
mytimer = 1
Else
DoCmd.RunMacro "Exit"
End If
End If
End Sub
-------------------------

My question is, if a user is using another application, can i make Access
flash in the task bar (in the sameway Outlook does on a new message or when
the Excel Autosave prompt shows) ???

Thanks very much.
 
Top