[AccessD] Report Statistics in Access 97

Simplest approach, I think, would be to just create a form, with a timer set
with an interval of 1.  Create a custom collection or array, and compare it
to reports.  That would 'should' allow you to 'catch' all instances of what
is running, without having to modify any of the reports themselves.

Of course this is clunky, but it wouldn't really bog a system down that
much, you're just doing a little 'checking'.  I didn't say it was elegant
though! <grin>

Drew

-----Original Message-----
From: Marcus, Scott (GEAE, RHI Consulting)
[mailto:scott.marcus at ae.ge.com]
Sent: Thursday, April 24, 2003 6:24 AM
To: 'accessd at databaseadvisors.com'
Subject: [AccessD] Report Statistics in Access 97


I need to track statistics on reports, such as who ran it, how many times
the
report has been run, etc... This is an Access 97 application that is being
converted to another technology and the team wants to prioritize the
conversion
of hundreds of reports. Does anyone know a way to eaisly automate this? I'm
wondering if a framework class will do, or if I should write code that
appends
code to each reports "On Open" event. Many of these reports(if not all) will
have existing code behind the report. Any ideas, pointers or even code would
be
much appreciated.

Thanks in advance,

Scott
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com