simulating telesales operation

[prodigy]

I have developed a MS-Access application for a small call-center (20 users).with approx 1500 customer-records to call everyday.
What I have done:
There are 20 front-ends residing at the Telecallers desktop and 1 database@server. Presently I am allocating 1500 records (clients send 1500 data everyday) everyday to 20 telecallers so that they get their respective calling details (75 records/telecaller). The no of cases that they need to call is predetermined.
They see cust-details and call up the customer manually.
What I intend to do:
I don’t want to allocate records to telecallers. Instead, when they open the FE-screen they will get the record that is available. (Of course keeping in mind that no particular record is opened by more than 1 telecaller).
Any help in this regard is highly appreciated. Any idea will encourage me to make the application more pro.

 

[Pat Hartman]

Use a query that uses the TOP 1 predicate to select only a single record. Sort the recordset ascending or descending depending on which record you want to choose. Update the selected record with the ID of the person to whom it is assigned. You might also want to timestamp the assigned date/time field.

Your query will only select unassigned records. Add a button to the form. When the caller is ready for the next record, have them push the button to run the query to update the assignment field and then open the form to that record.

 

[prodigy]

Thanking Pat

Hi Pat Hartman,
I have gone through ur reply. The idea/concept that you have helped me with is wonderful. I appreciate that you have taken up time replying the issue in such an easy manner. I will try as you have advised. Thanks.

 

[Rich1968]

Operators tools

I finally figured this out.

Using Pats suggestions. I could not get this to work with requery. So I set up the following.

Create a Macro. Call it Next Record

1. Set warning to "NO"
2. Close form
3. Run query
4. Open form
5. Close query

Create a button. Set to "Next Record"

It Works!

Now if anyone can help me with code to do the same, I would be grateful!

Pat, Sincere thanks for your being the super moderator!

Rich1968