Export Access to Excel and monitor live?

[Sharpie King]

I am making a database to track service calls. The supervisor wants to view
summary information of the calls not cleared on a large screen monitor on the
wall through excel . This will all be on a shared drive. Supervisor also has
a specific visual layout on how he wants to view the information on the wall
monitor. He wants to have the information live or autoupdated , so that he
may monitor the service calls. Where do I start, and is there a place I can
read process steps or something that will help me through the development of
this export?

 

[Klatuu]

Create a form, probably datasheet, that will present the information the
supervisor wants to see.
Use the Timer event of the form to requery the form at whatever interval is
desired.

 

[Klatuu]

P.S. This is all in Access. You don't need to use Excel. Using Excel would
only make the process slower.

 

[Sharpie King]

Thank you. I will try it out.

Create a form, probably datasheet, that will present the information the
supervisor wants to see.
Use the Timer event of the form to requery the form at whatever interval is
desired.