I am working on a system with an Excel front-end, using an access database (connecting using DAO)
I am trying to add logging (description of changes in a 'logs' table) using access macros, and need to add current users username.
I know you can do this a VBA function, but these don't seem to run when i edit the db from Excel VBA. Is there someway to get username using a Access macro? Or get VBA code to run?
thankful for any help...