429 ActiveX Component Can't Open Object

[Guest]

While in a form, that we use to input data, I am able to run a report in PDF
form. I also have an Export to Excel button in the toolbar and when I click
on it I get a "429 ActiveX Component Can't Create Object" error. In other
areas of the database I am able to export to excel with running a query that
puts the data into an excel sheet. All of the information on this error I
can find talks about the component not being registered. I am not sure how
to check for this or to register the excel file. This could have happened
with an upgrade to Office 2003, but not sure why that would be the case. Is
there code that goes behind the toolbar export to excel function?

Thanks

 

[Guest]

I received this error yesterday but in MS Word not MS Excel. I resolved it
by re-enabling an ad-in that was suposed to be loaded. I checked Excel and
the same option is there as well.

Goto Help>About Microsoft Excel Help>Disabled Items>Highlight any disabled
and click "Enable".

Like I said I did this in word but it worked form me with the same 429 Error

Kevin

 

[Guest]

Thanks for the information but there were no diasbled items in my list.

 

[Tony Toews [MVP]]

While in a form, that we use to input data, I am able to run a report in PDF
form. I also have an Export to Excel button in the toolbar and when I click
on it I get a "429 ActiveX Component Can't Create Object" error.

You probably need to register the DAO dll using regsvr32. For example
regsvr32 "C:\Program Files\Common Files\Microsoft
Shared\DAO\DAO350.DLL" or DAO360.DLL

ACC: Error Message: ActiveX Component Can't Create Object [Q296205]
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q296205

ACC2000: Error Message: ActiveX Component Can't Create Object
http://support.microsoft.com/support/kb/articles/q296/2/04.asp

ACC2002: Err Msg: "ActiveX Component Can't Create Object"
http://support.microsoft.com/support/kb/articles/q304/1/73.asp

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

Thanks Tony,
I registered the 350.dll item and checked the references and there were none
that were missing. I am still getting the error. For some reason I keep
thinking it has to do with the MS Excel reference. This reference points to
the excel.exe application on the C drive. When I uncheck this reference and
go in and try and run the export, nothing happens. When I recheck the box, I
get the error. Does that mean anything to anyone? Thanks in advance.
--
TG

While in a form, that we use to input data, I am able to run a report in PDF
form. I also have an Export to Excel button in the toolbar and when I click
on it I get a "429 ActiveX Component Can't Create Object" error.

You probably need to register the DAO dll using regsvr32. For example
regsvr32 "C:\Program Files\Common Files\Microsoft
Shared\DAO\DAO350.DLL" or DAO360.DLL

ACC: Error Message: ActiveX Component Can't Create Object [Q296205]
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q296205

ACC2000: Error Message: ActiveX Component Can't Create Object
http://support.microsoft.com/support/kb/articles/q296/2/04.asp

ACC2002: Err Msg: "ActiveX Component Can't Create Object"
http://support.microsoft.com/support/kb/articles/q304/1/73.asp

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tony Toews [MVP]]

Thanks Tony,
I registered the 350.dll item

If A2000 or newer you want to register DAO360.DLL. My posting
certainly wasn't clear on that.

I am still getting the error. For some reason I keep
thinking it has to do with the MS Excel reference. This reference points to
the excel.exe application on the C drive. When I uncheck this reference and
go in and try and run the export, nothing happens. When I recheck the box, I
get the error.

That's quite possible. What version of Excel do you have installed?
What version of Excel is that reference pointing to? You stated in
your original posting that you upgraded to Access 2003 so you likely
upgraded the Excel version too.

Also my standard blurb on late binding follows so you can reduce the
chances of this happening in the future.

Late binding means you can safely remove the reference and only have
an error when the app executes lines of code in question. Rather than
erroring out while starting up the app and not allowing the users in
the app at all. Or when hitting a mid, left or trim function call.

You'll want to install the reference if you are programming or
debugging and want to use the object intellisense while in the VBA
editor. Then,. once your app is running smoothly, remove the
reference and setup the late binding statements.

Sample code:
' Declare an object variable to hold the object
' reference. Dim as Object causes late binding.
Dim objWordDoc As Object
Set objWordDoc = CreateObject(" Word.Document")

For more information including additional text and some detailed links
see the "Late Binding in Microsoft Access" page at
http://www.granite.ab.ca/access/latebinding.htm

Tony


--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm