How to measure Report Usage

  • Thread starter Thread starter August West
  • Start date Start date
A

August West

I would like to add some kind of counter to keep track of how many
times a report is used. I work for a company that has a ton of reports
in MS Access, and only about 10% are used at one time...but no one will
confess as to which reports are important.

This would help us pin point which ones are being used. Thanks for any
insight.
-August
 
August said:
I would like to add some kind of counter to keep track of how many
times a report is used. I work for a company that has a ton of reports
in MS Access, and only about 10% are used at one time...but no one will
confess as to which reports are important.
Click to expand...


Add some VBA code to the report's Open event to log each
report's use.

Create a new table named ReportUsage with two fields,
RptName, a text field for the report name, and UseDate, a
Date/Time field for the time the report was opened. Set the
UseDate field's DefaultValue to Now().

The code in each report's Open event would be:

CurrentDb.Execute "INSERT INTO ReportUsage (RptName) " _
& " VALUES(""" & Me.Name & """)"

When you want to check the usage you can then run some kind
of variation of this query to provide the statistics:

SELECT MSysObjects.[Name] As ReportName,
Count(*) As Usage,
Max(ReportUsage.UseDate) As LastUsed
FROM MSysObjectsLEFT JOIN ReportUsage
ON MSysObjects.[Name] = ReportUsage.RptName
WHERE MSysObjects.[Type] = -32764
 
Back
Top