Auto update/refresh report

[Guest]

Is there a way to make a report automatically refresh the data? We're trying
to put together a status board, with multiple columns. The only way I've
been able to figure out how to make multiple columns is in a report, but then
I don't know how to make the report automatically refresh the data every five
seconds or so.

I've been told a form might be the way to go, but I don't know how to make a
form display multiple columns in form view. I've figured out how to make it
display columns if I go in print view, but we want this to be a status board
that we display on the wall and leave open.

 

[Guest]

Hi JCricket,

Have a form that is set to display in "continuous forms" mode, and put your
fields horizontally across the form in the Details section. This will
display your data in column format.

To force a refresh, you could use the On Timer event to call me.refresh or
me.requery, setting the timer interval to 5000 (5 seconds).

Hope this helps.

Damian.

 

[Guest]

I think I didn't quite describe what I'm doing right... I'm trying to get
multiple columns in the forms display, so that it will make a column down the
left side until it reaches the bottom of the page, then starts another column
in the middle, etc.

I'm not that well versed in the programming side of things... how would I
put that refresh code into the report?

 

[Guest]

Hi again,

To set columns for your report/form, go to file->page setup->columns

You can't have a report that auto refreshes - it's a snapshot in time.
Hence I suggested you might like to use a form to achieve the display of the
items. You would use the code like this: In the on Timer event for your
form, put the following code:

me.requery
me.refresh

In the Timer Interval section, put 5000 (which is 5 seconds).

Hope that helps.

Damian.

 

[Rick Brandt]

I think I didn't quite describe what I'm doing right... I'm trying to
get multiple columns in the forms display, so that it will make a
column down the left side until it reaches the bottom of the page,
then starts another column in the middle, etc.

I'm not that well versed in the programming side of things... how
would I put that refresh code into the report?

You cannot unless you are satisfied with closing it and then re-opening it on a
Timer event.

If you can logically divide the data into 3 or 4 sub-units you could use a form
with multiple ListBoxes or multiple sub-forms where each displays a "column" of
data by filtering on one of the units of records. A form that just wraps based
on form boundaries like a report is not possible unless you perhaps use some
sort of ActiveX control.