Results 1 to 9 of 9
  1. #1
    gint32 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jan 2015
    Location
    Australia
    Posts
    116

    Time delay action

    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 :


    1. Combo to select the user
    2. Field for Start-date and End-date
    3. Security level present
    4. 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

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    no code but a suggested method

    have a separate table to contain userID, security level and start end dates.

    tblUserTimes
    userID...securitylevel...startdate..enddate
    1...……….1...………………..1/1/2019..1/31/2019
    1...……….2...………………..2/1/2019..3/31/2019
    1...……….1...………………..4/1/2019...null

    then your query would be something like

    SELECT userID, securitylevel
    FROM tblUserTimes
    WHERE Date() Between startdate and nz(enddate,date())

  3. #3
    gint32 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jan 2015
    Location
    Australia
    Posts
    116
    Thanks for your reply, looking for a solution though to manage the auto-reset back to original without admin/user intervention...meaning when it reaches the end date reset automatically....then the only way you'll know is when the specific user asks "hey!! can you give me another week please!"

  4. #4
    gint32 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jan 2015
    Location
    Australia
    Posts
    116
    Quote Originally Posted by gint32 View Post
    Thanks for your reply, looking for a solution though to manage the auto-reset back to original without admin/user intervention...meaning when it reaches the end date reset automatically....then the only way you'll know is when the specific user asks "hey!! can you give me another week please!"
    Reposted here...https://www.utteraccess.com/forum/in...wtopic=2052442

  5. #5
    gint32 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jan 2015
    Location
    Australia
    Posts
    116
    Just for future programmers having the same issue,


    FYI...After some more though, I think i have cracked this with a simple method, which is to catch the user at the point of login using a dlookup & checking todays date against the EndDate and if so action accordingly.


    everyone !!!! Whats your thoughts?? on this solution or do you have a better easier one?

  6. #6
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    that is basically what I was suggesting - except i provided a query to execute rather than dlookup. Your requirement was short on detail so I didn't specify when or how you would use it

  7. #7
    gint32 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jan 2015
    Location
    Australia
    Posts
    116
    Quote Originally Posted by Ajax View Post
    that is basically what I was suggesting - except i provided a query to execute rather than dlookup. Your requirement was short on detail so I didn't specify when or how you would use it
    Many Thanks, for your input and help with this

  8. #8
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Seems reasonable to check the "user" security at time of login.
    How often do these temp security assignments occur?
    My guess is that you assign/remove these temp assignments through an admin routine.

  9. #9
    gint32 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jan 2015
    Location
    Australia
    Posts
    116
    There are about 25 users(officers) out of a possible 400 on any given week. That act up in higher positions some for months others for just a few days. It depends entirely on staffing levels at that time, which makes it difficult to manage. This is why I needed some way of setting a temp security settings at time of logon (automation) for a specific period with little monitoring once set.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 10-21-2014, 12:25 PM
  2. Replies: 3
    Last Post: 09-02-2014, 06:45 PM
  3. Replies: 6
    Last Post: 11-28-2012, 03:43 PM
  4. Replies: 15
    Last Post: 07-26-2012, 02:06 PM
  5. Replies: 7
    Last Post: 07-18-2012, 07:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums