Results 1 to 5 of 5

Thread: User history: last five accessed records
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2009
    Posts
    111
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default User history: last five accessed records

    For a database I'm working on at work, I've been asked whether it'd be possible to implement something along the following lines: a drop-down box that lists the last 10 accessed records for a user. It doesn't matter whether they were edited, as we often consult the database for information, and I don't even think the list of recent records would need to be stored beyond the current session (though if it was, that'd also be okay).

    I have a couple of ideas - pretty vague ones right now, since I've only just arrived at the office and I've got a heap of other things to get through, as Access isn't really what I was hired to do - but I was thinking that this might be the kind of function that is requested or used quite frequently, so I wanted to ask the community here if you have any pointers for me. I've done a Google search, but I wasn't particularly successful.

  2. #2
    Board Regular
    Join Date
    Jul 2010
    Posts
    398
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: User history: last five accessed records

    Seen this done a couple of ways, probably the most straight forward is on the 'on open' event, append a record to a history table - (UserID, RecordID and a way of sorting them - current Date & time or AutoID).

    Then just have the row source of the combo as select top 5 query with the criteria being the active user.

    Another way I have seen it done is using the registry to store the information... It means that if a user accesses from different machines the list they see will be different. It is also cumbersome as you need to either shift the records each time or bring them into code ans sort them. It can be quite a good method for storing machine specific settings though.

  3. #3
    Board Regular
    Join Date
    Jun 2009
    Posts
    111
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: User history: last five accessed records

    Thanks, those are good starting points. One thing I was wondering: even though we're obviously a split database, is it possible to add a user-specific table to the front-end?

  4. #4
    Board Regular
    Join Date
    Jul 2010
    Posts
    398
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: User history: last five accessed records

    Yeah - it is quite common to have at least one user specific table in the FE - this is often used to check the version of the FE matches the latest version. Holding the history there would be ok, however, it does mean using different machines would show different history (similar to the registry method).

  5. #5
    Board Regular
    Join Date
    Jun 2009
    Posts
    111
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: User history: last five accessed records

    Thanks, that's useful to know. It shouldn't be a problem in our case, as we tend to have personalised, tweaked FEs that are stored on a network drive, so people would have the same history regardless of the PC they're accessing the DB from. (It's quite possible that some or all of this goes against Access best practices, but we're all self-taught dabblers in Access... )

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •