You could put code in the On Open event of all 400 reports to write to a table
to count each time it was opened.
Moe Napper <[EMAIL PROTECTED]> wrote: I have an Access database with 400+
reports. I want to start
consolidating reports, but I don't know what reports are being used the
most. Is there something I can do to capture how often a report is
opened? For a few reports I put a little piece of code in the OnOpen to
update a table with the report name and the user who opened it, but
because I have so mane reports I don't want to edit each one to insert
this piece of code.
I simply want to know what the most popular reports are in my
system....Any ideas?
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "ms_access" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us
---------------------------------
Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays,
whatever.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
