August 27, 200916 yr Is there an easy way to know when a layout was last accessed using the DDR? My reason for asking is that I create a lot of layouts that are for specific needs. These needs may not last more than a couple months. I don't typically get a "hey, we are done with that layout" comment so we just keep adding to the list. My only other idea aside from the DDR is to create a global field for each layout and have it update with a timestamp/account name using the "OnLayoutLoad" script trigger. That way I know if it has recently been used and who the last person to use it was. I can ask that person if they need it and if not I can remove it from the layout list. Ideas?
August 27, 200916 yr DDR, no. A global field will clear when you close the database, so you cannot use that, either. However, you could create a table just to store "layout use" and have the script that creates the audit record run onlayoutload.
Create an account or sign in to comment