Forms restart automatically - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Forms restart automatically

Masih Ostad Novin

3 years ago

Hi.
Is there a way that a form or subform can restart or refresh itself automatically without closing and loading it? I have a database that is always open and I want it to refresh itself everyday when the date changes. Can we do it by event programming?
Thanks.
Best, Masih

	Kevin Robertson @Reply 3 years ago
You can set up a Timer() event to Refresh or Requery the form at a specific time of day. Richard doesn't have a specific Timer() event (yet) but it is covered in the following videos: Flashing Text Reminder Popup Reminder Popup Date

	Juan C Rivera @Reply 3 years ago
Requery in Place Try this and see if it helps. V/r Juan

	Gregory Clancey @Reply 3 years ago
manually press F5?

	Masih Ostad Novin OP @Reply 3 years ago
Is this code good enough? Private Sub Form_Timer() If Date = Date Then Me.Requery End If End Sub

	Kevin Robertson @Reply 3 years ago
Here's I would do it. First set the Timer Interval to 1000 In the Form_Timer() event: `If Hour(Time()) = 0 And Minute(Time()) = 0 And Second(Time()) = 0 Then Me.Requery End If` Notes: This will requery the form at midnight. Adjust to the time you want it to run. Make sure it runs at a time when no-one is using the database.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View