Share via

auto refresh access report

Anonymous
2012-06-12T07:17:39+00:00

i have created report in Access 2007 . when my report is open if i enter data from Form it need to update My report also every 10 sec how i can create a vb code for this

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-06-12T18:53:00+00:00

    Reports in Print Preview don't really have that feature, you are supposed to close the report and reopen it.  That's not always ideal in your kind of situation because the screen flashing can be more than a little anoying and reloading the report sometimes has a noticable delay.

    BUT, for a report  already open in print preview, you can change its Filter, FilterON, OrderBY or OrderByOn property and magically the report will reload its dataset and rerun all its code including the Open event procedure.

    IF, and this is a big IF, you can figure out what Report View is doing and how to make it work for your purposes, then you can just requery the report.

    Either way, the code would go in your form's timer event procedure.

    Was this answer helpful?

    0 comments