I am needing to capture as much activity as I can within a database, and insert into a hidden table within the db.
you know how on all other microsoft apps you can run macros when the workbook/document etc is opened, is it possible that I can run a macro when the database is opened?
And the same on close? as in, i would like to set a variable when the user enters the database, and when they close, before close it writes the info to the table.
is this possible?
Visit my site: http://www.drybonesuk.com