• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 437
  • Last Modified:

Access 2003 & Skype

I have designed a client contact database.
I have added a callto: button on the database so that I can call directly through skype. Is their ayway to do any of the following:-
1, Record the call and using VBA save the recording with a specific filename and add a hyperling to a record.  (ie the notes table)
2, update the notes table automatically with the outcome of the call (eg. call time, connection, busy, wrong number etc).
Any help at all would be greatly appreciated.
0
s7uart
Asked:
s7uart
  • 2
  • 2
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
s7uart,

If your ultimate question is: "is there an "Easy" way to do this"?
Then the answer is: No.

To "Automate" skype to the level you are requesting will probably require a "Custom" application.
Not something that someone here can throw together in a few posts.

You can certainly obtain a third party Utility to Record the call, and start up this utility through Access VBA.
http://www.extralabs.net/skype-recorder.htm
http://labnol.blogspot.com/2006/06/how-to-record-skype-conversations.html
http://www.rizwanashraf.com/2009/04/04/record-skype-call-a-simple-utility-to-record-skype-conversations/
...But, how VBA triggers, monitors, and stores the details of this call is another story.

Your best bet is to first contact Skype directly, and find out if what you are asking is even possible in the current version.

Also check the Skype Developer resources regularly:
https://developer.skype.com/
https://developer.skype.com/Download

;-)

JeffCoachman
0
 
darbid73Commented:
I certainly agree that it is not going to be easy.

I found your question interesting though.

If you have any hope of doing this direclty with skype you are going to need to try and reference the sykpe API -  https://developer.skype.com/Docs/ApiDoc/FrontPage

If MSAccess lets you get that far and it exposes the skype objects,methods and functions then you are in with a chance.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Yep, that was my hope as well.

;-)
0
 
darbid73Commented:
by the way - something that we missed or it was not know then - skype is doing COM compliant dlls.

http://blogs.skype.com/devzone/2008/03/excel_spreadsheet_that_sends_s.html#more
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now