We currently have over 800 forms in this company wide Access DB. We know many are not used.
What I would like to do, is capture the form load for every form that is opened and log, the form name and who opened it.
I don't know how in VBA I can subclass Form Load. Is there a way to do this?
My one though is to add a timer on the main form, that every x minutes, loops through all open forms and saves that to DB.
I am hoping to write one function that will do it, without having to past a function call in all 800 form loads.
Can someone show me exact code I would use to implement a global function such as this?