Is it possible to refresh/requery an open report

[alexfwalker]

I have a database which I keep open all day - it monitors parcels available for picking and despatch. I've just managed to sort it out so that the data in the tables is refreshed every five minutes, but now I'd like to be able to open the report, leave it open and see changes as they happen.

Is it possible therefore to refresh or requery a report (excepting of course that it can be closed and reopened) automatically?

 

[vbaInet]

If you're using Access 2007 and above then you will be able to do it using Report View only. In other versions it's not possible without re-opening the report.

You do it by calling the report's Requery method. The On Timer event will allow you run the code every 5 mins.

 

[alexfwalker]

If you're using Access 2007 and above then you will be able to do it using Report View only. In other versions it's not possible without re-opening the report.

You do it by calling the report's Requery method. The On Timer event will allow you run the code every 5 mins.

Sadly I'm only on 2003! I think I may have to open and close to refresh.

 

[vbaInet]

Or just use a form.

 

[alexfwalker]

Or just use a form.

Yes, I'd considered that and it may be the route that I have to go. There are some graphical elements in the report which are useful and I'd like to retain, but I may choose to forego that in favour of putting it in a form.

 

[vbaInet]

You can still create graphs in forms.

See how it goes.