MS Access

 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me



Go Back   Tutorialized ForumsDatabasesMS Access

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Tutorialized Forums Sponsor:
  #1  
Old May 11th, 2016, 11:28 AM
arjun5381 arjun5381 is offline
Registered User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: May 2016
Posts: 3 arjun5381 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 30 m 49 sec
Reputation Power: 0
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.

1st Table :
Code:
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 :
Code:
tblOnlineUsers (ORDER BY Online_Users_Name ASC)
Online_Users_Name
A
B
C
D
E



Required Result
Code:
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

Reply With Quote
Reply

Viewing: Tutorialized ForumsDatabasesMS Access > How To Allocate Tasks to Online Users In MS Access VBA 2007


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 

Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap