I'm trying to create a sort of dialer but I dont want the same person to be dialed on the same day.
I have been able to link it to my customerID and the randomizer works fine and doesnt do 2 in a row but there is a possibility of it happening later in the day.
This is what I am using at the moment to assign the dialer to a customer.
MemID is just a public integer
ALL is the Maximum number of records I have
I've also experimented on using a query to generate and reorganise my records. I'm having issues then assigning this to Customer.Value so it can be shown on my Form in the order it was placed.
Any help would be appreciated
I have been able to link it to my customerID and the randomizer works fine and doesnt do 2 in a row but there is a possibility of it happening later in the day.
This is what I am using at the moment to assign the dialer to a customer.
Code:
Public Sub RandomCustomer()
Dim ALL As Double, R As Integer
ALL = MAX.Value
R = (ALL - 1) * Rnd() + 1
Do While R = MemId
R = (ALL - 1) * Rnd() + 1
Loop
Customer.Value = R
End Sub
MemID is just a public integer
ALL is the Maximum number of records I have
I've also experimented on using a query to generate and reorganise my records. I'm having issues then assigning this to Customer.Value so it can be shown on my Form in the order it was placed.
Any help would be appreciated