Is This Possible? Auto Refresh an Opened Report every "X" seconds

[RichardAnderson]

First let me warn everyone I am a newbie. I barely know Access and I know nothing about VB.

I am working on making a DB to use as a production schedule. tblBuilds holds a list of builds. I have several reports to show this list with different filters. One such report is rptBuildsToday. This report will be open on the production warehouse computer and displayed on a huge screen all day every day. Is it possible to make it so this report auto runs again every so often? When new builds are added to tblBuilds, or if a record on the table has its date changed to "today", It would be nice to have the report reflect this change within a certain time without having to manually refresh the report. The people looking at the screen will be doing so from their work benches and nowhere near the computer that has it opened.



If this is indeed possible, could the proposed method also work on a report or form inside the tab of a navigation control?

[June7]

Reports are not really intended for screen display of data just as forms are not intended for printing data. Both can be made to work like the other but results not always as nice. Report would have to rerun (closed and reopened) to requery its RecordSource and re-render sections. Forms, however, will automatically refresh according to frequency set by the database.

[RichardAnderson]

Reports are not really intended for screen display of data just as forms are not intended for printing data. Both can be made to work like the other but results not always as nice. Report would have to rerun (closed and reopened) to requery its RecordSource and re-render sections. Forms, however, will automatically refresh according to frequency set by the database.

OK great ... I will have to learn how to make a form read only for that active directory security group then.

Would you mind showing me how to set a form to auto refresh like you mentioned??

[June7]

Refresh is not a form or project setting. It is application setting: File > Options > Advanced > Advanced > Refresh Interval

I've never changed the refresh rate from the default setting.

Set a form as not editable with properties set to No:
AllowEdits
AllowAdditions
AllowDeletions

[RichardAnderson]

First I want to thank you for your replies. It means a lot.

Refresh is not a form or project setting. It is application setting: File > Options > Advanced > Advanced > Refresh Interval

I did this but it is not refreshing...

I made a multi items form called frmBuildsAll based off of tblBuilds. I had both open and when I made a change to tblBuilds I switched to frmBuildsAll and waited. Nothing changed.

Set a form as not editable with properties set to No:
AllowEdits
AllowAdditions
AllowDeletions

I will note this.. Thank you...

[RichardAnderson]

I got it!....

in the Form properties I had to make 2 changes...

1- Set Timer Interval to 10000 for 10 seconds
2- Put me.Requery in the OnTimer event procedure.

YAY! you put me on the right track and helped me know what to search for.
Thank You

[June7]

Interesting, I've never used timer event for any reason and certainly not for refresh. I see my forms refresh according to the application refresh settings.

[RuralGuy]

I got it!....

in the Form properties I had to make 2 changes...

1- Set Timer Interval to 10000 for 10 seconds
2- Put me.Requery in the OnTimer event procedure.

YAY! you put me on the right track and helped me know what to search for.
Thank You

Be advised that the default for ac2010 is probably 60 seconds (at least my ac2010 is) and the Timer event can cause some strange behavior on occasion and sucks up some additional CPU cycles.. The path in ac2010 is Options>Client Settings>Advanced
If this thread is Solved you can use the Thread Tools at the top of the thread to mark it solved.