Hi Everyone,
Within my DB users, the current setup has users with different levels of security set 0-4, what I am trying to figure out is a way of implementing a date/time reset & revert back on these levels if they are (temp)amended.
example: If a particular employees security level needs to be temporarily increased for a short time, reasons he/she is acting up in a higher position say for (1wk), then I hope/wish I can find a way that'll it'll revert back to that users original level after this time period has elapsed.
I imagine I'll need a new table to hold this info and a form with :
- Combo to select the user
- Field for Start-date and End-date
- Security level present
- Security level Temp
Time delay ...No idea!
Has anyone had a similar issue or does anyone have any code or methods that i may be able to tweak.
Any input will be greatly appreciated
Thanks for reading