Microsoft Access - Update Company Records based on Phone Numbers
Greetings!
We have a Microsoft Access Database with an SQL backed that we use in house for managing our ticketing system. A former employee put it together, we love it, it has worked great for years.
I'd like to preface this with the fact that I myself don't know much about programming or Access, but just enough to figure things out as we'd like to add to or modify the program. Oddly, it has become fun and educational to figure it out on my own.
I am a little stuck on one item that we'd like to implement.
We have a form called "Phone Calls" which pulls records from a table called "CDR". Within this database, there is a field called "SRC" that contains the Caller ID number of a client who called.
I would like to be able to click on the "SRC" field within this form, and have a macro/vb script/something allow me to take the phone number that is in the "SRC" field, and copy it to the "Phone Numbers" field in another table called "Client Contacts", and allow me to associate the "SRC" phone number with an existing "Company" in the "Client Contacts" table.
Basically, what I'm looking to do is take the caller ID info of previous calls, and have an easy way of copying the phone numbers out of that table, and associating them with an existing company and phone number in our "Client Contacts" table. We have to be able to track phone calls for billing purposes, and it is extremely handy to be able to click on a client of ours in Access, and see all the related phone calls associated with that client. It would be easy to enter in if the client only called from one number, but that usually isn't the case.
Phone-Calls-Experts-Exchange-Questio.png
We have a Microsoft Access Database with an SQL backed that we use in house for managing our ticketing system. A former employee put it together, we love it, it has worked great for years.
I'd like to preface this with the fact that I myself don't know much about programming or Access, but just enough to figure things out as we'd like to add to or modify the program. Oddly, it has become fun and educational to figure it out on my own.
I am a little stuck on one item that we'd like to implement.
We have a form called "Phone Calls" which pulls records from a table called "CDR". Within this database, there is a field called "SRC" that contains the Caller ID number of a client who called.
I would like to be able to click on the "SRC" field within this form, and have a macro/vb script/something allow me to take the phone number that is in the "SRC" field, and copy it to the "Phone Numbers" field in another table called "Client Contacts", and allow me to associate the "SRC" phone number with an existing "Company" in the "Client Contacts" table.
Basically, what I'm looking to do is take the caller ID info of previous calls, and have an easy way of copying the phone numbers out of that table, and associating them with an existing company and phone number in our "Client Contacts" table. We have to be able to track phone calls for billing purposes, and it is extremely handy to be able to click on a client of ours in Access, and see all the related phone calls associated with that client. It would be easy to enter in if the client only called from one number, but that usually isn't the case.
Phone-Calls-Experts-Exchange-Questio.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You guys did it! Thank you!
You are welcome!
/gustav
/gustav
ASKER
When I enter this code in and try it, I get a message that says:
Run-time error '3622'
You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column.
I'm assuming there is a detail or two more you may need from me regarding my setup? : )