Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1129
  • Last Modified:

How to enable auto refresh of an Access Form

I have a database which is updated by a few users on the network, but all day a form is shown on a monitor which is connected to a pc just showing a form view for everyone to read.

This is fine but someone has to manually click the mouse to enable the form to get the latest data which has been inputted by others. This is a very simple database with one table and the one tabular form displaying the info. I assume I need to add a macro or something with a timer in to enable the form to be refreshed every minute or something like that?

Thanks,
Andrew,
0
andrew_2706
Asked:
andrew_2706
1 Solution
 
ldunscombeCommented:
In the Timer event of your form

me.requery

then in the Timer interval property enter a number to indicate how often you want it to run 1000 = 1 second so for a minute try 60000 as the value.

0
 
andrew_2706Author Commented:
Excellent - thank you so very much.

Regards,
Andrew.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now