I have an Access 2007 application that displays a work queue for approx 4 customer service reps. Each record in the queue represents an existing customer that must be contacted and demographics updated. How do I prevent the same record from being seen by more than one cs rep at a time? I am confident in the row/page locking mechanism once a cs rep starts an update process. It is too late if a second cs rep has seen the same record and has already started a phone call. Is there a data/row property or flag that is changed when the record is viewed in a form? Any suggestions for building that mechanism? One suggestion was to pass OnLoad Filters in the Access RunTime startup that seperate the work queue by the first letter of the customers last name. Is that the best way?
Thank you,
bgroves
9  4965 
Unsure on how useful this would be in your situation however just an idea to throw in to the mix. I would go about this by having a table in the back end which on form opening checks to see if a value is present within a field for that form name. If there is not then write a value there and continue on. If there is a value there then close the form and bring up a message saying a user is already within the record pick the next in the que.
Then on the close of the form the value can be deleted out. Im sure there are other ways of doing it but that is the general principle I would use. Check if a value is assigned in someplace before the record can be opened fully.
Meh just realised you are on about specific records, my idea would get very messy.
Thanks. I'll start looking at this but it does not sound like you are offended if I leave it open for additional suggestions.
NeoPa 32,568
Recognized Expert Moderator MVP
I guess you're talking about a queue where items are only assigned to a rep once they go to pick them up? No prior association with the customer is defined?
@NeoPa
That is correct. In essence FIFO. The queue is ordered by ID number and they are displayed in that order. No associations or filtering at this point.
NeoPa 32,568
Recognized Expert Moderator MVP
And would there be rules to determine that a lead, once seen by a rep, was automatically assigned to them? Or would it go back into the queue if the first rep decided he didn't like the look of it?
The latter would be pretty messy and harder work, but probably possible.
@NeoPa
We assume once it is viewed, it will be handled / flagged / assigned and out of the queue. I think I should keep it simple until I get a Phase 1 solution.
Thanks,
bgroves
NeoPa 32,568
Recognized Expert Moderator MVP
Presumably then, you would have all available items from the FIFO queue showing for each rep. This is not very practical as all items would immediately be assigned to the first rep to open the form.
Alternatively perhaps, a single item view on the form could be used and the item could be assigned to the rep as soon as it's shown. To allow this to work, the query supporting the form would need to return a single item only, otherwise other reps may never have already assigned items removed from their queues. Assigning the displayed item to a rep would involve some code that changed the assignment value (and saved the record) running in the Current event procedure.
Does this sound like the sort of thing you're looking for? It's not an easy thing to implement but it seems there are ways that it can be made to work.
NeoPa - Thanks for the idea. I have some rework to incorporate your idea. The Data Source for my original form was CustomerTable. It would only show 1 of 2000 recs at at time. I migrated into using the word/concept "assigned". When I first posted, I was thinking & hoping for something like a "view lock" but now based on the suggestions from you and munkee,this needs to be handled with specific form queries and flags in the data row.
I will work on:
1.View - Select top 1 from CustomerTable where AssignedFlag is Null
2. Event- On Current - Update CustomerTable
set AssignedFlag = UserId
I believe this is what you are suggesting.
Thanks,
bgroves
NeoPa 32,568
Recognized Expert Moderator MVP
That's pretty well what I was coming to, assuming you answered as you now have.
You would need also to save the record immediately the flag has been set (Form_Current event procedure), and you'd probably need another form that allows a rep to review all the items that are already assigned to them.
It sounds like you understand the workings now though :)
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: me |
last post by:
How do I prevent the save/print/email/mypictures toolbar from popping up
when IE users place their cursor over photos at my website? Thank you in
advance for your help.
Signed,
me
|
by: Jorge Godoy |
last post by:
Hi.
I have created an interface where I have a QDataBrowser and all of its
editing and navigating controls and one of the displayed controls is in a
QSpinBox.
I have the navigation from current to next and previous records working fine
if I only use the data browser controls. I also can recover the correct
record if I type in a valid code at the spin box.
|
by: suffrinmick |
last post by:
Hi everyone!
I (Along with the help of some of you guys!) have managed to get a
query working which takes multiple values (types of organisation) from
a list box.
The query returns a list of contacts (tblContacts.ContactID, LastName
etc. ) who are linked to these particular organisations.
Some of the contacts are linked to more than one organisation and
|
by: Jim M |
last post by:
Two questions:
1) I have a scheduling application (Access 2002) that allows multiple
staff members to edit notes on their meetings and appointments from
their offices. A receptionist views a limited dataset of all of their
appointments and changes the status of an appointment to "Show" as
clients come in the door. She keeps a form open all day that lists that
day's appointments for all staff in chronological order.
Once in a while,...
|
by: cbremar |
last post by:
Is there a way to do this. Currently, you can have multiple users
editing the same record and not until they try to save it does it tell
you that the record is being edited by another person. I want to make
the record 'non-viewable' is it's already being edited by another user.
Can anyone help?
| | |
by: Womble One |
last post by:
Is there any way to get the 'Obsolete' attribute to work across multiple
solutions?
I currently have 70 solutions, each with 3 projects in them, and would like
to change some base architecture, letting the app developers fix their own
code over time.
It works great in the first solution, but any solution consuming classes
defined in an earlier solution does not respond to the attribute at all.
|
by: Christopher Lusardi |
last post by:
How can I prevent multible people, who use my program at the exact same
time, from overwritting textfiles? E.G.: Two users start the same
program and one deletes something but the other saves his data and
undoes the delete that was done!
Also, what about databases being overwritten at the same time. How can
I prevent users from interfering with each other?
Thank you,
Christopher Lusardi
|
by: slider |
last post by:
Hey all i am using Access 2003 on Win Xp and i have been trying to make this code send emails to the users stored on each record. So far is works, except in the body of the email i need it to say a number of things, such as Dear (user), your current quota is (quota), and so on.
So far i can send the emails to multiple users but when it comes down to writing the message i cannot enter in more than one "rec("field)".
In my database i have...
|
by: Kalaine |
last post by:
MSAccess 2003:
Users tab through the data entry fields on a form, and accidently tab to the next record thereby erroneously inserting a record. What can I code in the Form_BeforeInsert to prevent the insert from happening?
Private Sub Form_BeforeInsert()
If MsgBox("Do you want to save the new BSR record " & Me.BSR_ID & " and all associated offers and price plan?", vbYesNo) = vbNo Then
'What can I code here to prevent the...
|
by: paul |
last post by:
A crude, unlikely scenario just so I can get my head around this:
Split DB; front end back end. Each user has the FE locally the BE is
stored on a server.
1. UserA opens customerA's record and edits the telephone number.
2. UserB opens the same form and tries to navigate to customerA's
record.
At this point I want to inform UserB that the record is locked. How do
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |
