MattBaldry
Self Taught, Learn from the Forums
- Local time
- Today, 05:34
- Joined
- Feb 5, 2019
- Messages
- 325
Hi All,
I am in the process of generating various statistic forms and charts that we want display on an information screen for our factory floor. I am after some advice on how to change the displayed form on a time loop. I have created a table that will list all the forms, their display order and time they should stay open for.
How would I then go about changing the form once it has been opened for the set amount of time?
So in the example above, frmDisplay1 would open and set a text box to current time +2 minutes. Once it gets to that time, change to frmDisplay2 for 5 minutes. Then frmDisplay3 for 3 minutes, and then back to the start.
The data will be live so I believe an access form is the best way to go for it to always be up to date.
Or, is there a better way to do this?
~Matt
I am in the process of generating various statistic forms and charts that we want display on an information screen for our factory floor. I am after some advice on how to change the displayed form on a time loop. I have created a table that will list all the forms, their display order and time they should stay open for.
How would I then go about changing the form once it has been opened for the set amount of time?
FormID | FormName | FormDescription | FormOrder | FormTime |
---|---|---|---|---|
1 | frmDisplay1 | Form 1 | 1 | 2 |
2 | frmDisplay2 | Form 2 | 2 | 5 |
3 | frmDisplay3 | Form 3 | 3 | 3 |
So in the example above, frmDisplay1 would open and set a text box to current time +2 minutes. Once it gets to that time, change to frmDisplay2 for 5 minutes. Then frmDisplay3 for 3 minutes, and then back to the start.
The data will be live so I believe an access form is the best way to go for it to always be up to date.
Or, is there a better way to do this?
~Matt