Beatricz-
Is Skype4COMLib the name of the library or the name of the object? That looks like a library name.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of emmanuelbeatrice@hotmail.com
Sent: Saturday, November 30, 2013 11:50 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] RE: Run-Time Error '429': ActiveX component cannot create object
Hi John,
yes I have load up skype object from the start- - when i look into the object browser, as you suggested, "Skype4COMLib" shows up but "Skype4COM" doesn't-- i am not sure if they are one or the same- but the one that shows up on the object browser (|Skype4COMLib) still gives me the run-time '429' error. So,I'm stuck either way.
thanks in advance.
Beatricz
---In ms_access_professionals@yahoogroups.com, <JohnV@...> wrote:
Beatricz-
Did you load the Skype library in Tools / References? If yes, then when you use the Object Browser on that library, does it show a Skype object? If not, then that's your problem.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of emmanuelbeatrice@...
Sent: Saturday, November 30, 2013 7:21 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: RE: [MS_AccessPros] Run-Time Error '429': ActiveX component cannot create object
Hi John.
I did have an object reference in vba through tool menu.As you suggested, I've checked on regedit and the library is there with a key.
The problem is two-fold: First of all, I cannot declare and compile successfully with 'Skype4COM.Skype;- it tells me that 'user-defined type not define' message even though Skype4COM is properly referenced and registered. Second of all, when I declare with 'Skype4COMLib.Skype', it compiles just fine and the objects show in the vba intellisense, however, i get the run-time error 429.
the following code-declare, compile successfully and objects are visible in intellisense but it gives me the run-time error '429'
Dim oSkype As SKYPE4COMLib.Skype
Dim oCall As SKYPE4COMLib.Call
Dim oCon As SKYPE4COMLib.Conference
Set oSkype = New SKYPE4COMLib.Skype
If Not oSkype.Client.IsRunning Then
oSkype.Client.Start
End If
this code does't declare and compile successfully and gives me the message 'user-defined type not defined':
Dim objSkype As Skype4Com.Skype
Set objSkype = New Skype4Com.Skype
it tells me that 'user-defined type not defined'
What else, in your opinion, could be done to overcome this hurdle?
Thanks,
Beatricz
---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote:
Beatrice-
For VBA to be able to "see" an object like "Skype4COM.Skype", the dll must be registered in Windows. Try using Regsvr32.
http://stackoverflow.com/questions/4897685/how-do-i-register-a-dll-on-windows-7-64-bit
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of emmanuelbeatrice@...
Sent: Friday, November 29, 2013 5:45 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Run-Time Error '429': ActiveX component cannot create object
Hi, I am trying to use Skype4COM api to handle my callings in access database. and i have done all the proper .dll registrations and object referencing. However, each time the compiler gets to the line: 'Set oskype = CreateObject("Skype4COM.Skype")', it gives me the '429' run time error- no matter whatever way - declare the object. I am using MS Access 2013, both 64-bits. here below is a sample of my code. I ran out of possible troubleshooting ideas on what may cause this run-time error. thank you in advance, Beatricz
Private Sub Call_Click()
Set oskype = CreateObject("Skype4COM.Skype")
If Not oskype.Client.IsRunning Then
oskype.Client.Start
End If
Set oUser = oskype.User("User1")
Set oCall = oskype.PlaceCall(me.Number)
End Sub
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (8) |
Tidak ada komentar:
Posting Komentar