Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2012
    Posts
    3

    Unanswered: How To Allocate Tasks to Online Users In MS Access VBA 2007

    Dear All,

    I need your help to solve my problem, I have 2 Tables : (1st ) tblTaskDetails (2nd ) tblOnlineUsers as below sample data

    I want to allocate all pending Accounts Numbers to All Online Users, Suppose 10 Accounts are pending for user allocation and currently 3 users are online in the system, then the system will automatically allocate these 3 online users to pending Accounts equally but most important there sequence like users A,B,C,A,B,C,A,B,C etc as like below Required Result.

    Please refer attached Image file for your reference.

    1st Table : tblTaskDetails (ORDER BY INCIDENT_DATE ASC)
    Account_Number INCIDENT_DATE
    201200178 04-Apr-16 07:34:09 AM
    921858299 04-Apr-16 08:25:43 AM
    990990101 05-Apr-16 09:28:03 AM
    990990151 05-Apr-16 09:33:03 AM
    990246967 05-Apr-16 09:45:08 AM
    990226021 05-Apr-16 10:04:10 AM

    2nd Table : tblOnlineUsers (ORDER BY Online_Users_Name ASC)
    Online_Users_Name
    A
    B
    C
    D
    E


    Required Result
    Account Number INCIDENT DATE If 1 User Online If 2 Users Online If 3 Users Online If 4 Users Online
    201200178 04-Apr-16 07:34:09 AM A A A A
    921858299 04-Apr-16 08:25:43 AM A B B B
    990990101 04-Apr-16 09:28:03 AM A A C C
    990990151 05-Apr-16 09:33:03 AM A B A D
    990246967 05-Apr-16 09:45:08 AM A A B A
    990226021 05-Apr-16 10:04:10 AM A B C B
    948104306 05-Apr-16 10:29:18 AM A A A C
    920617566 05-Apr-16 10:31:52 AM A B B D
    920621842 05-Apr-16 10:33:14 AM A A C A
    920844782 05-Apr-16 10:47:25 AM A B A B
    936251646 05-Apr-16 11:01:30 AM A A B C
    943999521 05-Apr-16 11:03:59 AM A B C D
    991007397 05-Apr-16 11:06:34 AM A A A A
    921511542 06-Apr-16 11:23:45 AM A B B B
    944568550 06-Apr-16 11:24:10 AM A A C C
    921511542 06-Apr-16 11:24:14 AM A B A D
    909774256 06-Apr-16 11:31:02 AM A A B A
    921773014 06-Apr-16 11:32:31 AM A B C B
    988250007 07-Apr-16 11:34:58 AM A A A C
    921779722 08-Apr-16 11:44:23 AM A B B D
    991025088 08-Apr-16 11:58:41 AM A A C A
    921841541 08-Apr-16 11:58:44 AM A B A B
    Attached Thumbnails Attached Thumbnails How To Allocate Tasks to Online Users In MS Access VBA 2007.png  

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    I think you going have to do some HARD HARD codeing to fix your problem

    as the data has no relationship to each other but only has relationship to each after the fact


    also you say

    3 online users to pending Accounts equally but most important there sequence like users A,B,C,A,B,C,A,B,C etc as like below Required Result.
    but i only that pattem in 2 col of the 4

    am i mising something
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    May 2016
    Posts
    89
    Provided Answers: 4
    Hi arjun5381

    For information, how do you know how many users were connected when an incident occurred?

Posting Permissions

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