Create a new form or open an existing form you want to use for this purpose.
Change to design view and go to the Properties sheet. It should appear automatically but if not click the Properties Sheet button on the Design ribbon.
Click the Other tab on the Properties sheet and change the Popup property to Yes. The form will then appear on top of any other open form.
Optionally also change the Modal property to Yes. Doing that will prevent users clicking on any other form whilst the modal form is open.
Now go to the Event tab and change the timer interval to 5000 (5 seconds) then add an Event procedure to the On Timer property
The VBA editor will open to the Form_Timer event. Add code like this in the event procedure
Code:
Private Sub Form_Timer()
DoCmd.GoToRecord,,acNext
End Sub
Save your form and return to Form view.
Now the form will cycle through each record until the last BUT will then show error 2105 - can't go to the selected record (as there are no more records)
To solve that, add error handling e.g. This will cause the code to loop back to the First record.
Code:
Private Sub Form_Timer()
On Error GoTo Err_Handler
DoCmd.GoToRecord , , acNext
Exit_Handler:
Exit Sub
Err_Handler:
If Err = 2105 Then DoCmd.GoToRecord , , acFirst 'return to first record
GoTo Exit_Handler
End Sub