Export Access to Excel and monitor live?

  • Thread starter Thread starter Sharpie King
  • Start date Start date
S

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?
 
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.
 
P.S. This is all in Access. You don't need to use Excel. Using Excel would
only make the process slower.
 
Thank you. I will try it out.

Klatuu said:
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.
Click to expand...
 
Back
Top