Google Answers: Timer event to refresh a database form

View Question

Q: Timer event to refresh a database form ( No Answer, 1 Comment )

Question

Subject: Timer event to refresh a database form
Category: Computers > Programming
Asked by: amy123456-ga
List Price: $25.00

Posted: 15 Jun 2005 08:12 PDT
Expires: 20 Jun 2005 19:45 PDT
Question ID: 533522

Timer event to refresh a database form  in access.

Answer

There is no answer at this time.

Comments

Subject: Re: Timer event to refresh a database form
From: soneji-ga on 16 Jun 2005 13:14 PDT

Create a new form using the designer
Press F4 and click Event Tab, look for Timer Interval Set it to 10000
Click on the Form and press F7.
Go to Code View and paste the following
Private Sub Form_Timer()
    Me.Refresh
End Sub

That should refresh your form every 10 seconds.
Timer Interval is set in milliseconds

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.

Search Google Answers for

Google Home - Answers FAQ - Terms of Service - Privacy Policy