PHONE SYSTEM ACCESS CODING - PHONE #'s = TERRITORY

[beckycarter04]

I have built a form database and it is linked to a phone caller ID system. I need a validation IF code that is "if the caller id prefix starts with a 613476 than it screen pops a "Quinte territory" etc. I have approx 200 different phone 3's and approx 40 different territory's.

I have the system popping exisitng customers and new cusotmers but it won't indicate territory - any help would be appreciated.

[Scott Price]

A bit more information is needed, Becky!

Are you currently using VBA code for the validation that you are doing?

What kind of a 'screen pop' do you want: a popup message box, filled out label on a form, etc??

Welcome to the Scripts!

Regards,
Scott

[beckycarter04]

No message is needed

Basically the system (which we have) will look at the number and if it starts with 613476 the form will load with the Quinte territory information. I have the form popping when the phone rings to a blank screen or to a past cusotmer phone number record, but I need it to identify a prefix to a territory.

I am just building events through VB.

Any sugestion and help would be great.

[beckycarter04]

P.S - the pop up needs is an unedited form that indicated name/ address/ pre-recorded comments etc.

So a call centre setup for the custome rthinks they are calling down the road but they can be thousand miles away.

[Scott Price]

OK,

I assume your prefix data is stored in a table?

You are using a query that looks at the incoming call?

I'm sorry, but your information is too vague to give much help! Please post any relevant code that you are using, any relevant SQL query that you are using, and the table structure that you have.

Thanks!

Regards,
Scott