andreylungu
New member
- Local time
- Today, 13:46
- Joined
- Jul 15, 2015
- Messages
- 4
Hello,
I created an Access Web App for tasks management in which i also have a Tasks Audit Table. When a task from the Tasks table is modified, i created an ON UPTADE macro which creates a new row in the Tasks Audit table with the "Task ID", "Old Status" and "New Status", "Old Deadline" and "New Deadline". (usind the .old function)
Because all users can modify the tasks, it is necessary to have also a column with "Modified by" where to put the username who made the modification.
I tried 3 days to find a solution for this issue but i cannot find a way how to grab the username from UI (where I have it with the userdisplayname() function) and to put it in the Tasks Audit Table. It is very frustrating, because i have it there, but only can't write it
I attached a printscreen with the On Update macro from Tasks table.
Does anyone have a solution for this ? I also searched on google but didn't find someting to solve it..
Thanks a lot !
I created an Access Web App for tasks management in which i also have a Tasks Audit Table. When a task from the Tasks table is modified, i created an ON UPTADE macro which creates a new row in the Tasks Audit table with the "Task ID", "Old Status" and "New Status", "Old Deadline" and "New Deadline". (usind the .old function)
Because all users can modify the tasks, it is necessary to have also a column with "Modified by" where to put the username who made the modification.
I tried 3 days to find a solution for this issue but i cannot find a way how to grab the username from UI (where I have it with the userdisplayname() function) and to put it in the Tasks Audit Table. It is very frustrating, because i have it there, but only can't write it
I attached a printscreen with the On Update macro from Tasks table.
Does anyone have a solution for this ? I also searched on google but didn't find someting to solve it..
Thanks a lot !