Yes/No MsgBox

[Pietro]

Hi,
I,ve form that shows a Yes/No MsgBox,i want this message to beavailable
for 10 seconds only,if users don't press on "Yes" the message is closed and
[forms]![wt]![up]=Now()
How can i do this?

 

[Daniel Pineault]

Create a form the way you would like, then use the timer event to trigger
your automatic close.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[John W. Vinson]

Hi,
I,ve form that shows a Yes/No MsgBox,i want this message to beavailable
for 10 seconds only,if users don't press on "Yes" the message is closed and
[forms]![wt]![up]=Now()
How can i do this?

You can't, with a Msgbox control. Do as Daniel suggests and create a small
unbound form to do so. Set its Timer property to 10000 (10,000 milliseconds =
10 seconds) and put code in its Timer event:

Private Sub Form_Timer()
Me!up = Now
DoCmd.Close acForm, Me.Name
End Sub