Beatrice-
Sorry, missed that. A 429 is "ActiveX component can't create object" - but there's no explanation as to why.
Fire up RegEdit and see if you can find "Skype4Com.Skype" under HKEY_LOCAL_MACHINE\SOFTWARE\Classes. If not, then the dll didn't get registered correctly.
Another thing to try is to add the library under Tools / References and see if you can directly declare and compile the object.
Dim objSkype as Skype4Com.Skype
Set objSkype = New Skype4Com.Skype
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 3:28 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: RE: [MS_AccessPros] Run-Time Error '429': ActiveX component cannot create object
Hi John,
like i said in my post, I have already done the .dll registration and it shown as successful. so that's not where the problem is. can you think of anything else.
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 (4) |
Tidak ada komentar:
Posting Komentar