Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Run Time 429: ActiveX Cannot create object
Okay, that's got it. Now, what's REALLY driving me crazy is wondering why it worked for two weeks before blowing up.- ohershey
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Run Time 429: ActiveX Cannot create object
I have a module, built into an Access form using VBA, which calls the word application object. A typical example is Word.Application.ScreenUpdating = False This worked fine on Friday, when I left. Now, every time I try to compile, I get Run Time Error 429: ActiveX can't create object. I did...- ohershey
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Application.ScreenUpdating won't compile properly
Beautiful. That was exactly what I needed. I'm so used to just calling it with: Application.ScreenUpdating = False I didn't realize that I needed to call it as: Word.Application.ScreenUpdating = False from MS Access. Thanks!- ohershey
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Application.ScreenUpdating won't compile properly
A common issue I seem to encounter quite often in VBA is that a method or property will not show in the object browser and/or won't compile. I often find that, after flailing around a bit, turning on the correct reference library makes the problem go away. Is there a resource somewhere that...- ohershey
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
