Track report runs

S

Sharsy

how would I go about...
to count number of times a user runs a report for a given period of time

I would like to be able to track this for each user acount and report
metrics on it regularly
 
J

John W. Vinson

how would I go about...
to count number of times a user runs a report for a given period of time

I would like to be able to track this for each user acount and report
metrics on it regularly
Click to expand...

You'll need to create a log table with fields for the userID, the date/time,
and probably the name of the report; and put VBA code in (say) the report's
Open event to open this table and add a record. You will probably need to
implement Access workgroup security and ensure that each user logs on with a
distinct ID in order to do this.
 
T

Tom Wickerath

To add some to John Vinson's answer, you can also grab the user's NTUserID in
lieu of implementing Access User Level Security (ULS) to grab the
CurrentUser(). Then have a field in the log table to track the NTUserID, date
& time (Now function), along with the name of the report.

Get Login name
http://www.mvps.org/access/api/api0008.htm


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Top